PCM_OP_SEARCH On /Item Failing When Used "Like"Clause In The Search Template After Item Partiitoning (Doc ID 1179833.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.0 and later   [Release: 7.3.1 and later ]
Information in this document applies to any platform.
Checked for relevance on 28-Feb-2012.

Symptoms

PCM_OP_SEARCH is failing when used with a "like" clause in the search template after object partitioning:

1)  Partition item table
2)  Use the below flist and execute PCM_OP_SEARCH from testnap:
    0 PIN_FLD_POID           POID [0] 0.0.0.1 /search -1 0
    0 PIN_FLD_FLAGS           INT [0] 256
    0 PIN_FLD_TEMPLATE        STR [0] "select X from /item where F1.type like V1"
    0 PIN_FLD_ARGS          ARRAY [1] allocated 20, used 1
    1     PIN_FLD_POID           POID [0] 0.0.0.1 /item/us/g% -1 0
    0 PIN_FLD_RESULTS       ARRAY [0]     NULL array ptr

We  are getting the following error:
0 PIN_FLD_POID           POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_ERR_BUF         ERR [0]
       <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_BAD_ARG:4>
       <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
       <facility=0 msg_id=0 version=0>

The DM_ORACLE pinlog reports an error condition too:
D Thu Oct 20 12:17:47 2016  BRM-D4  dm:1697  dm_if_oracle.c(116):783 1:BRM-D4:testnap:6879:1:7:1280153013:2
audsession-id: 1383470; Time taken by OCITransStart = 1.649141 milliseconds
D Thu Oct 20 12:17:47 2016  BRM-D4  dm:1697  dm_if_oracle.c(116):4376 1:BRM-D4:testnap:6879:1:7:1280153013:2
Start of opcode PCM_OP_SEARCH
E Thu Oct 20 12:17:47 2016  BRM-D4  dm:1697  dm_ops.c(181):14084 1:BRM-D4:testnap:6879:1:7:1280153013:2
add_partition_constraints_to_search: map_poid... on object "/item/us/g%" failed, 4
W Thu Oct 20 12:17:47 2016  BRM-D4  dm:1697  dm_search.c(91):1028 1:BRM-D4:testnap:6879:1:7:1280153013:2

SQL_STMT dm_search_robj: cmd="select  distinct  poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, payment_available, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, adjusted, archive_status, ar_billinfo_obj_DB, ar_billinfo_obj_ID0, ar_billinfo_obj_TYPE, ar_billinfo_obj_REV, ar_bill_obj_DB, ar_bill_obj_ID0, ar_bill_obj_TYPE, ar_bill_obj_REV, bal_grp_obj_DB, bal_grp_obj_ID0, bal_grp_obj_TYPE, bal_grp_obj_REV, billinfo_obj_DB, billinfo_obj_ID0, billinfo_obj_TYPE, billinfo_obj_REV, bill_obj_DB, bill_obj_ID0, bill_obj_TYPE, bill_obj_REV, closed_t, currency, currency_operator, currency_rate, currency_secondary, delta_due, disputed, due, due_t, effective_t, event_poid_list, gl_segment, item_no, item_total, name, opened_t, recvd, service_obj_DB, service_obj_ID0, service_obj_TYPE, service_obj_REV, status, status_flags, transfered, writeoff from item_t   where item_t.poid_TYPE like :1 "
W Thu Oct 20 12:17:47 2016  BRM-D4  dm:1697  dm_subr.c(120):7393 1:BRM-D4:testnap:6879:1:7:1280153013:2

SQL_STMT do_sql_mr_select: cmd="select  distinct  poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, payment_available, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, adjusted, archive_status, ar_billinfo_obj_DB, ar_billinfo_obj_ID0, ar_billinfo_obj_TYPE, ar_billinfo_obj_REV, ar_bill_obj_DB, ar_bill_obj_ID0, ar_bill_obj_TYPE, ar_bill_obj_REV, bal_grp_obj_DB, bal_grp_obj_ID0, bal_grp_obj_TYPE, bal_grp_obj_REV, billinfo_obj_DB, billinfo_obj_ID0, billinfo_obj_TYPE, billinfo_obj_REV, bill_obj_DB, bill_obj_ID0, bill_obj_TYPE, bill_obj_REV, closed_t, currency, currency_operator, currency_rate, currency_secondary, delta_due, disputed, due, due_t, effective_t, event_poid_list, gl_segment, item_no, item_total, name, opened_t, recvd, service_obj_DB, service_obj_ID0, service_obj_TYPE, service_obj_REV, status, status_flags, transfered, writeoff from item_t   where item_t.poid_TYPE like :1 "
D Thu Oct 20 12:17:47 2016  BRM-D4  dm:1697  ../dm_oracle_stmt_cache.c:324 1:BRM-D4:testnap:6879:1:7:1280153013:2
PINStmtPrepare: SQL Statement = select  distinct  poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, payment_available, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, adjusted, archive_status, ar_billinfo_obj_DB, ar_billinfo_obj_ID0, ar_billinfo_obj_TYPE, ar_billinfo_obj_REV, ar_bill_obj_DB, ar_bill_obj_ID0, ar_bill_obj_TYPE, ar_bill_obj_REV, bal_grp_obj_DB, bal_grp_obj_ID0, bal_grp_obj_TYPE, bal_grp_obj_REV, billinfo_obj_DB, billinfo_obj_ID0, billinfo_obj_TYPE, billinfo_obj_REV, bill_obj_DB, bill_obj_ID0, bill_obj_TYPE, bill_obj_REV, closed_t, currency, currency_operator, currency_rate, currency_secondary, delta_due, disputed, due, due_t, effective_t, event_poid_list, gl_segment, item_no, item_total, name, opened_t, recvd, service_obj_DB, service_obj_ID0, service_obj_TYPE, service_obj_REV, status, status_flags, transfered, writeoff from item_t   where item_t.poid_TYPE like :1

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