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:
Primavera Analytics Cloud Service - Version 17.12.2.0 and laterInformation 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 "<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:
- Execute a Data Warehouse ETL for P6 EPPM (either via the scheduled time or manually executed)
- Note the failure status on the staretl1 > status tab
- Click the view log link for the failed ETL
- 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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |