BAL_GRP_T Table Row Locking For The Root Account (Doc ID 1307462.1)

Last updated on JUNE 05, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 24-Jul-2013.
*** Checked for relevance on 12-27-2014 ***

Goal

Starting the testnap during UEL run, or num admin run, BAL_GRP_T table was row-locking for the root account. Due to this, testnap is hanging.

Snippet of the cm.pinlog, with testnap hanging in the following case :

Thu Feb 24 21:00:03 2011 lonwin01 cm:4973 cm_utils.c(118):1682 1:lonwin01:testnap:4969:1:0:1298552403:0
CM DM->FM opcode PCM_OP_CM_PRE_LOCK_OBJ, opflags=0x20400 NULL flist ptr
W Thu Feb 24 21:00:03 2011 lonwin01 cm:4973 cm_utils.c(118):1301 1:lonwin01:testnap:4969:1:0:1298552403:0
CM FM->DM opcode PCM_OP_READ_FLDS, opflags=0x20400
# number of field entries allocated 20, used 7
0 PIN_FLD_POID POID [0] 0.0.0.1 /balance_group 1 0
0 PIN_FLD_ACCOUNT_OBJ POID [0] NULL poid pointer
0 PIN_FLD_BILLINFO_OBJ POID [0] NULL poid pointer
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (0) <null>
0 PIN_FLD_BALANCES ARRAY [*] allocated 20, used 5
1 PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1 PIN_FLD_NEXT_BAL DECIMAL [0] 0
1 PIN_FLD_CREDIT_PROFILE INT [0] 0
1 PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [*] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] NULL str ptr
2 PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0
2 PIN_FLD_VALID_FROM TSTAMP [0] (0) <null>
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2 PIN_FLD_CURRENT_BAL DECIMAL [0] 0
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] NULL poid pointer
0 PIN_FLD_REALTIME_CNTR INT [0] 0
0 PIN_FLD_FILTER_INFO SUBSTRUCT [0] allocated 20, used 3
1 PIN_FLD_TEMPLATE STR [0] "where F1 = V1 or F2 >= V2 or F1 IS NULL "
1 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
2 PIN_FLD_BALANCES ARRAY [*] allocated 20, used 1
3 PIN_FLD_SUB_BALANCES ARRAY [*] allocated 20, used 1
4 PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
1 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
2 PIN_FLD_BALANCES ARRAY [*] allocated 20, used 1
3 PIN_FLD_SUB_BALANCES ARRAY [*] allocated 20, used 1
4 PIN_FLD_VALID_TO TSTAMP [0] (1298552403) Thu Feb 24 21:00:03 2011



Solution

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