Global Transactions Are In Prepared State (Doc ID 1956509.1)

Last updated on AUGUST 19, 2024

Applies to:

Symptoms

We have enabled Global (XA) Transaction in J2EE Connector Architecture (JCA) Adapter.

Recently we have installed PS10. We have noticed that order which are raised from Siebel Customer Relationship Management (CRM) are getting successful but the global transaction involved in that transaction were in prepared state ( not in commit state). Due to this transaction is not getting commited and whenever there is an update to that accounts involved in failed transactions , dm_oracle is giving PIN_ERR_STORAGE error by giving below oracle errors

Steps to Reproduce the issue

1) Order raised from Siebel -> Order and Service Management (OSM) - > Application Integration Architecture (AIA) to terminate the services under account
2) TRANS_OPEN called with transaction IDs like 48801,6CDE9EB7D65BE50C6CCB,6569732F42524D
3) PCM_OP_CUST_SET_STATUS called for each service and output response sent to AIA
4) PCM_OP_SUBSCRIPTION_SET_BUNDLE called to change the bundle status to 3
5) TRANS_PREPARE called
6) TRANS_COMMIT called ( not sure transaction commited successfully or not)

As output flists are returned to AIA they are treating order as success and the same status has send to upstream systems.

But in BRM as transactions are in prepared state, Services statuses are still in active .

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.