topic Re: Script Error in QlikView

Script Error

Tue, 23 Sep 2014 04:32:06 GMT

Hi,

Please help me with the below issue.

while trying to load Qlikview application, the Script stops and does not proceed further. please find the below screen shot.

Regards,

Hitha Dhani

Re: Script Error

jyothish8807 — Tue, 23 Sep 2014 05:13:59 GMT

Hi hitda,

I guess its an issue with your data sourse, might be its huge and its taking time to load data.

Regards

Re: Script Error

jagan — Tue, 23 Sep 2014 05:38:39 GMT

Hi,

May be it is taking time to load the data, sometimes this happens when you load large set of data, just leave it for some time an hour or so.

If you want to check load some limited data and check whether there is any issue.

Regards,

Jagan.

Re: Script Error

Tue, 23 Sep 2014 05:49:08 GMT

thank you KC and Jagan.

guessing data size might be the issue, i have restricted the data and loaded it.

while i run the script in the debug mode , it says script finished and closes the entire application.

Re: Script Error

alkesh_sharma — Tue, 23 Sep 2014 06:29:27 GMT

Either there is problem with the data set you are trying to load or a lot of synthetic keys/Circular references have been created in this data set.

Re: Script Error

Tue, 23 Sep 2014 07:00:41 GMT

Hi Alkesh,

thank you.

i have created multiple layers before loading the data into the dashboard.

if it was the case of synthetic key these layers would have not loaded as well.

but the layers are loading fine. only the main dashboard script is failing.

can this be due to the number of tables or charts or tabs used at the front end ?

Re: Script Error

jagan — Tue, 23 Sep 2014 07:12:37 GMT

Hi,

Try filtering using the where condition instead using Debug mode.

Regards,

Jagan.

Re: Script Error

alkesh_sharma — Tue, 23 Sep 2014 07:21:32 GMT

Why are you connecting to the same database twice.

Re: Script Error

JonnyPoole — Tue, 30 Sep 2014 16:57:23 GMT

Good question . Also consider adding the following in front of each table to load only 10 rows of data in each load. If it still hangs/fails a look at the overall load script could yield more insight.

Top 10;

Re: Script Error

jeremy_fourman — Tue, 30 Sep 2014 17:18:04 GMT

I second that you most likely are creating circular references and synthetic keys.

Ensure that there is only one field in each table that needs to be associated. Here is a link to a good video explaining how to create a data model.

Creating a Data Model

Re: Script Error

Wed, 08 Oct 2014 08:29:23 GMT

not connected to the same database twice.

this was due to loop n reduce not been implemented properly. now the script is working fine.

thank u.

Re: Script Error

Wed, 08 Oct 2014 08:30:50 GMT

faced this issue even after removing the synthetic keys by renaming the fields.

now the script is working fine. it was due to another issue.

thank you