topic Re: Error Reloading Extracts in QlikView

Error Reloading Extracts

tchovanec — Mon, 26 Jan 2026 18:19:17 GMT

We have our extracts run nightly and they run fine. When we have to update an extract and re-run the extract, it fails. It just gives the "general script error" To get around this we have to delete the .qvd and rerun the extract. Any thoughts or suggestions on why this is happening? Thank for any insight.

Re: Error Reloading Extracts

Mon, 17 Feb 2014 14:03:00 GMT

Probably because the file exists and there is no if then else statement to handle this when a filename already exists.

Re: Error Reloading Extracts

tchovanec — Mon, 17 Feb 2014 14:06:23 GMT

It runs every night perfectly fine. The only time they seem to fail is after the have run we make an update to the file that same day and try and rerun the extract.

Re: Error Reloading Extracts

Peter_Cammaert — Mon, 17 Feb 2014 14:10:24 GMT

You doing a manual update to the extracts may set file permissions in such a way that the service account is unable to overwrite the extract(s).

Check Windows permissions.

Peter.

Re: Error Reloading Extracts

Mon, 17 Feb 2014 14:15:46 GMT

Exactly why i said what I did. Check the load script and the create and store portion for the qvd. You mentioned that you have to delete the qvd and then it runs. Something in your script is trying to handle something and doesnt know what to do in this instance. Thats what my gut is telling me

what you could do is in debug mode run the script for each step. take note of where it fails when their is a qvd (so dont delete it just yet ) and if you need assistance post that next portion of the script here for us to have a look at

Re: Error Reloading Extracts

tchovanec — Mon, 17 Feb 2014 14:21:40 GMT

Are you suggesting that when changing the qvw it is setting file permissions on the qvd's? What we are doing is opening the qvw, adding a column to an extract, saving the qvw and then running the qvw through the QMC.

Re: Error Reloading Extracts

tchovanec — Mon, 17 Feb 2014 14:42:39 GMT

Ok. So I did what you suggested. Below is the scrip that I am running. The QVD currently is on the server and if I rerun it fails on the store. Seems like it can't override the file there.

CLARITY_REFERRAL_STATUS:

SQL SELECT

RFL_STATUS_C

,TITLE

,NAME

FROM zc_rfl_status;

STORE CLARITY_REFERRAL_STATUS INTO $(vStore)CLARITY_REFERRAL_STATUS.QVD(qvd);

drop table CLARITY_REFERRAL_STATUS;