Question
Nordea
SE
Last activity: 2 Aug 2021 4:58 EDT
Oracle XA Data Source Support with Pega
Hi,
Whenever we use Oracle XA Datasource, we get below exception in the server log file. Is there any known issue of XA datasource with Pega?
[6/5/20 18:38:15:813 CEST] 0000006c XARminst E WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@d7e43010. 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:1111) at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:141) at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:748) at com.ibm.tx.jta.impl.PartnerLogTable.recover(PartnerLogTable.java:432) at com.ibm.tx.jta.impl.RecoveryManager.resync(RecoveryManager.java:1545) at com.ibm.tx.jta.impl.RecoveryManager.performResync(RecoveryManager.java:2291) at com.ibm.ws.tx.jta.RecoveryManager.performResync(RecoveryManager.java:119) at com.ibm.tx.jta.impl.RecoveryManager.run(RecoveryManager.java:2244) at java.lang.Thread.run(Thread.java:811)
Pegasystems Inc.
US
check this link: https://community.pega.com/support/support-articles/xaexception-error-code-xaerrmerr-3-logs
Nordea
SE
Hi Kevin,
Thanks for your quick response! As suggested in the support article, I deleted transaction folder (which eventually deletes partnerlogs directory as well), but error is still appearing during server startup:--
Hi Kevin,
Thanks for your quick response! As suggested in the support article, I deleted transaction folder (which eventually deletes partnerlogs directory as well), but error is still appearing during server startup:--
[6/8/20 9:34:43:099 CEST] 0000006d XARecoveryDat A WTRN0151I: Preparing to call xa recover on XAResource: PegaRULES [6/8/20 9:34:43:225 CEST] 0000006d InternalGener I DSRA8225I: DataSource JNDI name : jdbc/PegaRULES [6/8/20 9:34:43:226 CEST] 0000006d InternalGener I DSRA8203I: Database product name : Oracle [6/8/20 9:34:43:227 CEST] 0000006d InternalGener I DSRA8204I: Database product version : Oracle Database 12c Enterprise Edition Release Proprietary information hidden.0 - 64bit Production [6/8/20 9:34:43:227 CEST] 0000006d InternalGener I DSRA8205I: JDBC driver name : Oracle JDBC driver [6/8/20 9:34:43:228 CEST] 0000006d InternalGener I DSRA8206I: JDBC driver version : Proprietary information hidden.0 [6/8/20 9:34:43:228 CEST] 0000006d InternalGener I DSRA8218I: JDBC driver specification level : 4.2 [6/8/20 9:34:43:229 CEST] 0000006d InternalOracl I DSRA8212I: DataStoreHelper name is: com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper. [6/8/20 9:34:43:229 CEST] 0000006d WSRdbDataSour I DSRA8208I: JDBC driver type : 4 [6/8/20 9:34:43:235 CEST] 0000006d WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: "". [6/8/20 9:34:43:236 CEST] 0000006d WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMERR (-3). Exception is: <null> [6/8/20 9:34:43:236 CEST] 0000006d XARminst E WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@45cabd7e. 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:1111) at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:141) at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:748) at com.ibm.tx.jta.impl.PartnerLogTable.recover(PartnerLogTable.java:432) at com.ibm.tx.jta.impl.RecoveryManager.resync(RecoveryManager.java:1545) at com.ibm.tx.jta.impl.RecoveryManager.performResync(RecoveryManager.java:2291) at com.ibm.ws.tx.jta.RecoveryManager.performResync(RecoveryManager.java:119) at com.ibm.tx.jta.impl.RecoveryManager.run(RecoveryManager.java:2244) at java.lang.Thread.run(Thread.java:811)