Full stack of error message:
ORA-02050: transaction 11.9.23629 rolled back, some remote DBs may be in-doubt
is local tran 11.9.23629 (hex=0b.09.5c4d)
ORA-02051: another session or branch in same transaction failed or finalized
insert pending collecting tran, scn=7859252260641 (hex=725.dff06f21)
ORA-02050: transaction 11.9.23629 rolled back, some remote DBs may be in-doubt
is local tran 11.9.23629 (hex=0b.09.5c4d)
ORA-02051: another session or branch in same transaction failed or finalized
insert pending collecting tran, scn=7859252260641 (hex=725.dff06f21)
Developer reported this error while he is trying to perform an update.
First thought it might be due to exceeded connections over db links.
Later found it was due to Materialized View Log that was created on the base table on which the update was being performed. This log was not being refreshed due to some reasons and thus causing this failure.
Check the alert log for any additional/following errors for this ORA-02050 messages:
No comments:
Post a Comment