Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Hi,
What about permissions? What if you comment the FOR loop?
Miguel
can you send a screenshot of the code and how much data are we talking about?
can you also check the resource monitor whist it hangs and check the memmory in use.
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
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?
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!