Script execution is not Finishing

[sunil2288]

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

[sunil2288]

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

[llauses243]

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

[sunil2288]

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

[Miguel_Angel_Baeyens]

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.

[sunil2288]

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

[suniljain]

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

[#8]

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

[sunil2288]

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

[danm84306]

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

[deborahs]

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?