topic Re: Load from hidden shares does not work anymore in QlikView

Load from hidden shares does not work anymore

hansrokers — Mon, 18 Dec 2017 09:02:22 GMT

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 ?

Re: Load from hidden shares does not work anymore

marcus_sommer — Mon, 18 Dec 2017 12:52:14 GMT

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

Re: Load from hidden shares does not work anymore

hansrokers — Mon, 18 Dec 2017 13:42:12 GMT

It does not work without the $-sign.

It even does not work when I map the unc-path to a drive letter.

Re: Load from hidden shares does not work anymore

marcus_sommer — Mon, 18 Dec 2017 14:00:22 GMT

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

Re: Load from hidden shares does not work anymore

hansrokers — Mon, 18 Dec 2017 14:06:54 GMT

The only thing changed was the installation of 12.20.
I have now re-installed version 11.20 and it is working again.

Re: Load from hidden shares does not work anymore

jerrysvensson — Mon, 18 Dec 2017 14:12:41 GMT

Which SR of 12.20 do you have?

Tried SR5 and it worked.

Re: Load from hidden shares does not work anymore

Peter_Cammaert — Mon, 18 Dec 2017 14:20:20 GMT

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

Re: Load from hidden shares does not work anymore

jerrysvensson — Mon, 18 Dec 2017 14:22:30 GMT

Haha

My mistake.

12.0 SR5

Re: Load from hidden shares does not work anymore

Anonymous — Tue, 20 Mar 2018 14:39:13 GMT

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.csv PW@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

Re: Load from hidden shares does not work anymore

hansrokers — Thu, 22 Mar 2018 13:37:53 GMT

This bug still has not been fixed.

Anyone found a work around ?