Load from hidden shares does not work anymore

[hansrokers]

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 ?

[marcus_sommer]

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

[hansrokers]

It does not work without the $-sign.

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

[marcus_sommer]

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

[hansrokers]

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

[jerrysvensson]

Which SR of 12.20 do you have?

Tried SR5 and it worked.

[Peter_Cammaert]

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

[jerrysvensson]

Haha

My mistake.

12.0 SR5

[Anonymous]

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

[hansrokers]

This bug still has not been fixed.

Anyone found a work around ?