SKIPPING STORE message in load script

[CvKnippenberg]

Hi,

We have a load script picking up excel files from a sharepoint location, doing some minor adjustments and writing the newly created table to a qvd on the same sharepoint location, but in another map.

The idea is executing the load script monthly and it worked fine for several loads. Now we wanted to add the latest month file, but we get this message:

Skipping STORE ExistingDataVR INTO [sharepoint-location/Qvd/QVDName.qvd] (qvd).

At first we thought there's something wrong with the new excel file we want to load. But using an older file which has been loaded in an earlier load, results in the same message as well.

We tried another attempt, with only an earlier file (which has been loaded succesfully in a previous load) into a completely new non existing qvd file and we still get the message mentioned above.

Any ideas why keep getting the SKIPPING STORE message?

[rubenmarin · Accepted solution]

Hi, first time I see that message, I did a search and I only fount his: https://help.qlik.com/en-US/sense-developer/May2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.DoRe...

Maybe this property has been set to true?

I would try a store to a windows file folder just to test it works, or do a manual save of files on sharepoint using the same user as qlik, to check there is no limitation by permissions.

[CvKnippenberg]

Hi Rubenmarin,

Thank you for your answer.

I'm relatively new to Qlik Cloud, but I doubt if this would solve it. Previous loads were succesfull and now when we add another excel file to be picked up by the load script, we get the Skipping store message. 

Kind regards,

Chris

[CvKnippenberg]

Hi Rubenmarin,

We managed to get it working. We added set skipstore = 0; into our script, removed all input files and all qvd's and executed the process again. Now all files were processed and no skipping store message.

So thank you for pointing me in the correct direction.

Kind regards,

Chris

[cotiso_hanganu]

Facing a similar issue in Qlik SaaS Data, with STORE giving a non-error message: SKIPPING STORE.... (and not storing anything !). Problem sticks both in Personal and Shared Space.

Seems to appear after we've created subfolders to the respective spaces.
(which is a pretty new SaaS functionality, just launched for less then a month now)


After that, even storing in the main Data Folder of the space is skipped.

Test:
load * inline [A,B
a,b
aa,bb];

Store Test into [lib://QQtools demo:DataFiles/Test.qvd] (qvd);

exit script

(Above is the only code used in a fresh new test app)
Even in a new space the same script is skipping store for now !

[cotiso_hanganu]

After more tests... it seems the skipping occurs in DEBUG mode while in FULL RELOAD, the  STORE occurs, even if the destination subfolder didn't existed.

[cotiso_hanganu]

Asked support on this matter and found out that there is a new Debug Setting Option that (de)activates  storing