My Oracle Support Banner

PIN_ERR_STORAGE Errors In CUST COMMIT And CUST MODIFY CUSTOMER Opcodes (Doc ID 2107347.1)

Last updated on SEPTEMBER 09, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

On : 7.5.0.13.0 version, DM

Sometimes  PCM_OP_SEARCH opcode is writing single select query on different schemas as below.  Due to this, there are errors in dm_oracle, and most of the orders getting failed in cust commit and cust modify customer opcodes.

NOTE: This issue happens when distribution of account creation on the schemas is set with same priority.

ERROR
-----------------------
dm pinlog snippet with error and the sql query :

E Tue Dec 29 13:52:26 2015 hostname dm:22409 dm_subr.c(165):8990 1:hostname:UnknownProgramName:0:DaemonWorkThread: '88' of WorkManager: 'wm/SOAWorkManager':100067:1451368346:0
ORACLE error: do_sql_mr_select: PINStmtExecute: code 904, op 0
=ORA-00904: "PIN03"."CONFIG_T"."NAME": invalid identifier

E Tue Dec 29 13:52:26 2015 hostname dm:22409 dm_search.c(114):1532 1:hostname:UnknownProgramName:0:DaemonWorkThread: '88' of WorkManager: 'wm/SOAWorkManager':100067:1451368346:0
dm_search_rflds: do_sql_mr_select failed select pin02.config_t.poid_DB, pin02.config_t.poid_ID0, pin02.config_t.poid_TYPE, pin02.config_t.poid_REV, pin03.config_t.name from pin02.config_t ,pin02.config_bus_profile_key_value_t where config_bus_profile_key_value_t.pair_key = :1 and config_bus_profile_key_value_t.pair_value = :2 and pin02.config_t.poid_id0 = pin02.config_bus_profile_key_value_t.obj_id0
E Tue Dec 29 13:52:26 2015 hostname dm:22409 dm_ops.c(258):10780 1:hostname:UnknownProgramName:0:DaemonWorkThread: '88' of WorkManager: 'wm/SOAWorkManager':100067:1451368346:0
op_search_and_bulk_act: dm_search_rflds() failed: err=0(PIN_ERR_NONE)
E Tue Dec 29 13:52:26 2015 hostname dm:22409 dm_if_oracle.c(212):9017 1:hostname:UnknownProgramName:0:DaemonWorkThread: '88' of WorkManager: 'wm/SOAWorkManager':100067:1451368346:0
DMbe dm_oracle_process_op(): update returning flist poid db_no failed. err=43(PIN_ERR_STORAGE)
E Tue Dec 29 13:52:26 2015 hostname dm:22409 dm_back.c(38):1417 1:hostname:UnknownProgramName:0:DaemonWorkThread: '88' of WorkManager: 'wm/SOAWorkManager':100067:1451368346:0
DMbe #229: process_op: op 7(PCM_OP_SEARCH), err 43(PIN_ERR_STORAGE)
D Tue Dec 29 13:52:26 2015 hostname dm:22453 dm_if_oracle.c(212):2989 1:hostname:cm:18016:-153921840:9:1451368346:1
dm_pcm_op_call_stack

See above that in the same SQL query it is trying to fetch fields from different schemas, "...pin02.config_t.poid_REV, pin03.config_t.name ..."

cm.pinlog snippet with error:

D Tue Dec 29 13:52:26 2015 machine1 cm:13919 cm_utils.c(146):1528 1:machine1:UnknownProgramName:0:DaemonWorkThread: '88' of WorkManager: 'wm/SOAWorkManager':100067:1451368346:0
DDD cm_pre_pcm_op: non-local opcode=PCM_OP_SEARCH
W Tue Dec 29 13:52:26 2015 machine1 cm:13919 cm_utils.c(146):1539 1:machine1:UnknownProgramName:0:DaemonWorkThread: '88' of WorkManager: 'wm/SOAWorkManager':100067:1451368346:0
CM FM->DM opcode PCM_OP_SEARCH, opflags=0x40000000
# number of field entries allocated 20, used 6
0 PIN_FLD_POID POID [0] 0.0.0.2 /search -1 0
0 PIN_FLD_FLAGS INT [0] 0
0 PIN_FLD_TEMPLATE STR [0] "select X from /config/business_profile where F1 = V1 and F2 = V2 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1     PIN_FLD_PAIR ARRAY [0] allocated 20, used 1
2         PIN_FLD_PAIR_KEY STR [0] "Invoicing"
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1     PIN_FLD_PAIR ARRAY [0] allocated 20, used 1
2         PIN_FLD_PAIR_VALUE STR [0] "yes"
0 PIN_FLD_RESULTS ARRAY [*] allocated 20, used 2
1     PIN_FLD_POID POID [0] NULL poid pointer
1     PIN_FLD_NAME STR [0] NULL str ptr
D Tue Dec 29 13:52:26 2015 machine1 cm:13919 cm_child.c(128):5209 1:machine1:UnknownProgramName:0:DaemonWorkThread: '88' of WorkManager: 'wm/SOAWorkManager':100067:1451368346:0
opcode db: 2(0.0.0.2), context db: 1(0.0.0.1), trans_state: 2, opcode: 7
D Tue Dec 29 13:52:26 2015 machine1 cm:13919 pcm.c(61):934 1:machine1:UnknownProgramName:0:DaemonWorkThread: '88' of WorkManager: 'wm/SOAWorkManager':100067:1451368346:0
pcm_op: cannot retry PCM_OP_SEARCH, flags 0x40000000 - in a transaction - state=2
W Tue Dec 29 13:52:26 2015 machine1 cm:13919 cm_utils.c(146):1920 1:machine1:UnknownProgramName:0:DaemonWorkThread: '88' of WorkManager: 'wm/SOAWorkManager':100067:1451368346:0
CM DM->FM opcode PCM_OP_SEARCH, opflags=0x40000000
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.2 /search -1 0
0 PIN_FLD_ERR_BUF ERR [0]
<location=PIN_ERRLOC_DM:4 class="PIN_ERRCLASS_SYSTEM_DETERMINATE":1 errno=PIN_ERR_STORAGE:43>
<field num=PIN_FLD_RESULTS:9,51 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>


STEPS
-----------------------
The issue can be reproduced at will with Scenario of bulk account creation.


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.