XA Branch Cannot See Commited Data from Another XA Branch during 2PC XA Transaction using 2 Data Sources on Same Database (Doc ID 2125991.1)

Last updated on APRIL 12, 2016

Applies to:

JDBC - Version 11.2.0.4.0 and later
Information in this document applies to any platform.

Symptoms

An intermittent issue related to read only optimization of two phase commit ( 2PC) within Oracle database is experienced.
The IBM BPM 8.5 transaction manager uses 2 Oracle XA data sources. Both data sources connect to the same 11.2.0.4 database running on the IBM AIX platform.

Transaction 1 on one data source is being processed, then commits to the database (part of the transaction is an insert into a processContext table).
• The BPEL engine will trigger an onward navigation (in-memory) message as part of the afterCompletion processing.
• The in-memory message is being picked up by a worker thread, which then starts transaction 2.
• Transaction 2  on the second data source attempts to do a so-called dummy update on the processContext entry in order to "lock" the process instance.
• However, the update returns with "no rows updated", i.e. transaction 2 is not able to see the data supposedly committed by transaction 1

 





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