Error Field not found where reloading from server

atomino — Wed, 02 Sep 2020 11:43:36 GMT

Hello to everybody,

I'm having a very strange problem, when I try to launch reload for a document from the server it fails with this error

02/09/2020 13:24:10: Error: Field not found - <,>
02/09/2020 13:24:10: General Script Error

Reloading the same document from my pc gives no problem a all.

The odbc is the same on server and on pc.

This is the complete log for the script:

02/09/2020 13:24:09: 0316 LOAD *,
02/09/2020 13:24:09: 0317 if(Match(ver_data_contabilita, '0'), 'N', if(ver_data_contabilita < ver_data_modifica, 'S', 'N')) as "Modificato Dopo Contabilizzazione",
02/09/2020 13:24:09: 0318
02/09/2020 13:24:09: 0319 if(Match(pag_codice, '8'), ver_transazione, '' ) as PP_CodTrans,
02/09/2020 13:24:09: 0320 if(Match(pag_codice, 'K'), 'GestPay',if(Match(pag_codice, '9'), 'Gestpay', if(Match(pag_codice, '5'), 'Gestpay', if(Match(pag_codice, '16'),'Gestpay','')) ) ) as PaymentGateway,
02/09/2020 13:24:09: 0321 if(Match(pag_codice, '9'),'9091600',if(Match(pag_codice, '5'),'9099827',if(Match(pag_codice, 'K'),if(Match(ver_automatico, '1'),'9099827',if(Match(Left(ver_transazione,4), 'D-20'),'9091600','9099827')),if(Match(pag_codice, '16'),'9099827','')))) as POS,
02/09/2020 13:24:09: 0322 if(Match(ver_automatico, '1'),ver_identificativo_web,if(Match(pag_codice, '5'),ver_identificativo_web,if(Match(pag_codice, '16'),ver_identificativo_web,ver_transazione)))as CodTrans,
02/09/2020 13:24:09: 0323
02/09/2020 13:24:09: 0324
02/09/2020 13:24:09: 0325
02/09/2020 13:24:09: 0326

