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

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

Wed, 14 Oct 2015 02:59:37 GMT

I am getting a "General Script Error" when executing a STORE command. There are several questions about this on the community already, but they all seem to say that some other process must be locking the file or the directory does not exist.

I have checked with the native "Resource Monitor" app for windows and also the sysinternals Process Explorer and nothing seems to have an open handle on the QVD file I am trying to store. We also disabled anti-virus thinking that might be causing a problem. This is not the first file that is stored, so I know the directory exists and permissions seem to be ok since several other QVD files in that directory save successfully. What else could be causing the problem? The script fails on the same STORE command every time. Any advice is greatly appreciated. Thank you.

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

Wed, 14 Oct 2015 03:15:27 GMT

I would also like to mention that this has been tried on two different servers and two different file paths on each server. The General Script Error problem still exists for the same QVD file in all four cases.

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

vincent_ardiet — Wed, 14 Oct 2015 05:12:06 GMT

Hi Eric,

Nice mystery!

Have you tried to store only one row? We can imagine that there is a faulty row?

Or only one fied? If there is a faulty field.

Regards,

Vincent

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

qlikviewwizard — Wed, 14 Oct 2015 05:15:01 GMT

Hi,

Close all the applications,folders,files and open the qvw again. Run it. It will works. Hope this will help you.

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

Anonymous — Wed, 14 Oct 2015 05:24:13 GMT

Hi Vincent ,

Can You please try partial load or qualify and UNqualify for an instance .

Check row and field .

Thanks ,

Bunny

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

avinashelite — Wed, 14 Oct 2015 05:34:38 GMT

Hi Eric,

Can you please share your script statements, that will give us a better idea

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

nizamsha — Wed, 14 Oct 2015 05:48:04 GMT

Actually i cant get you what you are saying ,are you telling that you want to store a qvd but you cant store as a qvd .is that my understanding is correct.

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

nizamsha — Wed, 14 Oct 2015 05:51:37 GMT

Check this one

General Script error - storing QVD file

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

nizamsha — Wed, 14 Oct 2015 06:00:49 GMT

if its wrong mean Correct mean

1) Just want to confirm do u have a same Qvd in your Folder

2)it its so mean now its not allowing you store new qvd or existing qvd in that location

3)if its so check do u have access to that folder

4)if u don't have a access to that folder that some one might have created from some other login ID but now u want to store in that same location

5)if its so mean give full rights to that folder read and right permission from your ID

6)Then check store command weather its working or not

7) as of me if this is the issue then it will work according to me

Nizam

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

jonathandienst — Wed, 14 Oct 2015 06:10:34 GMT

Are you trying to overwrite an existing QVD? If so, try to delete/rename the QVD manually. Something is preventing QV from getting a write handle to the file.

Is there another task scheduled at the same time attempting to read from the QVD. This might put a transient lock on the file which would have disappeared by the time you looked. Does the error occur when you run the reload outside of the normal schedule (when nothing else is reloading).

Does the reload complete normally if you comment out the store? This is not the solution, I know, but try for diagnostic purposes.

Do you have an Exit Script statement followed by non-executed code. This code is still parsed and if a parse error occurs here, the script could still fail.

I suggest that you post or upload your script here, or at least the part that is failing.

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

qlikviewwizard — Mon, 19 Oct 2015 07:28:13 GMT

Did you able resolve the issue?

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

Mon, 19 Oct 2015 15:32:47 GMT

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.

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

Anonymous — Mon, 19 Oct 2015 18:17:50 GMT

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.

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

effinty2112 — Fri, 30 Oct 2015 14:16:52 GMT

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.

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

Fri, 30 Oct 2015 16:54:45 GMT

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 😕