Global Transactions Are In Prepared State
(Doc ID 1956509.1)
Last updated on FEBRUARY 25, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 7.5.0]
Information in this document applies to any platform.
*** Checked for relevance on 06-14-2016 ***
We have enabled Global (XA) Transaction in JCA Adapter.
Recently we have installed PS10. We have noticed that order which are raised from Siebel 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
=ORA-01591: lock held by in-doubt distributed transaction 7.13.6935
Steps to Reproduce the issue
1) Order raised from Siebel -> OSM - > 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 .
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document