Friday, January 28, 2011

Websphere - XA Transaction Error

Problem
[1/28/11 18:26:02:109 EST] 00000014 XARminst      E   WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@51ef51ef. The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.xa.XAException
    at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:526)
    at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:962)
    at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:137)
    at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:690)
    at com.ibm.ws.Transaction.JTA.PartnerLogTable.recover(PartnerLogTable.java:512)
    at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1949)
    at com.ibm.ws.Transaction.JTA.RecoveryManager.run(RecoveryManager.java:2457)
    at java.lang.Thread.run(Thread.java:832)


Solution


http://www.coderanch.com/t/414861/EJB-JEE/java/Help-XAException
http://www.ibm.com/developerworks/websphere/library/techarticles/0407_woolf/0407_woolf.html