SOA 11g: Error 'ORA-02049: timeout : distributed transaction waiting for lock' Using DB Adapter (Doc ID 1469506.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Symptoms

Current weblogic connection pool configurations:
Both DB Adapter connections are "oracle.jdbc.xa.client.OracleXADataSource" and connecting to RAC
When attempting to insert rows into two separate tables related with a foreign key with two different adapters
the following error occurs.

ERROR
-----------------------
"ORA-02049: timeout : distributed transaction waiting for lock."


STEPS
-----------------------
1. Service 1 (DatabaseAdapter 1)-->inserting into table1
2. Service 1-->calls service 2 through WSDL
3. Service 2 (DatabaseAdapter 2)--> updating table 2 (Important: table 2 has foreign key to table1, If foreign key dropped then error resolved)

 

Cause

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