My Oracle Support Banner

Heavy RIB Load, Lock Held By In-Doubt Distribution Transaction Ora-01591 Error Received (Doc ID 412854.1)

Last updated on AUGUST 17, 2018

Applies to:

Oracle Retail Integration Bus - Version 11.0 to 11.1 [Release 11]
Information in this document applies to any platform.
Checked for relevance on 29-Oct-2014


Symptoms

On Oracle Retail Integration Bus (RIB) 11 and Retail Merchandising System (RMS) 10.1.9 when attempting to consume a high volume of messages through "ewXOrderToRMS" and "ewXTransferToRMS", the following error may occur:

Error:

 

"javax.transaction.xa.XAException: XA TransactionManager
ewXTransferToRMS/colXTransferToRMS{AC5AA4E6-D391-11D9-A45C-CBE4675EE6D4}: At least one resource manager failed to rollback. Reason(s): javax.transaction.xa.XAException: javax.jms.JMSException:Could not rollback, connection may be dropped
at com.stc.common.collabService.LoglessTC$TransactionImpl.rollback(LoglessTC.java(Compiled Code))
at com.stc.common.collabService.LoglessTC$TransactionImpl.prepare(LoglessTC.java(Compiled Code))
at com.stc.common.collabService.JXACoordinator.prepare(JXACoordinator.java(Compiled Code))
at
com.stc.common.collabService.JTransactionManagerImpl.xaPrepare(JTransactionManagerImpl.java(Inlined Compiled Code))
at
com.stc.common.collabService.JCCollabControllerImpl.translate(JCCollabControllerImpl.java(Compiled Code))
com.stc.common.collabService.CollabConnException: XA TransactionManager
ewXTransferToRMS/colXTransferToRMS{AC5AA4E6-D391-11D9-A45C-CBE4675EE6D4}: At least one resource manager failed to rollback. Reason(s): javax.transaction.xa.XAException: javax.jms.JMSException: Could not rollback, connection may be dropped: <unknown>
at com.stc.common.collabService.JXACoordinator.raise(JXACoordinator.java(Compiled Code))
at com.stc.common.collabService.JXACoordinator.prepare(JXACoordinator.java(Compiled Code))
at
com.stc.common.collabService.JTransactionManagerImpl.xaPrepare(JTransactionManagerImpl.java(Inlined Compiled Code))
at
com.stc.common.collabService.JCCollabControllerImpl.translate(JCCollabControllerImpl.java(Compiled Code))
com.stc.common.collabService.CollabConnException: [colXTransferToRMS] JCCollabControllerImpl
JCCollabControllerImpl::translate(): Error in executing translate method
at
com.stc.common.collabService.JCCollabControllerImpl.translate(JCCollabControllerImpl.java(Compiled Code))"

Steps To Reproduce:

  1. Perform enough work in Advanced Inventory Planning (AIP) to generate over 130,000 transfers.
  2. Run the batch that queues the publishing of transfer messages to RIB.
  3. Use RIB Diagnostic & Monitoring Toolkit (RDMT) to monitor the total number of messages on the JMS.
  4. Note that as the total number of JMS messages nears 100k (one test noted 99874 at time of failure), the processing of messages will halt, and the XA indoubt problems will begin on the RMS database (DB).

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.