My Oracle Support Banner

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

Last updated on NOVEMBER 20, 2023

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

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
References


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