topic Re: "Script Execution Progress" window hangs in QlikView

"Script Execution Progress" window hangs

Thu, 13 Sep 2012 07:58:04 GMT

Hi,

When I reload my dashboard, the "Script Execution Progress" window shows up. It executes the script, but the window does not close once the script is executed. (Please Note: The check box for 'Close when finished' is checked.)

After this the application hangs and I need to forcefully close it. I tried several times but still the same result.

Can any one please advice on this.

Thanks,

Manisha

Re: "Script Execution Progress" window hangs

Miguel_Angel_Baeyens — Thu, 13 Sep 2012 08:21:38 GMT

Hi Manisha,

That sounds like QlikView is trying to either save the file that is too huge or is computing a lot of unwanted synthetic keys what always happens after the last line of script and, although it seems it has finished, actually is has not, because it keep creating relations between tables that share fields with the same exact name.

Did you try debugging with a few rows in the Script Editor instead of just reloading to confirm this?

Hope that helps.

Miguel

Re: "Script Execution Progress" window hangs

Thu, 13 Sep 2012 08:52:53 GMT

Hi Miguel,

Thanks for your reply. Just a few things to inform you:

- I am loading data from a single .qvd file, so there are no associations/ synthetic keys.

- I reloaded for 10 rows but still the same issue.

Regards,

Manisha

Re: "Script Execution Progress" window hangs

Thu, 13 Sep 2012 08:53:06 GMT

Hi Miguel,

Thanks for your reply. Just a few things to inform you:

- I am loading data from a single .qvd file, so there are no associations/ synthetic keys.

- I reloaded for 10 rows but still the same issue.

Regards,

Manisha

Re: "Script Execution Progress" window hangs

Miguel_Angel_Baeyens — Thu, 13 Sep 2012 09:31:06 GMT

Hi,

What about permissions? What if you comment the FOR loop?

Miguel

Re: "Script Execution Progress" window hangs

nam — Thu, 13 Sep 2012 09:36:23 GMT

can you send a screenshot of the code and how much data are we talking about?

Re: "Script Execution Progress" window hangs

nam — Thu, 13 Sep 2012 09:37:57 GMT

can you also check the resource monitor whist it hangs and check the memmory in use.

Re: "Script Execution Progress" window hangs

Sat, 17 Nov 2012 14:04:43 GMT

My script does the following concatenate load from ... * \ QVD\on_line\teste_* QVD;
In the folder there on_line a table with extruded totally different from today. Excludes and resolved. Now the Qlikview could close the script automatically

ats
Wesley

Re: "Script Execution Progress" window hangs

evan_kurowski — Tue, 15 Apr 2014 20:55:39 GMT

I am experiencing this as well. There are now multiple scripts I had that are not closing at the end of script completion.

They are ETL documents that delete every table as they go along, but at the end of the script, the script execution window is 'sticky' and will not close and the entire QV.EXE instance has to be forcibly shut down.

Any ideas on what this latest and greatest monkey wrench is?

Re: "Script Execution Progress" window hangs

Anonymous — Tue, 15 Apr 2014 20:57:48 GMT

The post on this thread from Evan Kurowski was accidentally. In order to restore points to all participants I have copied and reinserted this comment. Thanks for your patience!

Re: "Script Execution Progress" window hangs

Thu, 26 Jun 2014 12:20:45 GMT

I hope you have two or more tables...and you are concatenating those tables ...without using "Concatenate"...just use "Concatenate" function between these tables ...this will make your script work fine...