Previous Topic: Limitations in Internet ExplorerNext Topic: Sorting Automation Objects


Oracle bug # 9347941

Important! When running with versions of the Oracle RDBMS prior to release 11.1.0.7, CA Process Automation would occasionally encounter the 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 freeze. Reset the process at the corresponding operator where the process is frozen to continue the process execution to complete. This infrequent issue 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 we recommended that sites using Oracle for their CA Process Automation databases run version 11.1.0.7 or 11.2.0.2 or higher.