Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have just installed the latest version (QV 12.20)
A lot of my documents now fails to reload.
The problem is the $ in the filename (hidden share).
This used to work:
LOAD @1
FROM
[\\myserver\nfs$\edi\abc*.txt]
(txt, codepage is 1252, no labels, delimiter is '|', no quotes);
Now it results in: Unknown LOAD statment error.
Is there a reason that this does not work anymore or a bug ?
Could you try it without the $-sign? I'm not sure if it's not just a measure from windows to hide them within the explorer but that they could be furthermore directly accessed.
- Marcus
It does not work without the $-sign.
It even does not work when I map the unc-path to a drive letter.
Did something else change, too like an upgraded OS or anything to the access-rights of this folder/files or the server-name or ...?
Did you try it with a removing of the $ and the hidden state - just to check that the path itself will working.
- Marcus
The only thing changed was the installation of 12.20.
I have now re-installed version 11.20 and it is working again.
Which SR of 12.20 do you have?
Tried SR5 and it worked.
AFAIK, at the moment there is only an IR available of v12.20. But the IR of every Qlik product often has a bug or two
Haha
My mistake.
12.0 SR5
I have a very similar problem also. I have an upgraded copy of our version 11 box with 12.20 SR3 installed and the FTP extractor does not work on the upgraded version.
LogisticsChg:
LOAD *
FROM
[ftp://SVCAcct:PW@SAPServer.ent.textron.com/interfaces/SD/out/bel/Logistics_Chg_JAN-JUNE_2018.csvPW@SAPServer.ent.textron.com/interfaces/SD/out/bel/Logistics_Chg_JAN-JUNE_2018.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
It gets this error on V12 but works on V11
Error: Unknown LOAD statment error
This bug still has not been fixed.
Anyone found a work around ?