transaction or savepoint rollback required

  • From: "Sanjay Mishra" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "smishra_97" for DMARC)
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 12 May 2017 15:04:18 +0000 (UTC)

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
TxSanjay

Other related posts: