topic Re: Script running fine - STORE_command makes WHOOM... Plz help in QlikView

Script running fine - STORE_command makes WHOOM... Plz help

datanibbler — Fri, 13 Dec 2013 11:12:28 GMT

Hi,

the title actually says all about my problem, there is no more to it:

- I have an app running once in the morning to query a lot of data from our personell database.

- The data fetched by one of those queries is to be used in two places:

- It shall be stored just like it is

- It shall be further processed and the process output should be stored.

The latter actually works well. The former does not - I can't see why: The script runs fine - I've tested by putting the EXIT at different points - and the table gets created. There are no more synthetic keys, no links at all actually, all the other tables are already deleted at that point.

<=> At the very last command, which is a STORE command, copied 1:1 from others (just adapted) creates an error, the entire app crashes (that "failure. Retrieve old data?" message) and the qvd is not created.

The command is

>>> STORE Stempeldaten_gen INTO ..\01_QVD\HR_QVD\Stempeldaten_gen.qvd (qvd); <<<

That command is exactly the same as all other STOREs in that app, the file_path is exactly the same and there are other files with an '_' as well which are created without any problems.

I will attach to this post both

- an excel file with sample personell data

- a sample qvw

Re: Script running fine - STORE_command makes WHOOM... Plz help

hic — Fri, 13 Dec 2013 12:56:53 GMT

My guess is that the qvd is locked by another process...

HIC

Re: Script running fine - STORE_command makes WHOOM... Plz help

datanibbler — Fri, 13 Dec 2013 13:01:51 GMT

Hi Henric,

good one - but what could lock it? This particular qvd doesn't exist yet, I am about to generate it at that point ... Could it be because there was another qvd written just a second earlier? Can that be a problem? In that case, I could just push the second STORE command to another tab in the script.

Re: Script running fine - STORE_command makes WHOOM... Plz help

maternmi — Fri, 13 Dec 2013 13:07:53 GMT

Hi ,

try to store without "(qvd)"

Store Stempeldaten_gen.qvd into [\\........\Stempeldaten_gen.qvd.] ;

Best regards,

Michael

Re: Script running fine - STORE_command makes WHOOM... Plz help

Anonymous — Fri, 13 Dec 2013 13:14:39 GMT

Nibbler

I now always put a Sleep(5000) after any Store statement, to thus wait 5 seconds.

This may well be irrelevant to your issue, but since starting doing this I have had no weird issues like you describe.

Best Regards, Bill

Re: Script running fine - STORE_command makes WHOOM... Plz help

mr_janne — Fri, 13 Dec 2013 13:17:04 GMT

First of all you could back up and delete the original QVD files and build them again from fresh.

If that doesn't help you could rename the next generated qvd files in the script.

This way you can test if the QVD file is locked. The QVD file will get locked if the QVW file using it is open.

regards.Janne

Re: Script running fine - STORE_command makes WHOOM... Plz help

datanibbler — Fri, 13 Dec 2013 13:22:09 GMT

Hi Bill,

it is just running, I'll have to wait a few minutes - but that might well be the issue I think, so I will try with the SLEEP() command.

Thanks a lot!

Best regards,

DataNibbler

Re: Script running fine - STORE_command makes WHOOM... Plz help

maternmi — Fri, 13 Dec 2013 13:24:32 GMT

Hi,

I have a small a mistake

<<<Store Stempeldaten_gen into [\\........\Stempeldaten_gen.qvd.]>>>>

By the way if you already have generated a qvd, then delete it, close QV, open QV and reload your script.

Michael

Re: Script running fine - STORE_command makes WHOOM... Plz help

datanibbler — Fri, 13 Dec 2013 13:34:32 GMT

Hi,

unfortunately the problem persists despite all I have tried yet:

- SLEEP 5000 - I have introduced that

- remove the '(qvd)' - I have done that, too.

<=> it doesn't seem to make a difference - the script fails at that point.

Re: Script running fine - STORE_command makes WHOOM... Plz help

johnca — Fri, 13 Dec 2013 13:44:53 GMT

What does the script look like just prior to the Store function? Look for extra or missing commas after each field maybe? That's what I usually find in this scenario, especially when I'm storing a resident load and creating the script manually rather than with the wizard.

--john

Re: Script running fine - STORE_command makes WHOOM... Plz help

datanibbler — Fri, 13 Dec 2013 13:51:58 GMT

It seems that there was something hung up again - I just tried to delete the qvd, I got the message that it was open - so I closed down QlikView and just restarted and ran the script again - and it worked.

Now I try to run it a bit further, to include all the RESIDENT LOADs in that process. Let's see said the blind man...

Re: Script running fine - STORE_command makes WHOOM... Plz help

datanibbler — Fri, 13 Dec 2013 14:00:07 GMT

Yep - apparently, something was stuck. Now it seems to work fine - both qvd files were generated all right.

Thanks for your advice anyway!

Best regards,

DataNibbler

Re: Script running fine - STORE_command makes WHOOM... Plz help

datanibbler — Fri, 13 Dec 2013 14:13:43 GMT

Oops... Apparently, I've forgotten to mark this as a question, so I cannot mark it as solved.

This issue, however, is solved.