Writing File Adapter Configured for High Availability Loses Messages Under Load
(Doc ID 1128705.1)
Last updated on NOVEMBER 03, 2016
Oracle(R) BPEL Process Manager - Version 184.108.40.206.0 and later Information in this document applies to any platform.
***Checked for relevance on 23-July-2013***
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: 220.127.116.11 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>
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