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