Error During Robj After Upgrade To MPS1 (Doc ID 1408023.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

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

Symptoms

After upgrade to MPS1 the error occurs when reading config in MultiSchema env.

PIN_ERR_STORAGE when trying to read 0.0.0.2 /config/credit_profile 201

The error is:
xop: opcode 7, flags 0
XOP "7" failed: err 43:PIN_ERR_STORAGE, field 0/0:0,
loc 4:PIN_ERRLOC_DM, errclass 0:UNKNOWN, rec_id 0, resvd 0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /search/pin 0 0
0 PIN_FLD_ERR_BUF ERR [0]
<location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_STORAGE:43>
<field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>

dm logs:
E Sat Sep 15 17:44:55 2012 wacot407 dm:23352 dm_subr.c(141):8279 1:wacot407:testnap:2011:-136767264:7:1328005510:1
ORACLE error: do_sql_mr_select: PINStmtExecute: code 936, op 0
=ORA-00936: missing expression

E Sat Sep 15 17:44:55 2012 wacot407 dm:23352 dm_search.c(101):1080 1:wacot407:testnap:2011:-136767264:7:1328005510:1
dm_search_rflds: do_sql_mr_select failed select distinct poid_DB, poid_ID0, poid_TYPE, poid_REV from config_t where AND config_t.poid_DB = :1
E Sat Sep 15 17:44:55 2012 wacot407 dm:23352 dm_ops.c(228):10250 1:wacot407:testnap:2011:-136767264:7:1328005510:1
op_search_and_bulk_act: dm_search_rflds() failed: err=0(PIN_ERR_NONE)
E Sat Sep 15 17:44:55 2012 wacot407 dm:23352 dm_back.c(31):1440 1:wacot407:testnap:2011:-136767264:7:1328005510:1
DMbe #5: process_op: op 7(PCM_OP_SEARCH), err 43(PIN_ERR_STORAGE)

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