Billing Can Not Be Completed Due To Error PIN_ERR_TRANS_ALREADY_OPEN

(Doc ID 558932.1)

Last updated on NOVEMBER 06, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.0 [Release 7.3.0]
Oracle Solaris on SPARC (64-bit)
***Checked for relevance on 18-Dec-2009***
***Checked for relevance on 04-Aug-2011***
***Checked for relevance on 14-Jan-2013***



Symptoms

Billing fails with PIN_ERR_TRANS_ALREADY_OPEN for an account which is having too many services.

 cm.pinlog:

      fm_bill_utils_lock_obj returning
E Fri Jan 01 15:49:06 2010 orapp1.test. cm:2777 cm_child.c(103):4793
1:orapp1.test.:testnap:2774:1:110:1201130992:1
      bad cm_change_dm_connection, db=95943625157902337, err=37(PIN_ERR_TRANS_ALREADY_OPEN), errno=11(Resource temporarily unavailable)
E Fri Jan 01 15:49:06 2010 orapp1.test cm:2777 fm_bill_utils_bal_grp_lock.c:1416
1:orapp1.test:testnap:2774:1:110:1201130992:1
      Error in READ_FLDS of :
# number of field entries allocated 20, used 3
0 PIN_FLD_POID POID [0] 340.56376.0.1 /balance_group 9852436 0
0 PIN_FLD_ACCOUNT_OBJ POID [0] NULL poid pointer
0 PIN_FLD_BILLINFO_OBJ POID [0] NULL poid pointer
D Fri Jan 01 15:49:06 2010 orapp1.test cm:2777 fm_bill_utils_bal_grp_lock.c:1211
1:orapp1.test:testnap:2774:1:110:1201130992:1
      fm_utils_trans_prep_lock_obj returning
D Fri Jan 01 15:49:06 2010 orapp1.test cm:2777 fm_bill_utils_config.c:87
1:orapp1.test:testnap:2774:1:110:1201130992:1
##### op_bill_utils_prep_lock_obj(): output flist
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /service/pnap 782417 1
0 PIN_FLD_LOCK_INFO SUBSTRUCT [0] allocated 20, used 2
1   PIN_FLD_TEMPLATE STR [0] "select X from /balance_group where F1 = V1 "
1   PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
2     PIN_FLD_POID POID [0] 0.0.0.1 /balance_group 9852436 0
E Fri Jan 01 15:49:06 2010 orapp1.test cm:2777 cm_utils.c(111):4526 1:orapp1.test:testnap:2774:1:110:1201130992:1
      Error, calling pre lock obj policy
      <location=PIN_ERRLOC_FLIST:6 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1
errno=PIN_ERR_TRANS_ALREADY_OPEN:37>
      <field num=PIN_FLD_POID:7,16 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
      <facility=0 msg_id=0 version=0>
E Fri Jan 01 15:49:06 2010 orapp1.test cm:2777 cm_utils.c(111):702 1:orapp1.test:testnap:2774:1:110:1201130992:1
      cm_pre_lock_obj() failed. opcode=PCM_OP_LOCK_OBJ, err=37(PIN_ERR_TRANS_ALREADY_OPEN)

 

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