2 Replies Latest reply: Jun 5, 2013 5:11 AM by 1012739 RSS

    XAResource.XAER_RMFAIL start() failed on resource

    1009443
      We are getting following error in production system. What may be the cause of this issue?

      com.ekaplus.common.exception.SystemException: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMERR start() failed on resource 'MyPool_EKA8X_QA': XAER_RMERR : A resource manager error has occured in the transaction branch
      oracle.jdbc.xa.OracleXAException
           at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1110)
           at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)
           at weblogic.jdbc.wrapper.VendorXAResource.start(VendorXAResource.java:50)
           at weblogic.jdbc.jta.DataSource.start(DataSource.java:729)
           at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1231)
           at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1164)
           at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:285)
           at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:522)
           at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:449)
           at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1599)
           at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1503)
           at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:446)
           at weblogic.jdbc.jta.DataSource.connect(DataSource.java:403)
           at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:364)
           at com.ekaplus.common.db.ContainerConnectionProvider.getConnection(ContainerConnectionProvider.java:79)
           at com.ekaplus.dao.common.ConnectionManager.getDSConnection(ConnectionManager.java:24)
           at com.ekaplus.dao.common.ConnectionManager.getConnection(ConnectionManager.java:14)
           at com.ekaplus.dao.common.JdbcDAO.getConnection(JdbcDAO.java:372)
           at com.ekaplus.asyncAlertReminder.dao.AlertReminderBaseDAO.getConnection(AlertReminderBaseDAO.java:26)
           at com.ekaplus.asyncAlertReminder.dao.AlertEventMasterDAO.findBySearchCriteria(AlertEventMasterDAO.java:265)
           at com.ekaplus.asyncAlertReminder.service.engine.alertprocessor.OperationalAlertProcessorService.initialize(OperationalAlertProcessorService.java:151)
           at com.ekaplus.asyncAlertReminder.service.engine.alertprocessor.AlertListener.onMessage(AlertListener.java:118)


      We have tried following but no resolution could be found with these changes.

      increase MaxXACallMillis value to 600000 on JTA Advanced settings.
      Increase max pool size from 100 to 150.
      Please enable set XA transaction timeout configuration for MyPool data source and let timeout value remain 0.

      Most of the stack traces logged when this exception is raised, point to JMS queue listener making DB calls using XA pool connection. However, JMS transaction factory is non-XA.

      R,
      Vineet
        • 1. Re: XAResource.XAER_RMFAIL start() failed on resource
          Joe Weinstein-Oracle
          Many things that may be to do with the ill health of the connection or the DBMS.
          It cannot be resolved here. Open an official support case and they will instruct
          you on producing debug logging for JTA.
          • 2. Re: XAResource.XAER_RMFAIL start() failed on resource
            1012739
            Hi mates,

            Did you finally manage to solve this issue? We are facing a very similar one, but with a transaction related to SqlJmsProvider. The transactions related to the message polling are very light and shouldn't be expiring.

            Do you have any suggestion about this?

            We have our app (ATG10.0.1deployed in WebLogic10.3.

            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider --- java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMFAIL start() failed on resource 'ATGProductionDS_SDG': XAER_RMFAIL : Resource manager is unavailable
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider oracle.jdbc.xa.OracleXAException
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1110)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.wrapper.VendorXAResource.start(VendorXAResource.java:50)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.jta.DataSource.start(DataSource.java:729)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1231)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1164)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:285)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:522)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:449)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1599)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1503)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:446)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.jta.DataSource.connect(DataSource.java:403)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:364)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlTopicManager.flagWithStatement(SqlTopicManager.java:986)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlTopicManager.flagNewEntries(SqlTopicManager.java:872)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlTopicManager.pollForNewEntries(SqlTopicManager.java:816)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlJmsManager.poll(SqlJmsManager.java:1598)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlJmsManager.performScheduledTask(SqlJmsManager.java:908)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.service.scheduler.ScheduledJob.runJobs(ScheduledJob.java:441)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.service.scheduler.Scheduler$2handler.run(Scheduler.java:760)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1604)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1503)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:446)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.jta.DataSource.connect(DataSource.java:403)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:364)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlTopicManager.flagWithStatement(SqlTopicManager.java:986)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlTopicManager.flagNewEntries(SqlTopicManager.java:872)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlTopicManager.pollForNewEntries(SqlTopicManager.java:816)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlJmsManager.poll(SqlJmsManager.java:1598)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlJmsManager.performScheduledTask(SqlJmsManager.java:908)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.service.scheduler.ScheduledJob.runJobs(ScheduledJob.java:441)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.service.scheduler.Scheduler$2handler.run(Scheduler.java:760)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1522)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:446)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.jta.DataSource.connect(DataSource.java:403)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:364)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlTopicManager.flagWithStatement(SqlTopicManager.java:986)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlTopicManager.flagNewEntries(SqlTopicManager.java:872)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlTopicManager.pollForNewEntries(SqlTopicManager.java:816)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlJmsManager.poll(SqlJmsManager.java:1598)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.dms.sql.SqlJmsManager.performScheduledTask(SqlJmsManager.java:908)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.service.scheduler.ScheduledJob.runJobs(ScheduledJob.java:441)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider at atg.service.scheduler.Scheduler$2handler.run(Scheduler.java:760)
            **** Error Tue Jun 04 07:29:57 BST 2013 1370327397440 /atg/dynamo/messaging/SqlJmsProvider

            Thank you very much.

            Edited by: 1009736 on 05-Jun-2013 03:11