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 MAY 12, 2021

Applies to:

Symptoms

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

ERROR
-----------------------
  [ERROR] WBS spread roll up, duration = 255 seconds
  [ERROR] PROC_WBS_SPREAD_ROLL_UP
  [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 "<USER>.SPREAD_ROLLUP_PKG", line 425
ORA-06512: at line 2

 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)


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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.