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.
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