After installing a WebSphere Application Server fixpack you might encounter and error with you JDBC XA datasources.
In the SystemOut.log you will see the following error messages.
[9/19/24 10:03:05:223 CEST] 0000005f WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: “”.
[9/19/24 10:03:05:224 CEST] 0000005f WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMERR (-3). Exception is:
[9/19/24 10:03:05:224 CEST] 0000005f XARminst E WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@e632a225. The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:730)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:1149)
at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:141)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:774)
at com.ibm.tx.jta.impl.PartnerLogTable.recover(PartnerLogTable.java:433)
at com.ibm.tx.jta.impl.RecoveryManager.resync(RecoveryManager.java:1586)
at com.ibm.tx.jta.impl.RecoveryManager.performResync(RecoveryManager.java:2348)
at com.ibm.ws.tx.jta.RecoveryManager.performResync(RecoveryManager.java:120)
at com.ibm.tx.jta.impl.RecoveryManager.run(RecoveryManager.java:2301)
at java.lang.Thread.run(Thread.java:825)
The problem is that there are transaction information stored in the WebSphere profile directory. So you need to delete these under the following structure.
<WebSphere Application Server_install_root>\profiles\<PROFILE_NAME>\tranlog\<CELL_NAME>\<NODE_NAME>\<SERVER_NAME>\transaction
Stop the WebSphere server before deleting all files and folder under this path.