Writing File Adapter Configured for High Availability Loses Messages Under Load (Doc ID 1128705.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle(R) BPEL Process Manager - Version 11.1.1.2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 23-July-2013***

Symptoms

You have configured writing (outbound) file adapters in a High Availability environment using Database Mutex as specified in this document:

Oracle Fusion Middleware High Availability Guide
11g Release 1 (11.1.1)
Part Number E10106-08
Section:  5.10.2.2 Oracle File and FTP Adapters High Availability

The file adapter(s) append records to a file. It is noticed that not all of the appends are being completed, resulting in a loss of messages.

The following ORA-00060 database deadlock error message may be seen while running this scenario:

<bpelFault><faultType> <message>0</message></faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'Write' failed due to: Unable to acquire mutex for interaction. Unable to acquire mutex for interaction. Unable to acquire lock on resource "/var/opt/soa/data/SOA/file/file/Adapter~file" for "DatabaseMutex::acquireNoSave". ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution. </summary></part><part name="detail"><detail>ORA-00060: deadlock detected while waiting for resource </detail></part><part name="code"><code>null</code></part></remoteFault></bpelFault>

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