The following error occurred: Cannot open file:

Tanalex — Sat, 16 Nov 2024 06:03:05 GMT

This is really bothering me. Below is my code. Loading a spread sheet, which loads fine, but I cannot STORE a QVD into the same folder, or any other data connections for that matter. I have searched and some suggestions are to restart the server. Really? Any thoughts would be greatly appreciated.

tblAllAccounts:
LOAD
AccountID,
AccountName,
AccountNumber,
Block
FROM [lib://QlikWarehouseRoot/Applications\DataExtractScripts\ESSBASE\RailRepair\Accounts.xlsx]
(ooxml, embedded labels, table is Accounts)
WHERE(Len(Trim(AccountNumber)) <> 0);

STORE tblAllAccounts INTO 'lib://QlikWarehouseRoot/Applications\DataExtractScripts\ESSBASE\RailRepair\1.qvd' (qvd);

Re: The following error occurred: Cannot open file:

Tanalex — Thu, 18 Apr 2019 20:42:22 GMT

Figured it out. Our Qlik Sense service account only has READ_ONLY permissions to the Qlik View publishing server, where the folders/connections reside. Just had to request WRITE access to the one folder and all is well. Hope this helps someone.

topic Re: The following error occurred: Cannot open file: in App Development

The following error occurred: Cannot open file:

Re: The following error occurred: Cannot open file: