ETL Error "ORA-02049: timeout: distributed transaction waiting for lock"
(Doc ID 2559744.1)
Last updated on NOVEMBER 20, 2023
Applies to:
Primavera Data Warehouse - Version 17.12.2.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run ETL
the following error occurs.
ERROR
-----------------------
2019-03-22 16:58:03.524 [Thread-83] INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 147
2019-03-22 16:58:03.524 [Thread-83] INFO ETL.Message - Exception: Error during extract for table W_ROLE_LIMIT_FS: ORA-02049: timeout: distributed
2019-03-22 16:58:03.524 [Thread-83] INFO ETL.Message - (100,ROLEAVAILABILITY,W_ROLE_LIMIT_FS,n/a,n/a)
2019-03-22 16:58:03.524 [Thread-83] INFO ETL.Message - DECLARE
2019-03-22 16:58:03.524 [Thread-83] INFO ETL.Message - *
2019-03-22 16:58:03.524 [Thread-83] INFO ETL.Message - ERROR at line 1:
2019-03-22 16:58:03.524 [Thread-83] INFO ETL.Message - ORA-02049: timeout: distributed transaction waiting for lock
2019-03-22 16:58:03.524 [Thread-83] INFO ETL.Message - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 209
2019-03-22 16:58:03.524 [Thread-83] INFO ETL.Message - ORA-06512: at line 4
2019-03-22 19:27:39.165 [main] ERROR ETL.Message - The SQL script W_ROLE_LIMIT_FS.sql failed
2019-03-22 19:27:39.165 [main] INFO ETL.Progress - Step 16/63 Part 2/3 - FAILED (1)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ETL
2. See it is in failed status
3. See error in the logs
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run ETL successfully.
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 |
Cause |
Solution |