Question on DM Front End/Back End Connection Management (Doc ID 1578854.1)

Last updated on AUGUST 08, 2024

Applies to:

Goal

On all versions of Oracle Communications Billing and Revenue Management (BRM), how is it possible for PIN_FLD_DM_FE_STATE to have a State of 0 and PIN_FLD_DM_BE_STATE to have a State of 3?

Shouldn't the Back End (BE) connection be released from the transaction automatically when Front End (FE) becomes idle?

Here is the snippet of dm_status that is confusing:

It is suspected that custom BRM code that caused Connection Manager (CM) to crash.  When the CM children die, the FE and BE involved in the transaction end up in this state pair (FE 0, BE 3).

The possible values for PIN_FLD_DM_FE_STATE and PIN_FLD_DM_BE_STATE make sense when looking at them individually.  That does not necessarily say that the combination of 0 and 3 is valid.  In other words, when the BE is busy and locked in a transaction but FE is idle (ie. NOT in state "2") then the net state between FE and BE becomes inconsistent.  BE will wait forever (and it does) and front-end is never going to send an abort or commit to the back-end.

The question is that why is the FE not sending an abort command to the BE when the FE loses its consumer, the CM child? 

Solution

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