XA_COMMIT FAILS WITH ERRORS ORA-2054 AND ORA-2051 ON A ON COMMIT MVIEW (Doc ID 1096814.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 12th May 2013 ***


Symptoms

When invoking xa_commit from a Transactional Monitor like Tuxedo or Websphere, you can get errors ORA-2054 and ORA-2051 in the TM itself and alert.log file.
In addition to see you may see prepared transactions on dba_2pc_pending views as a consequence of this error.


On TM log we can see:

[4/21/10 10:25:12:425 CEST] 000019ba WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are:
The XA Error is : -3
The XA Error message is : A resource manager error has occured in the transaction branch.
The Oracle Error code is : 2054
The Oracle Error message is: Internal XA Error
The cause is : java.sql.SQLException: ORA-02054: transaction 10.10.55727 in-doubt
ORA-02051: another session in same transaction failed
.

 

[4/21/10 10:25:12:432 CEST] 000019be WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are:
The XA Error is : -3
The XA Error message is : A resource manager error has occured in the transaction branch.
The Oracle Error code is : 2054
The Oracle Error message is: Internal XA Error
The cause is : java.sql.SQLException: ORA-02054: transaction 9.13.56980 in-doubt
ORA-02051: another session in same transaction failed



In alert.log file we can see :

Following on-commit snapshots not refreshed :
MYTEST.MY_MVIEW

Error 2051 trapped in 2PC on transaction 9.13.56980. Cleaning up.
Error stack returned to user:
ORA-02054: transaction 9.13.56980 in-doubt
ORA-02051: another session in same transaction failed
Wed Apr 21 10:25:12 2010


In dba_2pc_pending and dba_2pc_neighbors we can see pending transactions.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms