My Oracle Support Banner

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

Last updated on OCTOBER 12, 2022

Applies to:

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


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
SQL> alter system set distributed_lock_timeout=value scope=spfile;




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

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