This discussion is archived
2 Replies Latest reply: Jun 5, 2013 3:11 AM by 1012739 RSS

XAResource.XAER_RMFAIL start() failed on resource

1009443 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points