PCM_OP_SEARCH Failing With Error "Template Too Big"

(Doc ID 1302608.1)

Last updated on MAY 02, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Jan-2012***

Symptoms

PCM_OP_SEARCH is failing with the error 'TEMPLATE too big'. When we execute the same query (used in the template) directly on the DB, it's returning expected results without any errors.

Note: the Search is from a customized application.

Error in cm.pinlog:

D Sun Jan 08 08:48:07 2012 Machine1 cm:21185 fmcustom1.c:1216 1:Machine1:testnap:21147:1:10503:1292094494:1
Item amount Flist
# number of field entries allocated 20, used 8
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(NVL( F1 , 0 )) from /item where F2 = V2 and F3 = V3 and NVL( F4 , 0 ) != V4 and (item_t.poid_type in ('/item/us/vas/m7','/item/us/vas/m31','/item/us/vas/s21','/item/us/vas/s37','/item/us/vas/w9','/item/us/vas/w7','/item/us/vas/m33','/item/us/vas/m8','/item/us/vas/s11','/item/us/vas/s29','/item/us/vas/w28','/item/us/vas/s16','/item/us/vas/m27','/item/us/vas/s40','/item/us/vas/s26','/item/us/vas/s38','/item/us/vas/w31','/item/us/vas/s18','/item/us/vas/w26','/item/us/vas/w35','/item/us/vas/s27','/item/us/vas/w20','/item/us/vas/s35','/item/us/vas/s25','/item/us/vas/m10','/item/us/vas/m28','/item/us/vas/s13','/item/us/vas/w6','/item/us/vas/w8','/item/us/vas/w11','/item/us/vas/s10','/item/us/vas/w16','/item/us/vas/s17','/item/us/vas/w13','/item/us/vas/m17','/item/us/vas/s36','/item/us/vas/m42','/item/us/vas/s43','/item/us/vas/m34','/item/us/vas/s20','/item/us/vas/s30','/item/us/vas/m13','/item/us/vas/s42','/item/us/vas/m41','/item/us/vas/w5','/item/us/vas/m32','/item/us/vas/m19','/item/us/vas/w30','/item/us/vas/m29','/item/us/vas/w3','/item/us/vas/s23','/item/us/vas/s39','/item/us/vas/s41','/item/us/vas/m39','/item/us/vas/s22','/item/us/vas/m38','/item/us/vas/m14','/item/us/vas/s24','/item/us/vas/w22','/item/us/vas/m11','/item/us/vas/w15','/item/us/vas/m25','/item/us/vas/m20','/item/us/vas/m22','/item/us/vas/s19','/item/us/vas/m16','/item/us/vas/w36','/item/us/vas/s15','/item/us/vas/w27','/item/us/vas/w2','/item/us/vas/m26','/item/us/vas/s28','/item/us/vas/w29','/item/us/vas/m35','/item/us/vas/s14','/item/us/vas/m40','/item/us/vas/m21','/item/us/vas/w18','/item/us/vas/w32','/item/us/vas/w12','/item/us/vas/m24','/item/us/vas/m23','/item/us/vas/m30','/item/us/vas/s12','/item/us/vas/w1','/item/us/vas/w24','/item/us/vas/m36','/item/us/vas/w14','/item/us/vas/w4','/item/us/vas/w10','/item/us/vas/w34','/item/us/vas/s44','/item/us/vas/m9','/item/us/vas/s33','/item/us/vas/w19','/item/us/vas/w25','/item/us/vas/m18','/item/us/vas/s8','/item/us/vas/m15','/item/us/vas/s34','/item/us/vas/w33','/item/us/vas/w21','/item/us/vas/w17','/item/us/vas/m12','/item/us/vas/s31','/item/us/vas/s32','/item/us/vas/w23')) "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_DUE DECIMAL [0] 0
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_BILL_OBJ POID [0] 0.0.0.1 /bill 388282971 0
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 388284970 0
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 1
1 PIN_FLD_STATUS_FLAGS INT [0] 1
0 PIN_FLD_RESULTS ARRAY [*] allocated 20, used 1
1 PIN_FLD_AMOUNT DECIMAL [1] NULL pin_decimal_t ptr
D Sun Jan 08 08:48:07 2012 Machine1 cm:21185 fmcustom1.c:1222 1:Machine1:testnap:21147:1:10503:1292094494:1
Output item amount flist
# number of field entries allocated 20, used 2
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=PIN_ERRCLASS_SYSTEM_DETERMINATE:1 errno=PIN_ERR_BAD_ARG:4>
<field num=PIN_FLD_TEMPLATE:5,68 recid=0 reserved=2 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>



