1 Reply Latest reply on May 31, 2018 5:46 PM by lafr

    wildfly-10.1.0 error in oracle db xa transaction recovery

    vaibhavkulkarni75
    vaibhavkulkarni75 May 31, 2018 3:45 PM

      Hi ,

      We are getting below error in oracle xa transaction recovery .

      We are using wildfly-10.1.0 and ojdbc6.jar (Oracle 11.2.0.3.0 JDBC 4.0 compiled with JDK6 on Mon_Jul_08_14:44:02_PDT_2013)

      Any idea how to resolve this issue?

       

      2018-05-30 00:01:32,823 WARN  [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_PROTO: oracle.jdbc.xa.OracleXAException

              at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1135)

              at oracle.jdbc.xa.client.OracleXAResource.rollback(OracleXAResource.java:941)

              at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.rollback(XAManagedConnection.java:346)

              at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.rollback(XAResourceWrapperImpl.java:196)

              at org.jboss.jca.core.tx.jbossts.XAResourceWrapperStatImpl.rollback(XAResourceWrapperStatImpl.java:160)

              at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.handleOrphan(XARecoveryModule.java:787) [narayana-jts-idlj-5.3.4.Final.jar:5.3.4.Final (revision: b7df0)]

              at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoverySecondPass(XARecoveryModule.java:692) [narayana-jts-idlj-5.3.4.Final.jar:5.3.4.Final (revision: b7df0)]

              at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.bottomUpRecovery(XARecoveryModule.java:431) [narayana-jts-idlj-5.3.4.Final.jar:5.3.4.Final (revision: b7df0)]

              at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkSecondPass(XARecoveryModule.java:215) [narayana-jts-idlj-5.3.4.Final.jar:5.3.4.Final (revision: b7df0)]

              at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:811) [narayana-jts-idlj-5.3.4.Final.jar:5.3.4.Final (revision: b7df0)]

              at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:377) [narayana-jts-idlj-5.3.4.Final.jar:5.3.4.Final (revision: b7df0)]

      Caused by: java.sql.SQLException: ORA-24763: transaction operation cannot be completed now

       

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)

              at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:675)

              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

              at oracle.jdbc.driver.T4CTTIOtxen.doOTXEN(T4CTTIOtxen.java:168)

              at oracle.jdbc.driver.T4CXAResource.doTransaction(T4CXAResource.java:746)

              at oracle.jdbc.driver.T4CXAResource.kputxrec(T4CXAResource.java:809)

              at oracle.jdbc.driver.T4CXAResource.doRollback(T4CXAResource.java:645)

              at oracle.jdbc.xa.client.OracleXAResource.rollback(OracleXAResource.java:936)

              ... 9 more