Unable to Use "Group By" Clause In the Select Statement Of PCM_OP_SEARCH With Sum() Function
(Doc ID 1267132.1)
Last updated on APRIL 02, 2018
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and laterInformation in this document applies to any platform.
***Checked for relevance on 18-Dec-2012***
***Checked for relevance on 12-April-2015***
Symptoms
Using "group by" clause in PCM_OP_SEARCH results in PIN_ERR_STREAM_EOF.
Steps to Reproduce the Problem
Below is the search opcode flist with group by. When replaced F3 in the select statement with event_tax_jurisdictions_t.type, got the same result. (PIN_ERR_STREAM_EOF).
Search Flist (No Result flist added to search flist below since adding result flist causes a dm error indicating it should not be used with "group by"):
r << XXX 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 1
0 PIN_FLD_TEMPLATE STR [0] "select sum ( F1 ) from /event/billing/cycle/tax where F2 = V2 group by F3 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_TAX_JURISDICTIONS ARRAY [0] allocated 20, used 1
2 PIN_FLD_AMOUNT DECIMAL [0] 0
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/cycle/tax 653597 1
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_TAX_JURISDICTIONS ARRAY [0] allocated 20, used 1
2 PIN_FLD_TYPE ENUM [0] 0
XXX
xop PCM_OP_SEARCH 1 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 1
0 PIN_FLD_TEMPLATE STR [0] "select sum ( F1 ) from /event/billing/cycle/tax where F2 = V2 group by F3 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_TAX_JURISDICTIONS ARRAY [0] allocated 20, used 1
2 PIN_FLD_AMOUNT DECIMAL [0] 0
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /event/billing/cycle/tax 653597 1
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_TAX_JURISDICTIONS ARRAY [0] allocated 20, used 1
2 PIN_FLD_TYPE ENUM [0] 0
XXX
xop PCM_OP_SEARCH 1 1
Search Output:
xop: opcode 7, flags 1
XOP "7" failed: err 50:PIN_ERR_STREAM_EOF, field 0/0:0,
loc 2:PIN_ERRLOC_PCP, errclass 3:PIN_ERRCLASS_SYSTEM_RETRYABLE, rec_id 0, resvd 0 # number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /error_poid -1 0
0 PIN_FLD_ERR_BUF ERR [0]
<location=PIN_ERRLOC_PCP:2 class=PIN_ERRCLASS_SYSTEM_RETRYABLE:3 errno=PIN_ERR_STREAM_EOF:50>
<field num=0:0,0 rec
XOP "7" failed: err 50:PIN_ERR_STREAM_EOF, field 0/0:0,
loc 2:PIN_ERRLOC_PCP, errclass 3:PIN_ERRCLASS_SYSTEM_RETRYABLE, rec_id 0, resvd 0 # number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /error_poid -1 0
0 PIN_FLD_ERR_BUF ERR [0]
<location=PIN_ERRLOC_PCP:2 class=PIN_ERRCLASS_SYSTEM_RETRYABLE:3 errno=PIN_ERR_STREAM_EOF:50>
<field num=0:0,0 rec
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |