Error: "ORA-12853: insufficient memory for PX buffers" And "ORA-04031: unable to allocate ### bytes of shared memory" When Executing The P6 ETL (ODI LOAD_PLAN_DAILY)

(Doc ID 2411762.1)

Last updated on JUNE 15, 2018

Applies to:

Primavera Analytics Cloud Service - Version and later
Information in this document applies to any platform.


When attempting to run the Data Warehouse ETL for a P6 EPPM datasource, the following error occurs causing the ETL to fail:

  [ERROR] WBS spread roll up, duration = 255 seconds
  [ERROR] 0 \-\ WBS Spread Roll Up
  [ERROR] 1 /-/ Procedure - WBS Spread Roll Up - SpreadRollupWbs
ODI-1228: Task Procedure-WBS Spread Roll Up-SpreadRollupWbs fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
Caused By: java.sql.SQLException: ORA-12801: error signaled in parallel query server P02E, instance acvingrrdbp011b:pva1p0462 (2)
ORA-12853: insufficient memory for PX buffers: current ###K, max needed ###K
ORA-04031: unable to allocate ### bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")
ORA-06512: at "STARUSER.SPREAD_ROLLUP_PKG", line 425
ORA-06512: at line 2

 at oracle.jdbc.driver.T4CTTIoer.processError(
 at oracle.jdbc.driver.T4CTTIoer.processError(

The issue can be reproduced at will with the following steps:

  1. Execute a Data Warehouse ETL for P6 EPPM (either via the scheduled time or manually executed)
  2. Note the failure status on the staretl1 > status tab
  3. Click the view log link for the failed ETL
  4. Note the failure detail which occurs.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms