Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Arjunarao
Honored Contributor II

Re: General Script Error during STORE, but no locks on the QVD file

Did you able resolve the issue?

Not applicable

Re: General Script Error during STORE, but no locks on the QVD file

In most cases in my script, I would STORE and DROP the table as soon as I was done creating it.  In the table that was failing, I was not doing the STORE and DROP right away because I used the table for a LEFT JOIN later.  I was able to fix this error by running the STORE command as soon as I was done creating the table and still DROPing the table after my LEFT JOINs.  I'm not exactly sure why this fixes the problem, but it seems to be working consistently now.  Thank you everyone for your replies.

Highlighted

Re: General Script Error during STORE, but no locks on the QVD file

I have seen this and it seems to me as if there needs to be a pause after the STORE, is use a Sleep(5000) to give 5 secong pause.  Your Left Join could give it the pause it needs.

effinty2112
Honored Contributor

Re: General Script Error during STORE, but no locks on the QVD file

Hi Eric,

I know you are sure that you have no open handles to the file in question but have you tried to delete the qvd file (after backing up of course)?

I had a similar problem. A file called Clerks.qvd was read in and later the modifed table was STORED with the same filename and location and the script failed.

I went through these steps:

LOADED from Clerks.qvd , STORED into Clerks1.qvd. OK

LOADED from Clerks.qvd , STORED into Clerks1.qvd (same as before). OK, file overwritten

LOADED from Clerks1.qvd , STORED into Clerks1.qvd. OK, so script was OK, this was a surprise.

I changed 'Clerks1' back to 'Clerks' in the script and it was when I tried to replace the file 'Clerks.qvd' with 'Clerks1.qvd' that Windows informed me that the file was in use. After closing QV Windows allowed me to delete and replace the file and the script runs OK.

Not applicable

Re: General Script Error during STORE, but no locks on the QVD file

Andrew,

Thank you for your response.  Yes, we tried deleting all QVD files and it still fails at the same place.  I even tried to store the files to a different directory to see if a different path would fix the problem, but again, it still fails at the same place 😕