Integration

Hello,

since we upgraded the Oracle DB to 11.2.0.1 we have one service that once in a while (semingly at random) encounters OTS 1001 errors. This service updates the DB in the Corba object deactivation, and that update fails with ORA-02051 when we get the OTS 1001 error.

The one service that gets these errors is unique in that it has the following chain of service calls:

1) Corba client A starts the transaction, then invokes an object in Corba server B.

2) The object in Corba server B has the method activation policy. It performs updates (DB and /Q) in the invocation, and then makes an invocation to another object in Corba server C.

3) The object in Corba server C performs additional updates (DB and /Q). It returns success.

4) The object in Corba server B also returns success after the invocation to C has completed. The deactivation of the object (in B) reports the ORA-02051 on the DB update.

5) The Corba client (A) receives success and attempts to commit. The commit fails (as evident from the OTS 1001), and the transaction is rolled back.

This service has existed for many years, and we have never had any problems, until the upgrade to 11.2.0.1.

There are other services that update in the deactivation, but they only involve the client (A) and first server (B). These work fine.

There are other server to server invocations (X to B to C), but they don't involve updates on deactivation. These work fine.

As mentioned earlier, the problem seems to occur at random, maybe about one out of 5 invocation of that service fail this way.

Tuxedo is 9.1. Oracle DB 11.2.0.1.

Errors:
10:57:10.284 Database execution error: DalStatement::execute ( ORA-02051: another session or branch in same transaction failed or finalized
105710.wblvshwpap1!DrepApp.5048.1.0: gtrid x0 x4e2d3e9d x8de8691: OTS_CAT:1001: WARN: xa_end() failed in pre-prepare phase with error = 100

Roger