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

Last updated on OCTOBER 25, 2016

Applies to:

Oracle WebLogic Integration - Version 8.1 and later
Information in this document applies to any platform.
Information in this document applies to any platform


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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms