My Oracle Support Banner

Initial ETL Failed : ORA-20011: ORA-20010: ORA-12801: error signaled in parallel query server (Doc ID 2614406.1)

Last updated on NOVEMBER 26, 2019

Applies to:

Oracle Argus Insight - Version 8.2 and later
Information in this document applies to any platform.

Symptoms

On : 8.2 version, ETL.

Initial ETL failed in Production

After recent upgrade to Argus Safety Version 8.2.0.4 after initiating Initial ETL, it failed at 87%.


It was successful in Other Environments i.e. Dev, Test and Validation.

Error shown in MART_DATA_INSERT_LOG tables per below



Creating index pk_rpt_event_assess failed:
ORA-20011: ORA-20010: ORA-12801: error signaled in parallel query server XXXX
ORA-06512: at "APR_MART.PKG_PWR_UTIL", line 3557
ORA-06512: at "APR_MART.PKG_PWR_UTIL", line 3553
ORA-06512: at "APR_MART.PKG_PWR_UTIL", line 4002

 -- ERROR while processing p_create_object_from_saved_ddl at 23-sep-2019 2

ORA-12801: error signaled in parallel query server P00B
ORA-06512: at "APR_MART.PKG_PWR_UTIL", line 3557
ORA-06512: at "APR_MART.PKG_PWR_UTIL", line 3553
ORA-06512: at "APR_MART.PKG_PWR_UTIL", line 4002

 

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
References


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