Group By Is Not Working In PCM_OP_SEARCH (Doc ID 2029745.1)

Last updated on JULY 30, 2015

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

Group by when used in PCM_OP_SEARCH is not working as expected. It is working for some tables only.

Noticed below error in the dm_oracle pinlog.

dm_search_calc_groupby: bad bind_info 4, field PIN_FLD_TELCO_INFO, field_type 10, rec_id 0

nap(24479)> r << 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /search/pin -1 0
0 PIN_FLD_FLAGS INT [0] 1
0 PIN_FLD_TEMPLATE STR [0] " select sum (F1), F3 from /event/delayed/session/telco/gsm where F2 != V2 group by F3 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 1, used 1
2 PIN_FLD_QUANTITY DECIMAL [0] NULL
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 1, used 1
2 PIN_FLD_TAX_CODE STR [0] "AAA"
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_TELCO_INFO SUBSTRUCT [0] allocated 20, used 14
2 PIN_FLD_CALLING_FROM STR [0] "2230000053"
1
buffer: 1
nap(24479)> xop 7 0 1
xop: opcode 7, flags 0
XOP "7" failed: err 4:PIN_ERR_BAD_ARG, field 0/8002:PIN_FLD_TELCO_INFO,
  loc 4:PIN_ERRLOC_DM, errclass 4:PIN_ERRCLASS_APPLICATION, rec_id 0, resvd 8
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /search/pin -1 0
0 PIN_FLD_ERR_BUF ERR [0]
nap(24479)>

 

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