WLI - java.sql.SQLException: XA error: XAER_RMERR after Some Server Uptime (Doc ID 774731.1)

Last updated on MAY 15, 2023

Applies to:

Goal

DESCRIPTION:
The java.sql.SQLException: XA error: XAER_RMERR occurs after the sever is running for some time (1 day). If the server
is restarted, it will work fine for some time. Then the exception will occur again.

57626188 [ExecuteThread: '5' for queue: 'weblogic.kernel.Default'] DEBUG DebugLogger 1074871791562 - Inside
addHeaderEntry
java.sql.SQLException: XA error: XAER_RMERR : A resource manager error has occured in the transaction branch start()
failed on resource 'IPTXAPool': XAER_RMERR: A resource manager error has occured in the transaction branch
oracle.jdbc.xa.OracleXAException
        at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1159)
        at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:311)
        at weblogic.jdbc.wrapper.VendorXAResource.start(VendorXAResource.java:50)
        at weblogic.jdbc.jta.DataSource.start(DataSource.java:604)
        at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1069)
        at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1001)
        at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:203)
        at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:419)
        at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1230)
        at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1193)
        at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:371)
        at weblogic.jdbc.jta.DataSource.connect(DataSource.java:329)
        at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:298)
        at com.company.ipt.db.GenericDAO.getConnectionXA(GenericDAO.java:23)
        at com.company.ipt.db.ExcelDataLoaderDAO.addHeaderEntry(ExcelDataLoaderDAO.java:231)

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.