Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
lgtsotrsdh
New Contributor III

Dashboard Freezes on Reload Just Before Exit Script

Hi everyone,

I have a dashboard that I'm trying to refresh with little luck.  The whole dashboard takes about 2.5 hours to refresh, but it's been freezing up at the end.  The last three commands in the script are as follows:

DROP TABLE ClaimSummaryTemp;

Let vReloadEndTime = now();

EXIT SCRIPT;

Nothing special there, but for some reason the last command that is executed is the Let statement and then the dashboard just hangs up instead of executing the EXIT SCRIPT command.

I've been moving the EXIT SCRIPT statement around in the dashboard, but so far it has always executed and ended the refresh.

Has anyone seen this behavior before?  It's driving me crazy.

Thank you,

Scott

1 Reply
sbaldwin
Contributor III

Re: Dashboard Freezes on Reload Just Before Exit Script

Hi, the last part of a reload is when qlikview generates associations and builds any synthetic keys required, is it possable that there has been a change in the data you are loading which will cause a very large synthetic key to be generated?

If you check the processes is the qv.exe process just consuming more and more memory?

Thanks

Steve

Community Browser