Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Vish35
Contributor III
Contributor III

Which Method is correct for storing a QVD file on Qlik SaaS

Hi Team,

I came across different scenario where store command getting failed with the below reason.

Store Test into 'lib://myspcae-$(env):DataFiles/Test.qvd'(qvd)
20241208T134504.764+0000 Error: Cannot open file: 'lib://myspcae-$(env):DataFiles/Test.qvd' (Connector error: Exception was thrown by handler.)
20241208T134504.765+0000 Execution Failed.

But strange thing is other QVD files above this table have run without any issue. Then one question that came to my mind. what is different between below both store commands.

1. Store Test into 'lib://myspcae-$(env):DataFiles/Test.qvd'(qvd)'(qvd);

2. Store Test into [lib://myspcae-$(env):DataFiles/Test.qvd'(qvd)] (qvd);

we are using 1st one in the script. Will that cause any issue? anyone faced this issue before? please suggest

Thanks

 

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
marksouzacosta

Hi @Vish35 

Don't use single quotes and use square brackets to enclose the full path and file name:

STORE Test INTO [lib://myspcae-$(env):DataFiles/Test.qvd] (qvd);

If you are unsure, you can click on Insert Store statement button:

marksouzacosta_0-1733681732561.png

 

For more details:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...

 

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

View solution in original post

2 Replies
Vish35
Contributor III
Contributor III
Author

Please consider this one for 2nd store command:

2. Store Test into [lib://myspcae-$(env):DataFiles/Test.qvd] (qvd);

marksouzacosta

Hi @Vish35 

Don't use single quotes and use square brackets to enclose the full path and file name:

STORE Test INTO [lib://myspcae-$(env):DataFiles/Test.qvd] (qvd);

If you are unsure, you can click on Insert Store statement button:

marksouzacosta_0-1733681732561.png

 

For more details:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...

 

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com