Important! When running with versions of the Oracle RDBMS prior to release 11.1.0.7 CA Process Automation would occasionally hit known Oracle RDBMS defect 9347941 in which concurrent inserts of CLOB data where the individual column values exceed 52K bytes in size have such columns updated incorrectly with data past the 52K offset replaced by spaces. This issue has been seen using both 10g and earlier 11g versions of the Oracle RDBMS.
Symptom:
CA Process Automation process would become stuck. You need to reset the process at the corresponding operator where the process is stuck to continue the process execution to complete. This problem is infrequent and occurs only with extremely high rates of update contention.
Solution:
This has not been seen when running either version 11.1.0.7 or 11.2.0.2 of Oracle, and It is recommended that sites using Oracle for their CA Process Automation databases be running version 11.1.0.7 or 11.2.0.2 or later.
|
Copyright © 2014 CA.
All rights reserved.
|
|