Load from FTP works in version 11, gets unknown load error in version 12

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

We are upgrading from version 11 to 12 and I am testing all the loads in an upgraded (12.20 SR3) copy of our test environment. One of the loads pulls change log files from the SAP server. It is working in our current production and test but is failing using QlikView 12.2 SR3.

The load step is fairly simple:

LogisticsChg:
LOAD *
FROM
[ftp://AcctName:Password@SAPServerName.ent.Entity.com/interfaces/SD/out/bel/Logistics_Chg_JAN-JUNE_2018.csv Password@SAPServerName.ent.Entity.com/interfaces/SD/out/bel/Logistics_Chg_JAN-JUNE_2018.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

but gets this error in version 12

Error: Unknown LOAD statment error

Unknown LOAD statment error

Does anyone know what changes for FTP extracts are required in version 12 of QlikView?

-John

topic Load from FTP works in version 11, gets unknown load error in version 12 in QlikView

Load from FTP works in version 11, gets unknown load error in version 12