SOA sync processes time out with a database error, 'ORA-02049: timeout: distributed transaction waiting for lock' (Doc ID 2125950.1)

Last updated on APRIL 12, 2016

Applies to:

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

Symptoms

On : 11.1.1.7.0 version, SOA Fusion Apps

The issue was discovered when using an out of the box Fusion composite when  executing a synchronous invoke within an asynchronous BPEL process .... the following error occurs.

ERROR

 The following error is reported when viewing the Composite Instance from Enterprise Manager (EM).

<summary>
Waiting for response has timed out. The conversation id is urn:A73D1900DF1311E5AF810B546206963F. Please check the process instance for detail.
</summary>
</part>
-<part name="detail">
<detail>
Waiting for response has timed out. The conversation id is urn:A73D1900DF1311E5AF810B546206963F. Please check the process instance for detail.
</detail>

Note: This error is recoverable from the Fusion Applciation Workbench - i.e. the Composite Instance is NOT in a critical/non-recoverable state.

An error is reported in the SOA log files:

SQLSyntaxErrorException: ORA-02049: timeout: distributed transaction waiting for lock

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