My Oracle Support Banner

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

Last updated on APRIL 03, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution

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