Ok, so go to the alert.log of the db that is hitting end of fie on
communication channel. See if you can determine the root cause of that
error.
-Mark
On Fri, May 12, 2017 at 3:39 PM, Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
Mark
Here is what is getting now
SQL> exec Webprocess_mkinv('14003331');
BEGIN Webprocess_mkinv('14003331')
*
ERROR at line 1:
ORA-02055: distributed update operation failed; rollback required
ORA-02068: following severe error from OPTIC
ORA-03113: end-of-file on communication channel
ORA-06512: at "invuser.pnttbl", line 31
ORA-06512: at "invuser.pntfail", line 89
ORA-06512: at line 1
Or
ERROR at line 1:
ORA-02067: transaction or savepoint rollback required
ORA-06512: at "invuser.pnttbl", line 12
ORA-06512: at "invuser.pntfail", line 52
ORA-06512: at "invuser.pnttrial", line 88
ORA-02055: distributed update operation failed; rollback required
ORA-02068: following severe error from OPTIC
ORA-03113: end-of-file on communication channel
ORA-06512: at "invuser.pntfail"
ORA-06512: at line 1
Sanjay
On Friday, May 12, 2017 2:16 PM, "Powell, Mark" <mark.powell2@xxxxxxx>
wrote:
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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
*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