ETL Error "ORA-02049: timeout: distributed transaction waiting for lock" (Doc ID 2559744.1)

Last updated on NOVEMBER 20, 2023

Applies to:

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

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