CA PPM 15.4.1 Upgrade - Datamart Extraction job fails

Document ID : KB000112106
Last Modified Date : 29/08/2018
Show Technical Document Details
Issue:
We are upgrading from CA PPM 15.4.1 from 14.4.

Post the upgrade to 15.4.1 the job fails.

Please see details in the logs below:

java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - Analyzing NBI_R_FACTS: ORA-12801: error signaled in parallel query server P01D ORA-12853: insufficient memory for PX buffers: current 130432K, max needed 8547984K ORA-04031: unable to allocate 65560 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool") ORA-06512: at "CLARITY.NBI_EXTRACT_SP", line 362 ORA-06512: at line 1java.sql.SQLExc 

 
Resolution:
Based on the error message revealed in your logs, this is not a PPM product issue.

Your DBA will need to resolve this problem at the Oracle DB server level.

CA Support cannot offer Oracle database administration advice.