The following error occurred: Cannot open file:

[Tanalex]

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);

[NadiaB · Accepted solution]

Hi @Tanalex 

Please refer to the following articles that might help to resolve the issue:

Concurrent Read and Write from/to a QVD file may result in one of the tasks failing

How to resolve problems related to locked QVD files

Kind regards.