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)
Last updated on JUNE 15, 2018
Applies to:Primavera Analytics Cloud Service - Version 220.127.116.11 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
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.
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