topic Re: Which Method is correct for storing a QVD file on Qlik SaaS in App Development

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

Vish35 — Sun, 08 Dec 2024 16:55:20 GMT

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

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

Vish35 — Sun, 08 Dec 2024 16:56:57 GMT

Please consider this one for 2nd store command:

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

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

marksouzacosta — Sun, 08 Dec 2024 18:18:26 GMT

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:

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

Regards,

Mark Costa