Topic
  • 1 reply
  • Latest Post - ‏2013-06-26T10:49:30Z by sridhar.patil
ariur
ariur
4 Posts

Pinned topic XAException in 8.5 version

‏2013-06-18T18:48:16Z |

Getting this messages(warnings) in console everytime. please help how to get rid of this. What configuration I need to do?

 

[6/18/13 18:13:20:163 IST] 00000014 InternalOracl I   DSRA8203I: Database product name : Oracle
[6/18/13 18:13:20:163 IST] 00000014 InternalOracl I   DSRA8204I: Database product version : Oracle Database 11g Release 11.1.0.0.0 - Production
[6/18/13 18:13:20:179 IST] 00000014 InternalOracl I   DSRA8205I: JDBC driver name  : Oracle JDBC driver
[6/18/13 18:13:20:179 IST] 00000014 InternalOracl I   DSRA8206I: JDBC driver version  : 10.2.0.1.0
[6/18/13 18:13:20:179 IST] 00000014 InternalOracl I   DSRA8212I: DataStoreHelper name is: com.ibm.websphere.rsadapter.Oracle10gDataStoreHelper@194e194e.
[6/18/13 18:13:20:179 IST] 00000014 WSRdbDataSour I   DSRA8208I: JDBC driver type  : ""
[6/18/13 18:13:20:257 IST] 00000014 WSRdbXaResour E   DSRA0304E:  XAException occurred. XAException contents and details are: The cause is               : null.
[6/18/13 18:13:20:257 IST] 00000014 WSRdbXaResour E   DSRA0302E:  XAException occurred.  Error code is: XAER_RMERR (-3).  Exception is: <null>
[6/18/13 18:13:20:257 IST] 00000014 XARminst      E   WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@21202120. The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.xa.XAException
    at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:525)
    at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:964)
    at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:138)
    at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:678)
    at com.ibm.ws.Transaction.JTA.PartnerLogTable.recover(PartnerLogTable.java:524)
    at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1826)
    at com.ibm.ws.Transaction.JTA.RecoveryManager.run(RecoveryManager.java:2458)
    at java.lang.Thread.run(Thread.java:797)

  • sridhar.patil
    sridhar.patil
    15 Posts

    Re: XAException in 8.5 version

    ‏2013-06-26T10:49:30Z  

    Is this resulting in any error in your transaction flow? We face the same issue in our local but never results in any txn failure. The reason for these messages is that the Oracle tries to recover the transactions which were terminated due to some server failure. Stop the server, delete the transaction and partner logs (the location you can search based on your application server ), start the server. You might not get these warnings this time.