Error in dm_oracle.pinlog:

E Sun Dec 12 00:38:16 2010 Machine1 dm:23802 dm_ops.c(181):5986 1:Machine1:testnap:21147:1:10503:1292094494:1
search TEMPLATE too big ("select sum(NVL( F1 , 0 )) from /item where F2 = V2 and F3 = V3 and NVL( F4 , 0 ) != V4 and (item_t.poid_type in ('/item/us/vas/m7','/item/us/vas/m31','/item/us/vas/s21','/item/us/vas/s37','/item/us/vas/w9','/item/us/vas/w7','/item/us/vas/m33','/item/us/vas/m8','/item/us/vas/s11','/item/us/vas/s29','/item/us/vas/w28','/item/us/vas/s16','/item/us/vas/m27','/item/us/vas/s40','/item/us/vas/s26','/item/us/vas/s38','/item/us/vas/w31','/item/us/vas/s18','/item/us/vas/w26','/item/us/vas/w35','/item/us/vas/s27','/item/us/vas/w20','/item/us/vas/s35','/item/us/vas/s25','/item/us/vas/m10','/item/us/vas/m28','/item/us/vas/s13','/item/us/vas/w6','/item/us/vas/w8','/item/us/vas/w11','/item/us/vas/s10','/item/us/vas/w16','/item/us/vas/s17','/item/us/vas/w13','/item/us/vas/m17','/item/us/vas/s36','/item/us/vas/m42','/item/us/vas/s43','/item/us/vas/m34','/item/us/vas/s20','/item/us/vas/s30','/item/us/vas/m13','/item/us/vas/s42','/item/us/vas/m41','/item/us/vas/w5','/item/us/vas/m32','/item/us/vas/m19','/item/us/vas/w30','/item/us/vas/m29','/item/us/vas/w3','/item/us/vas/s23','/item/us/vas/s39','/item/us/vas/s41','/item/us/vas/m39','/item/us/vas/s22','/item/us/vas/m38','/item/us/vas/m14','/item/us/vas/s24','/item/us/vas/w22','/item/us/vas/m11','/item/us/vas/w15','/item/us/vas/m25','/item/us/vas/m20','/item/us/vas/m22','/item/us/vas/s19','/item/us/vas/m16','/item/us/vas/w36','/item/us/vas/s15','/item/us/vas/w27','/item/us/vas/w2','/item/us/vas/m26','/item/us/vas/s28','/item/us/vas/w29','/item/us/vas/m35','/item/us/vas/s14','/item/us/vas/m40','/item/us/vas/m21','/item/us/vas/w18','/item/us/vas/w32','/item/us/vas/w12','/item/us/vas/m24','/item/us/vas/m23','/item/us/vas/m30','/item/us/vas/s12','/item/us/vas/w1','/item/us/vas/w24','/item/us/vas/m36','/item/us/vas/w14','/item/us/vas/w4','/item/us/vas/w10','/item/us/vas/w34','/item/us/vas/s44','/item/us/vas/m9','/item/us/vas/s33','/item/us/vas/w19','/item/us/vas/w25','/item/us/vas/m18','/item/us/vas/s8','/item/us/vas/m15','/item/us/vas/s34','/item/us/vas/w33','/item/us/vas/w21','/item/us/vas/w17','/item/us/vas/m12','/item/us/vas/s31','/item/us/vas/s32','/item/us/vas/w23')) ")
D Sun Dec 12 00:38:16 2010 Machine1 dm:23802 dm_if_oracle.c(116):829 1:Machine1:testnap:21147:1:10503:1292094494:1
audsession-id: 1417675; Time taken by OCITransRollback = 1.303911 milliseconds
D Sun Dec 12 00:38:16 2010 Machine1 dm:23802 dm_if_oracle.c(116):5498 1:Machine1:testnap:21147:1:10503:1292094494:1
End of opcode PCM_OP_SEARCH
D Sun Dec 12 00:38:16 2010 Machine1 dm:23802 dm_if_oracle.c(116):5500 1:Machine1:testnap:21147:1:10503:1292094494:1
audsession-id: 1417675; Time taken by PCM_OP_SEARCH = 1.605988 milliseconds
E Sun Dec 12 00:38:16 2010 Machine1 dm:23802 dm_back.c(27):1420 1:Machine1:testnap:21147:1:10503:1292094494:1
DMbe #9: process_op: op 7, err 4



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