My Oracle Support Banner

Error: "ORA-04021 Timeout Occurred While Waiting to Lock Object Error at STARUSER.REBUILD_INDEXES While Executing STARUSER.LOAD2DIMENSION (Doc ID 2468238.1)

Last updated on AUGUST 19, 2019

Applies to:

Primavera Analytics - Version 16.2.0.0 and later
Primavera Data Warehouse - Version 16.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When running ETL Process, it fails and the following error occurs in the logs:

ERROR
-----------------------
<09.07.2018 07:49:02> staretl [INFO] (Message) - ERROR at line 1:
<09.07.2018 07:49:02> staretl [INFO] (Message) - ORA-12801: error signaled in parallel query server P0FA, instance dm01dbadm01.dtt.domsedp3m.com:DWDVR1 (1)
<09.07.2018 07:49:02> staretl [INFO] (Message) - ORA-04021: timeout occurred while waiting to lock object
<09.07.2018 07:49:02> staretl [INFO] (Message) - ORA-06512: at "STARUSER.LOAD2DIMENSION", line 104
<09.07.2018 07:49:02> staretl [INFO] (Message) - ORA-06512: at line 4
<09.07.2018 07:49:02> staretl [INFO] (Message) - ORA-06512: at "STARUSER.REBUILD_INDEXES", line 30
<09.07.2018 07:49:02> staretl [INFO] (Message) - ORA-06512: at "STARUSER.LOAD2DIMENSION", line 82
<09.07.2018 07:49:02> staretl [INFO] (Message) - Exception: Error during load for table XXX: ORA-12801: error signaled in parallel
<09.07.2018 07:49:02> staretl [INFO] (Message) - (100,XXX_DS,XXX_D,n/a,n/a)
<09.07.2018 07:49:02> staretl [INFO] (Message) - DECLARE
<09.07.2018 07:49:02> staretl [INFO] (Message) - *


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ETL Process
2. Notice the errors

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the ETL Process successfully.

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.