topic Re: Reload is not completing in QlikView

Reload is not completing

priyarane — Mon, 09 Nov 2015 11:11:28 GMT

Hi Community,

My reload is not completing after long time also

Las log as:

11/9/2015 11:03:12 AM: 0256 TRACE 'QVW: CDM_T_CDR_MAY 21 2015 v1007, TAB: Exit Script'

but it is running only even on qmc or manual reload(ctr+r)...

Re: Reload is not completing

Anonymous — Mon, 09 Nov 2015 11:15:29 GMT

You might try for Stop/Start of all services again.

Remove the scheduling and try again to schedule and reload

Re: Reload is not completing

himanshi — Mon, 09 Nov 2015 11:19:27 GMT

Hii,

check the paths given in batch file. is it correct or not?

Re: Reload is not completing

swuehl — Mon, 09 Nov 2015 11:19:59 GMT

There is not much information given in your post.

Could you post your script and document log?

Re: Reload is not completing

miguelbraga — Mon, 09 Nov 2015 11:31:45 GMT

Hey there,

Have you make a task to reload your required QVW in QMC? Can you please elaborate your issue?

Regards,

Re: Reload is not completing

priyarane — Mon, 09 Nov 2015 13:04:05 GMT

After this its nothing moving

Re: Reload is not completing

swuehl — Mon, 09 Nov 2015 13:10:14 GMT

Well, that's not the document log neither the script, but if your CPU load / RAM consumption is high, I would assume that your script is still running, doing the final stage.

If you have tables connected by more than one common field, it might create huge synthetic keys and tables in that stage, possible running out of memory and taking almost forever to complete.

Try limiting the records read in debug mode and see if the script finishes.

Re: Reload is not completing

priyarane — Mon, 09 Nov 2015 13:30:54 GMT

script is finished and no synthetic keyes as well... at last no move and no CPU load / RAM consumption is high

Re: Reload is not completing

avinashelite — Mon, 09 Nov 2015 13:35:28 GMT

Hi Priya,

I think it failing in doing the association ...please check your script once ..if it has any redundant data or if your have two similar tables with one or two fields with different names..in such case it will try to build association for the this tables and end-up in infinite loop

Re: Reload is not completing

swuehl — Mon, 09 Nov 2015 13:43:58 GMT

Even if you are enabling option 'Limited Load of 10' in debug dialog of the script editor, the script won't finish and enable the Close button?