Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.