0 Replies Latest reply on Apr 18, 2015 11:28 PM by rony Pal

    Recovery Manager cannot recover pending transactions:ORA-01031: insufficient privileges ; JBOSS EAP 6.1.1

    rony Pal Newbie

      Hello


        We have a webservice deployed in JBOSS EAP 6.1.1 and Database in use is Oracle 11g.

        At some point of time the Application was restarted when a transaction was in progress.


        After restart, it is continuously logging the below message and when I checked the Oracle Database, I found one transaction is in pending state from DBA_2PC_pending table

        I can understand the recovery manager is trying to rollback the transaction but unable to do it.

        There is no change in credential in the configuration files.

        Need your help to figure out what could be wrong and how to get rid of this issue.

        Appreciate your help


      11:27:54,893 ERROR [stderr] (Periodic Recovery)         ... 8 more


      11:30:04,916 ERROR [stderr] (Periodic Recovery) oracle.jdbc.xa.OracleXAException
      11:30:04,917 ERROR [stderr] (Periodic Recovery)         at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1213)
      11:30:04,917 ERROR [stderr] (Periodic Recovery)         at oracle.jdbc.xa.client.OracleXAResource.rollback(OracleXAResource.java:979)
      11:30:04,917 ERROR [stderr] (Periodic Recovery)         at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.rollback(XAManagedConnection.java:342)
      11:30:04,918 ERROR [stderr] (Periodic Recovery)         at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.rollback(XAResourceWrapperImpl.java:186)
      11:30:04,918 ERROR [stderr] (Periodic Recovery)         at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.handleOrphan(XARecoveryModule.java:738)
      11:30:04,919 ERROR [stderr] (Periodic Recovery)         at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoverySecondPass(XARecoveryModule.java:644)
      11:30:04,919 ERROR [stderr] (Periodic Recovery)         at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.bottomUpRecovery(XARecoveryModule.java:417)
      11:30:04,920 ERROR [stderr] (Periodic Recovery)         at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkSecondPass(XARecoveryModule.java:194)
      11:30:04,920 ERROR [stderr] (Periodic Recovery)         at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:789)
      11:30:04,921 ERROR [stderr] (Periodic Recovery)         at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:371)
      11:30:04,921 ERROR [stderr] (Periodic Recovery) Caused by: java.sql.SQLSyntaxErrorException:
      ORA-01031: insufficient privileges


      11:30:04,921 ERROR [stderr] (Periodic Recovery)


      11:30:04,922 ERROR [stderr] (Periodic Recovery)         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

       

       

      P.S: My experience with JBOSS is pretty minimal