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
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.