Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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/ScriptRegularS...
Regards,
Mark Costa
Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com
Please consider this one for 2nd store command:
2. Store Test into [lib://myspcae-$(env):DataFiles/Test.qvd] (qvd);
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/ScriptRegularS...
Regards,
Mark Costa
Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com