My Oracle Support Banner

RIB Transactions Fail with "ORA-24756: Transaction Does Not Exist" (Doc ID 2462657.1)

Last updated on JUNE 22, 2020

Applies to:

Oracle Retail Integration Bus - Version 14.1.3 and later
Information in this document applies to any platform.

Symptoms

RIB transactions getting failed and reported with ORA-24756 error :

From the Database, the recommendations was to review timeouts from the application:

The external Transaction Manager, in this case Weblogic, should be in control of XA transactions, so please review timeout settings.

The general recommendation per Note 338880.1 is:

Global transaction timeout > Session timeout, or SesTm > distributed_lock_timeout (Oracle database)

specifically: global transaction timeout -->  600
                  session timeout --> 600
                 distributed_lock_timeout:
SQL> alter system set distributed_lock_timeout=value scope=spfile;

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!


In this Document
Symptoms
Changes
Cause
Solution


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