Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Script fails with cryptic numeric error code when executing a LOAD with a GROUP BY clause.

Hello folks.

We're experiencing a puzzling and frustrating failure when trying to perform a LOAD ... GROUP BY in the script. 

The relevant log section looks like this:

20200320T021340.602-0300 0150 noconcatenate load
20200320T021340.602-0300 0151 KEY_RAMO_PRODUCTO,
20200320T021340.602-0300 0152 FECHA,
20200320T021340.602-0300 0153 TIPO_NEGO,
20200320T021340.602-0300 0154 PRODUCTOR,
20200320T021340.602-0300 0155 RAMO,
20200320T021340.602-0300 0156 PRODUCTO,
20200320T021340.602-0300 0157 MINIMO_DESDE,
20200320T021340.602-0300 0158 CACW_CAPB_CD_PLAN,
20200320T021340.602-0300 0159 TIPO_TRAN,
20200320T021340.602-0300 0160 MOTIVO_DE_ENDOSO,
20200320T021340.602-0300 0161 CAMD_DE_MEDIO_PAGO,
20200320T021340.602-0300 0162 COTC_DE_ORIGEN,
20200320T021340.602-0300 0163 CRCB_CD_PROVINCIA,
20200320T021340.602-0300 0164 PROVINCIA,
20200320T021340.602-0300 0165 PROVINCIA_DE_RIESGO,
20200320T021340.602-0300 0166 CANAL1,
20200320T021340.602-0300 0167 FLAG_CORPORATIVO,
20200320T021340.602-0300 0168 Count(CERTIFICADO) as CERTIFICADO,
20200320T021340.602-0300 0169
20200320T021340.602-0300 0170 Num(AVG(ANTIGUEDAD),'0,00') as ANTIGUEDAD,
20200320T021340.602-0300 0171 Num(Sum(PREMIO),'0,00') as PREMIO,
20200320T021340.602-0300 0172 Num(Sum(SUMA),'0,00') as SUMA
20200320T021340.602-0300 0173 Resident CERTIFICADOS_ENDOSOS_VIG_PARA_AGRUPAR
20200320T021340.602-0300 0174 Group By
20200320T021340.602-0300 0175 KEY_RAMO_PRODUCTO,
20200320T021340.602-0300 0176 FECHA,
20200320T021340.602-0300 0177 TIPO_NEGO,
20200320T021340.602-0300 0178 PRODUCTOR,
20200320T021340.602-0300 0179 RAMO,
20200320T021340.602-0300 0180 PRODUCTO,
20200320T021340.602-0300 0181 MINIMO_DESDE,
20200320T021340.602-0300 0182 CACW_CAPB_CD_PLAN,
20200320T021340.602-0300 0183 TIPO_TRAN,
20200320T021340.602-0300 0184 MOTIVO_DE_ENDOSO,
20200320T021340.602-0300 0185 CAMD_DE_MEDIO_PAGO,
20200320T021340.602-0300 0186 COTC_DE_ORIGEN,
20200320T021340.602-0300 0187 CRCB_CD_PROVINCIA,
20200320T021340.602-0300 0188 PROVINCIA,
20200320T021340.602-0300 0189 PROVINCIA_DE_RIESGO,
20200320T021340.602-0300 0190 CANAL1,
20200320T021340.602-0300 0191 FLAG_CORPORATIVO
20200320T024357.935-0300 -129 =
20200320T024412.449-0300 Execution Failed
20200320T024435.599-0300 Execution finished.

¿What "-129 =" means? We have searched but haven't been able to find a comprehensive list of Qlik internal error codes.

Any help on this issue will be greatly appreciated.

 

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Your group by has quite a lot of fields and applied to a larger dataset it might hit one or the another limitation (in RAM or other resources). Therefore just try your load within the debugger or with a first statement to maybe 1000 records to see if the load itself worked - if yes you increase the number of records just to get a feeling where it becomes instable.

Not the same but similar is this case: Error-129-while-loading-qliksense-script.

Beside this I suggest to check if you really need an aggregation with all those fields and/or if you could apply any kind of incremental logics.

- Marcus

View solution in original post

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Your group by has quite a lot of fields and applied to a larger dataset it might hit one or the another limitation (in RAM or other resources). Therefore just try your load within the debugger or with a first statement to maybe 1000 records to see if the load itself worked - if yes you increase the number of records just to get a feeling where it becomes instable.

Not the same but similar is this case: Error-129-while-loading-qliksense-script.

Beside this I suggest to check if you really need an aggregation with all those fields and/or if you could apply any kind of incremental logics.

- Marcus

View solution in original post