Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hansrokers
Contributor III
Contributor III

Load from hidden shares does not work anymore

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 ?

9 Replies
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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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

jerrysvensson
Partner - Specialist II
Partner - Specialist II

Which SR of 12.20 do you have?

Tried SR5 and it worked.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Partner - Specialist II
Partner - Specialist II

Haha

My mistake.

12.0 SR5

Anonymous
Not applicable

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
Contributor III
Contributor III
Author

This bug still has not been fixed.

Anyone found a work around ?