topic Script execution is not Finishing in QlikView

Script execution is not Finishing

sunil2288 — Wed, 29 Sep 2010 08:59:04 GMT

Hi All,

I have loaded some tables from an oracle Datebase.

After loading when i am trying to reload it. The execution of script continues indefinitely.

Can any one please tell me when this type of situation arises and how to resolve it.

Regards

Sunil

Script execution is not Finishing

Miguel_Angel_Baeyens — Wed, 29 Sep 2010 09:13:31 GMT

Hello Sunil,

When you say it keeps loading, you mean it doesn't stop pulling records from database? It seems some script error, but not knowing your script is hard to say.

Regards.

Script execution is not Finishing

sunil2288 — Wed, 29 Sep 2010 09:19:50 GMT

HI Miguel

Thanks for your reply.The script is loading all the tables and fetching all the rows but the thing is it is not finishing

I am attaching the screen shot.

i have these many of tables only. but the execution is not finishing after fetching the tables.

Regards

Sunil

Script execution is not Finishing

Wed, 29 Sep 2010 09:27:49 GMT

This often happens when you create too many synthetic keys ($Syn), which come when you load data from different tables and tables have many attribute names that are the same.

Try debuging it and send another screenshot like the one that you posted up - this way you will see whether there are $Syn keys.

Best regards,Miha

Script execution is not Finishing

Miguel_Angel_Baeyens — Wed, 29 Sep 2010 09:29:22 GMT

Hi Sunil,

It's likely to be some process in your script that never ends, kind of waiting for something. It would be possible that QlikView is creating unwanted synthetic keys and take too long to finish? After loading table DimDates, is there any other instruction in the script?

Try debuggin checking "Limited Load" and set 1 or 2 records per table, and see where it stops.

Regards.

Script execution is not Finishing

sunil2288 — Wed, 29 Sep 2010 09:39:06 GMT

HI Miha and Miguel,

I think ther may be a lot of synthetic keys that is forming while loading the script and qlikview unable to show these many complex synthetic keys..

Thanks to both oh you for your reply.

Regards

Sunil

Script execution is not Finishing

Wed, 29 Sep 2010 09:56:49 GMT

Hi Sunil,

If possible please check the button reloading info "close when script is finished".Enable this.

Thanks & Regards

Jai

Script execution is not Finishing

sunil2288 — Wed, 29 Sep 2010 10:01:38 GMT

Hi jai,

I have already checked the option Close when script is finished.

I think the real problem is of resolving a lot of synthetic keys can't be handled smoothly by qlikview.

Thanks for your reply

Sunil

Script execution is not Finishing

Wed, 29 Sep 2010 10:03:33 GMT

Fine,

If possible share your data model with limited load about 100 or 1000 rows

Thanks & Regards

Jai

Script execution is not Finishing

Wed, 29 Sep 2010 10:07:35 GMT

Hi,

Please Apply Qualify *; in the Main tab .

it will help you to Identify whether it is Just Because of Synthetic Key or anything Else.

After this the Fields Will look Like \

TableName.Field Name1

Script execution is not Finishing

sunil2288 — Wed, 29 Sep 2010 10:18:30 GMT

Hi Taj

I will try Qualify... I think i need to write qualify befire the table name which causes the synthetic key.

Isn't it?

Regards

Sunil

Script execution is not Finishing

llauses243 — Wed, 29 Sep 2010 10:26:33 GMT

Hi,

I have this offer:

. To clear if is by keys, to review .log, although the data is short

. Can be because data corrupt, if the table (DIMDATES) is in Oracle, export isolating y test

Good luck, Luis

Script execution is not Finishing

sunil2288 — Wed, 29 Sep 2010 10:55:03 GMT


ijprakash wrote:
Fine,
If possible share your data model with limited load about 100 or 1000 rows
Thanks & Regards
 Jai<div></div>

Hi Jai

I have not built the data model till now as i can't fetch the data.. at first i need to resolve the synthetic key issue then only i can fetch the data and load into QlikView

Thanks

Sunil

Script execution is not Finishing

Miguel_Angel_Baeyens — Wed, 29 Sep 2010 11:01:30 GMT

Hi Sunil,

I'd recommend to use qualification at the beginning of the load script, since you still don't know where the problem is. This will allow you to load all tables, although they will not be linked.

QUALIFY *;

Regards.

Script execution is not Finishing

sunil2288 — Wed, 29 Sep 2010 11:10:29 GMT

HI Miguel

Actually i do have two tables called CPU,CPU_HIST each having same columns but CPU_HIST having two more coloumns.When i tried to reload QV can't able to resolve these many no of Synthetic keys.Now i have resolved the problem.

By Studying Business rules i come to an end that i do no need of fetching the CPU_HIST table.

And hence my query is solved this way..

Thanks

Sunil

Script execution is not Finishing

suniljain — Wed, 29 Sep 2010 13:04:16 GMT

Can you debug with 1 record ?. it will help to clear exact data modelling.

Script execution is not Finishing

Thu, 28 Oct 2010 11:20:45 GMT


ijprakash wrote:
Hi Sunil,
 If possible please check the button reloading info "close when script is finished".Enable this.
Thanks & Regards
Jai<div></div>

Hi!

Do you discover if possible check the button reloading info "close when script is finished".Enable?

Thanks

Script execution is not Finishing

sunil2288 — Thu, 28 Oct 2010 12:52:18 GMT

HI Ij

It doesn't matter if you have Checked the button "Close when Script is Finished" unless and until the tables that need to be fetched is done.

If you are checking this button then "after Finishing of the script and fetching of all the tables that has been requested for" is done then the window will automatically closed

Else it will remain as such for the Programmer to manually close the window..

Regards

Sunil

Re: Script execution is not Finishing

danm84306 — Wed, 06 Feb 2019 16:34:34 GMT

Add QUALIFY*; on the top before your scripts and make sure each table has a name. You are creating a ton of synthetic keys

Re: Script execution is not Finishing

deborahs — Wed, 10 Apr 2019 14:28:13 GMT

Hello kind sir, I'm facing the same issue and I know for sure I may have at least 2 synthetic keys in my data model. Could you shed light on ways to debug this situation?