02/09/2020 13:24:09: 0328 LOAD
02/09/2020 13:24:09: 0329 "id_versamento",
02/09/2020 13:24:09: 0330 "id_cliente",
02/09/2020 13:24:09: 0331 "id_campagna" AS "id_campagna_donazione",
02/09/2020 13:24:09: 0332 "id_tipo" AS "ID_TIPO_VERSAMENTO",
02/09/2020 13:24:09: 0333 "id_sottotipo",
02/09/2020 13:24:09: 0334 "id_centro",
02/09/2020 13:24:09: 0335 "id_ringraziamento",
02/09/2020 13:24:09: 0336 "id_tipo_bollettino",
02/09/2020 13:24:09: 0337 "ver_pagamento" AS pag_codice,
02/09/2020 13:24:09: 0338 Year(date(date#(ver_data,'YYYYMMDD'),'DD/MM/YYYY')) AS "Anno Versamento",
02/09/2020 13:24:09: 0339 MonthName(date(date#(ver_data,'YYYYMMDD'),'DD/MM/YYYY')) AS "Periodo Versamento",
02/09/2020 13:24:09: 0340 date(date#(ver_data,'YYYYMMDD'),'DD/MM/YYYY') AS "Data Versamento",
02/09/2020 13:24:09: 0341 "ver_data",
02/09/2020 13:24:09: 0342 "ver_anno",
02/09/2020 13:24:09: 0343 "ver_valore",
02/09/2020 13:24:09: 0344 "ver_cc",
02/09/2020 13:24:09: 0345 "ver_cc_mese",
02/09/2020 13:24:09: 0346 "ver_cc_anno",
02/09/2020 13:24:09: 0347 "ver_documento",
02/09/2020 13:24:09: 0348 "ver_utente",
02/09/2020 13:24:09: 0349 "ver_utente_creazione",
02/09/2020 13:24:09: 0350 date(date#(ver_data_creazione,'YYYYMMDD'),'DD/MM/YYYY') AS "Data Creazione",
02/09/2020 13:24:09: 0351 "ver_data_creazione",
02/09/2020 13:24:09: 0352 "ver_data_modifica",
02/09/2020 13:24:09: 0353 "ver_automatico",
02/09/2020 13:24:09: 0354 "ver_note",
02/09/2020 13:24:09: 0355 "ver_vecchio_documento",
02/09/2020 13:24:09: 0356 "id_canale",
02/09/2020 13:24:09: 0357 "id_progetto",
02/09/2020 13:24:09: 0358 "id_adozione",
02/09/2020 13:24:09: 0359 Year(date(date#(ver_data_valuta,'YYYYMMDD'),'DD/MM/YYYY')) AS "Anno Valuta",
02/09/2020 13:24:09: 0360 MonthName(date(date#(ver_data_valuta,'YYYYMMDD'),'DD/MM/YYYY')) AS "Periodo Valuta",
02/09/2020 13:24:09: 0361 date(date#(ver_data_valuta,'YYYYMMDD'),'DD/MM/YYYY') AS "Data Valuta",
02/09/2020 13:24:09: 0362 "ver_data_valuta",
02/09/2020 13:24:09: 0363 "ver_lotto",
02/09/2020 13:24:09: 0364 "ver_linea_budget1",
02/09/2020 13:24:09: 0365 "ver_linea_budget2",
02/09/2020 13:24:09: 0366 "ver_linea_budget3",
02/09/2020 13:24:09: 0367 "id_evento",
02/09/2020 13:24:09: 0368 "id_conto_corrente",
02/09/2020 13:24:09: 0369
02/09/2020 13:24:09: 0370 "ver_transazione",
02/09/2020 13:24:09: 0371 "ver_quinto_campo",
02/09/2020 13:24:09: 0372 date(date#(ver_data_ringraziamento,'YYYYMMDD'),'DD/MM/YYYY') AS "Data Ringraziamento",
02/09/2020 13:24:09: 0373 "ver_data_ringraziamento",
02/09/2020 13:24:09: 0374 "ver_identificativo_web",
02/09/2020 13:24:09: 0375 "ver_cuas",
02/09/2020 13:24:09: 0376 "id_dialogatore",
02/09/2020 13:24:09: 0377 "ver_importo_split",
02/09/2020 13:24:09: 0378 date(date#(ver_data_gestionale,'YYYYMMDD'),'DD/MM/YYYY') AS "Data Gestionale",
02/09/2020 13:24:09: 0379 "ver_data_gestionale",
02/09/2020 13:24:09: 0380 "ver_flg_qlikview",
02/09/2020 13:24:09: 0381 "ver_pagatore",
02/09/2020 13:24:09: 0382 "id_referente",
02/09/2020 13:24:09: 0383 "ver_levy",
02/09/2020 13:24:09: 0384 "id_cliente_partner",
02/09/2020 13:24:09: 0385 "id_cliente_referente",
02/09/2020 13:24:09: 0386 "ver_no_attestato",
02/09/2020 13:24:09: 0387 if(Match(ver_data_contabilita, '0'), 'N', 'S') as "Donazione contabilizzata",
02/09/2020 13:24:09: 0388 date(date#(ver_data_contabilita,'YYYYMMDD'),'DD/MM/YYYY') AS "Data Contabilizzazione",
02/09/2020 13:24:09: 0389 "ver_data_contabilita"
02/09/2020 13:24:09: 0390 SQL SELECT *
02/09/2020 13:24:09: 0391 FROM dbo.versamenti
02/09/2020 13:24:09: 0392 where ver_data >='20190101'

02/09/2020 13:24:10: Error: Field not found - <,>
02/09/2020 13:24:10: General Script Error
02/09/2020 13:24:10: Execution Failed
02/09/2020 13:24:10: Execution finished.

Re: Error Field not found where reloading from server

Miguel_Angel_Baeyens — Tue, 08 Sep 2020 13:38:07 GMT

The error means that the expression which translated into a field name couldn't have any value. If you have multiline If() statements in the script, make sure all parentheses are properly closed, or try to copy and paste those lines, comment the old ones, put everything on one single long line and try again.

Double check you are not using double quotes (") on the right side of the AS, only on the left side, e.g.: "Value" AS "FieldName", but instead single quotes ('); e.g.: '20200908' AS "Date".

topic Re: Error Field not found where reloading from server in QlikView

Error Field not found where reloading from server

Re: Error Field not found where reloading from server