CSITransactionRolledbackException issued
 Technote (FAQ)
 
Problem
In WebSphere® Application Server V4.0 the following exception might be issued when Oracle is enlisted in an XA transaction:

org.omg.CORBA.TRANSACTION_ROLLEDBACK:
com.ibm.websphere.csi.CSITransactionRolledbackException:
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java(Compiled
Code))
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java(Compiled
Code))
...

A WebSphere JTS trace reveals that the transaction is rolled back due to the following exception:

Encountered an XA resource error during an XA end operation: {0} {1}
-3
oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:659)
at oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.java:301)
at com.ibm.ejs.jts.jta.XARminst.endAssociation(XARminst.java:365)

This indicates:
XAER_RMERR resource error -3 for Oracle 9i, or
"Io exception: End of TNS data channel", (SQLState=null, vendorCode=17002) for Oracle 8.1.7
 
Cause
The exception is caused by Oracle tight coupling transaction branches.
 
Solution
The solution to this problem involves applying patches to both Oracle and WebSphere:

For Oracle:

Oracle must be at least the 8.1.7.4 or 9.2.0.2 level and patch 2511780 (obtained from Oracle Corporation) must be applied. If a higher version of Oracle is used, you should verify with Oracle whether or not patch 2511780 is included.

For WebSphere:

For WebSphere, the Cumulative CM (Connection Manager) Interim Fix, dated 03-26-2003 or later, must be applied and a data source custom property called "transactionBranchesLooselyCoupled" must be set to "true"

When the WebSphere interim fix is applied and the custom property transactionBranchesLooselyCoupled is set correctly, the following message appears in the Application Server stdout:

CMXAResourceI W CONM6021W A Oracle JDBC provider property (TransactionLooselyCoupled) has been set. Oracle patch 2511780 must be applied before setting this property.

This message will appear even if patch 2511780 is applied. If it is applied, the message can be ignored. With the patch applied and transactionBranchesLooselyCoupled set to true, the problem should be resolved.

 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): HP-UX
Software version: 4.0
Software edition:
Reference #: 1109954
IBM Group: Software Group
Modified date: Jul 31, 2005