"JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception"

Problem:

The following fault is returned in one of your SOA Suite 11g instances upon execution:

Non Recoverable System Fault :

Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception. insert failed. Descriptor name: [InsertEventStore.EventStoreHeader]. Caused by java.sql.SQLException: Cannot call Connection.rollback in distributed transaction. Transaction Manager will commit the resource manager when the distributed transaction is committed.. Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "0" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.

Solution:

This is related to a SOA Suite 11g component (e.g., BPEL, Mediator) that is using a database adapter that supports global transactions. Unless global transaction support is required, you should disable it. Not only will it resolve this error, but also improve performance.

1. Log in to the WebLogic Administration console.

2. Navigate to Home --> Summary of Deployments --> DbAdapter --> Summary of JDBC Data Sources --> <DataSource> --> Configuration --> Transaction

3. Uncheck 'Supports Global Transactions'

4. Bounce the SOA managed server(s)


Applicable Versions:

• Oracle SOA Suite 11g (11.1.1.x)

References:

• http://forums.oracle.com/forums/thread.jspa?threadID=926501