Asked • 07/01/19

ORA-24756: transaction does not exist?

Am doing a distributed update and I get this ORA-24756 error: DISTRIB TRAN bea1.67AA54355C4A74ECDEE0 is local tran 6.42.332492 (hex=06.2a.512cc) insert pending prepared tran, scn=8151148567799 (hex=769.d6509cf7) Wed Jan 30 16:45:02 EAT 2015 Errors in file /oradata/sfapdb/bdump/sfapdb_reco_2739.trc: ORA-24756: transaction does not exist oracle.jdbc.xa.OracleXAExceptionSQLException: ORA-24756: transaction does not exist. This error is from a failed two-phase commit I also found out there are some records (trans_id = "6.42.332492") in SYS.PENDING_TRANS$/ SYS.PENDING_SESSION$/dba_2pc_pending with "prepare" status. This transaction is launched from a Weblogic Server via JDBC.\\ How do I resolve this ORA-24756 error?

1 Expert Answer

By:

Ram K. answered • 07/16/19

Tutor
New to Wyzant

SQL | Oracle | Calculus | Algebra

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.