Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have am trying to save a query as a QVD with the following logic:
LIB CONNECT TO 'MyServer';
SQL
SELECT
stuff
FROM MyServer.USERS;
STORE USERS INTO [Lib://MyFolder/USERS.QVD] (qvd);
DROP TABLE USERS;
The error I get is "The following error occurred: Cannot open file: 'lib://MyFolder/USERS.QVD'
The error occurred here: STORE USERS INTO [Lib://MyFolder/USERS.QVD] (qvd); "
In data connections I have MyFolder (and I even added this to the QMC to remove my name from the library connection). And the folder exists as when testing it by putting a empty text file there, for example, I can see the file in QlikSense...
I am at a complete loss as to why this needs to be so complicated to write/access files.... Any help is appreciated!
Hi Bill,
Yes, exactly. You don't have the right to make any changes to that folder. Contact your IT department/admin to give you the rights for this.
Good thing about this, your code is doing fine. When the access is arranged, you can implement this!
Jordy
Climber
Hi Bill,
Try to put a file in this location (test QVD or xlsx) and try open this. This will then generate the file path for you. Use this filepath in your store command.
If this doesn't work, try so see if you have writing problems (access), but you should notice this while working in this folder.
Jordy
Climber
Please ensure you have created lib folder MyFolder if it is not there this error may come. You can create using new connection.
Vikas
Yeah I created the folder and can see files from QS
I made a dummy txt file and could see it while in QS but I can't store any files to it using the above logic.
I created a test excel file and it came up with the same error - so it must be some sort of access restriction ??
Hi Bill,
Yes, exactly. You don't have the right to make any changes to that folder. Contact your IT department/admin to give you the rights for this.
Good thing about this, your code is doing fine. When the access is arranged, you can implement this!
Jordy
Climber
try this
LIB CONNECT TO 'MyServer';
USERS:
Load * ;
SQL
SELECT
stuff
FROM MyServer.USERS;
STORE USERS INTO [Lib://MyFolder/USERS.QVD] (qvd);
DROP TABLE USERS;