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

[consenit]

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.

[marcus_sommer · Accepted solution]

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