topic Re: QlikView Freezes After Script Execution is Complete in QlikView

QlikView Freezes After Script Execution is Complete

TKendrick20 — Thu, 18 Jul 2013 13:40:38 GMT

This problem happens on and off with no real rhyme or reason it seems. I will make a change to the script, save it, then run a limited load (~10,000 records). The script will run as usual, but once the execution is complete I cannot click 'cancel' to close the debug window. Doing so promptly freezes the program and slows down my entire computer. The only way I can close QlikView is to force close it with the task manager. Any ideas on what the problem is or how to fix it?

Re: QlikView Freezes After Script Execution is Complete

Thu, 18 Jul 2013 13:47:27 GMT

Could it be possible that you forgot to remove a certain table? So that you have two tables with more or less similar field names. Ifso QV tries to create composite keys which can take a long time

gr.

Frank

Re: QlikView Freezes After Script Execution is Complete

TKendrick20 — Thu, 18 Jul 2013 14:24:17 GMT

So is it safe to say that hitting "cancel" after the script has run in the debug window prompts the creation of these composite keys? I'm trying to work this out but I've been very careful not to repeat field names because I've been warned of how much QV hates composite keys.

Re: QlikView Freezes After Script Execution is Complete

Thu, 18 Jul 2013 14:25:31 GMT

Maybe add qualify *; in your script. That will break the model but allow you to see witch table/field not supposes to be here.

(You probably have a temporate table not dropped or 2 fields with the same name and not suppose to.... or an modelisation issue in you final model)

Re: QlikView Freezes After Script Execution is Complete

TKendrick20 — Thu, 18 Jul 2013 14:56:32 GMT

That's a helpful little trick, but now the script freezes before it is even done.

Re: QlikView Freezes After Script Execution is Complete

Thu, 18 Jul 2013 15:23:53 GMT

Just run it on debug mode with 100 records,, and then check data model.

cheers,

Re: QlikView Freezes After Script Execution is Complete

Thu, 18 Jul 2013 16:15:07 GMT

Check you fields in the script. You must be referencing the same fields in 2 differnt load statements and if the count of fields is too much, QV will stop responding after the execution of the script since it is buzy creating Synthetic keys for all the common fields. A simple turnaround for this issue is to prequalify the common fields with the table name. Hope this works

Best

Re: QlikView Freezes After Script Execution is Complete

Thu, 18 Jul 2013 16:15:15 GMT

Best

Re: QlikView Freezes After Script Execution is Complete

Thu, 18 Jul 2013 16:15:37 GMT

Best

Re: QlikView Freezes After Script Execution is Complete

TKendrick20 — Thu, 18 Jul 2013 21:02:09 GMT

I did have two fields with (accidentally) the same name: SubGroup1 and SubGroup1 <- supposed to be 2.

However, in trying to use the Qualify *; thing in the script, that was also the cause of more problems that slowed the load down a lot. So be careful if you try to use that to diagnose a similar problem.

Re: QlikView Freezes After Script Execution is Complete

Tue, 26 Nov 2013 10:49:20 GMT

Great, but why can't we get any progress indicator? the script execution just seems to freeze - there must be a way to get some indication about the progress while QV tries to create composite keys !

Re: QlikView Freezes After Script Execution is Complete

Mon, 01 Dec 2014 09:12:48 GMT

Happened with me as well. This post helped.