EJB design: XAER_RMERR:occurred while invoking start on an XA Resource Adapte

  1. Getting the following error, after running the application for some time. The initial trasactions work fine. Error occurs after some hours of running.
    We are using WAS 6.1 with Oracle 11g. Stack trace is as below. Please let us know if anyone has faced similar issues with XA data sources.

    while trying to enlist resources from datasource jdbc/<DataSourceName>_XA with the Transaction Manager for the current transaction, and threw a ResourceException.9/23/10 13:08:31:826 EEST 00000043 WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are:The XA Error is : -3The XA Error message is : A resource manager error has occured in the transaction branch.The Oracle Error code is : 2045The Oracle Error message is: Internal XA ErrorThe cause is : null.9/23/10 13:08:31:828 EEST 00000043 WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMERR (-3). Exception is: <null>9/23/10 13:08:31:828 EEST 00000043 XATransaction E J2CA0027E: An exception occurred while invoking start on an XA Resource Adapter from dataSource jdbc/<DataSourceName>_XA, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54), data(0000012b3e10cd5d0000000100020e4e4b1f2fcf142d7b58096494b07dca94cfcfcc79480000012b3e10cd5d0000000100020e4e4b1f2fcf142d7b58096494b07dca94cfcfcc7948000000010000000000000000000000000022)}: oracle.jdbc.xa.OracleXAExceptionat oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1033)at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1417)at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1473)at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:145)

  2. I saw the same error message on Oracle DB 10g a while ago.

    You should upgrade your JDBC XA Client libraries to the latest version/patches.

    Also check 11g database logs for long running XA transactions.

    Kind regards


  3. Thanks for your reply Volker.

    Can you let me know the location where this Oracle logs for XA transactions will be available?