My Oracle Support Banner

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 17.12.2.0 and later
Information in this document applies to any platform.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.