Re: transaction or savepoint rollback required
Date: Fri, 12 May 2017 18:15:22 +0000
Message-ID: <DF4PR84MB01244C4FAED68AE36FA9662ECCE20_at_DF4PR84MB0124.NAMPRD84.PROD.OUTLOOK.COM>
Sanjay, when a distributed transaction fails it has always been the responsibility of the calling program to issue an explicit rollback command. Fix the program code to do so then determine why the transaction is failing to begin with.
Did you list the full error stack returned to the program?
Mark Powell
Database Administration
(313) 592-5148
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sanjay Mishra <dmarc-noreply_at_freelists.org> Sent: Friday, May 12, 2017 11:04:18 AM
To: Oracle-L Freelists
Subject: transaction or savepoint rollback required
Has anyone experienced ths issue with distributed query where I am running a stored procedure but will have mutliple remote database link used including some insert remotely. Working fine but suddenly stopped working and has no savepoint in the code and getting error
ORA-02067: transaction or savepoint rollback required ORA-02055: distributed update operation failed; rollback required
There is no error on existing as well as on remote database in dba_2pc_pending. Any other way to check and rollback or so as it is now constantly generating the same error with every execution
Any help is appreciated
Tx
Sanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 12 2017 - 20:15:22 CEST