My Oracle Support Banner

Executing PCM_OP_CUST_SET_LOGIN with PCM_TRANS_OPEN_LOCK_DEFAULT Fails (Doc ID 2078170.1)

Last updated on SEPTEMBER 19, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Communications Billing and Revenue Management (BRM) 7.5.0.12.0 version, on a multi-schema environment, running the PCM_OP_CUST_SET_LOGIN opcode inside a transaction created with the PCM_TRANS_READWRITE|PCM_TRANS_OPEN_LOCK_DEFAULT flags fails with the below error:

W 2015-08-05 10:50:32.517 host_name cm_crm:9275.-143410832 cm_utils.c(146):1920 1:host_name:testnap:9273:-142694000:59:1438761032:2
CM DM->FM opcode PCM_OP_CUST_POL_PREP_LOGIN, opflags=0x0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /service/ip/gprs 599498577886 25
0 PIN_FLD_LOGIN STR [0] "m_40745073467_1438612587_D4"
D 2015-08-05 10:50:32.517 host_name cm_crm:9275.-143410832 fm_cust_login.c:714 1:host_name:testnap:9273:-142694000:59:1438761032:2
fm_cust_login_calc_new old/new login info flist
# number of field entries allocated 20, used 12
0 PIN_FLD_POID POID [0] 0.0.0.1 /event/customer/login -1 0
0 PIN_FLD_NAME STR [0] "Customer Mngmt. Event Log"
0 PIN_FLD_USERID POID [0] 0.0.0.1 /service/pcm_client 1 1
0 PIN_FLD_SESSION_OBJ POID [0] 0.0.0.1 /event/session 292945688470093323 0
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 599498579038 0
0 PIN_FLD_PROGRAM_NAME STR [0] "Account migration to different DB_NO"
0 PIN_FLD_START_T TSTAMP [0] (1438761032) Wed Aug 5 10:50:32 2015
0 PIN_FLD_END_T TSTAMP [0] (1438761032) Wed Aug 5 10:50:32 2015
0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/ip/gprs 599498577886 25
0 PIN_FLD_SYS_DESCR STR [0] "Set Login"
0 PIN_FLD_LOGINS ARRAY [0] allocated 20, used 1
1 PIN_FLD_LOGIN STR [0] "m_40745073467_1438612587_D2"
0 PIN_FLD_LOGINS ARRAY [1] allocated 20, used 1
1 PIN_FLD_LOGIN STR [0] "m_40745073467_1438612587_D4"

E 2015-08-05 10:50:32.517 host_name cm_crm:9275.-143410832 fm_cust_login.c:485 1:host_name:testnap:9273:-142694000:59:1438761032:2
op_cust_set_login error
<location=PIN_ERRLOC_FLIST:6 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1 errno=PIN_ERR_NOT_FOUND:3>
<facility=0 msg_id=0 version=0>
D 2015-08-05 10:50:32.517 host_name cm_crm:9275.-143410832 fm_cust_login.c:488 1:obrmapp114.billing.orange.intra:testnap:9273:-142694000:59:1438761032:2
op_cust_set_login return flist
NULL flist ptr

E 2015-08-05 10:50:32.517 host_name cm_crm:9275.-143410832 cm_child.c(125):5048 1:host_name:testnap:9273:-142694000:59:1438761032:2
op PCM_OP_CUST_SET_LOGIN returned an error
<location=PIN_ERRLOC_FLIST:6 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1 errno=PIN_ERR_NOT_FOUND:3>
<facility=0 msg_id=0 version=0>

The issue can be reproduced at will with the following steps in the testnap command line:

r << EOF 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 599498579038 0
EOF
d 2

r << MZZ 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 599498579038 0
0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/ip/gprs 599498577886 25
0 PIN_FLD_PROGRAM_NAME STR [0] "Account migration to different DB_NO"
0 PIN_FLD_LOGINS ARRAY [0] allocated 20, used 1
1 PIN_FLD_LOGIN STR [0] "m_40745073467_1438612587_D4"
MZZ
d 1

xop PCM_OP_TRANS_OPEN 65536 2
xop PCM_OP_CUST_SET_LOGIN 0 1

nap(32549)> r << MZZ 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 599498579038 0
0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/ip/gprs 599498577886 25
0 PIN_FLD_PROGRAM_NAME STR [0] "Account migration to different DB_NO"
0 PIN_FLD_LOGINS ARRAY [0] allocated 20, used 1
1 PIN_FLD_LOGIN STR [0] "m_40745073467_1438612587_D4"
MZZ
nap(32549)> d 1
# number of field entries allocated 20, used 4
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 599498579038 0
0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/ip/gprs 599498577886 25
0 PIN_FLD_PROGRAM_NAME STR [0] "Account migration to different DB_NO"
0 PIN_FLD_LOGINS ARRAY [0] allocated 20, used 1
1 PIN_FLD_LOGIN STR [0] "m_40745073467_1438612587_D4"
nap(32549)>
nap(32549)> xop PCM_OP_TRANS_OPEN 65536 2
xop PCM_OP_CUST_SET_LOGIN 0 1xop: opcode 12, flags 65536
XOP "12" failed: err 37:PIN_ERR_TRANS_ALREADY_OPEN, field 0/0:0,
  loc 2:PIN_ERRLOC_PCP, errclass 4:PIN_ERRCLASS_APPLICATION, rec_id 0, resvd 0

Due to this issue, users cannot cannot change the customer's login inside a locking transaction.

Cause

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
Symptoms
Cause
Solution
References


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