topic Re: Problem regarding reload in QlikView

Problem regarding reload

sarfaraz_sheikh — Mon, 15 Dec 2014 11:15:11 GMT

Dear ALL,

While reloading my application ..automatically in between it gets aborted ...even i am not pressing the abort button aoutomatically process gets shut down ....and data is not reloaded properly ...

Can anyone tell me what is the cause behine the problem ...

It is urgent .......Please let me know !!!

Sarfaraz

Re: Problem regarding reload

rajeshvaswani77 — Mon, 15 Dec 2014 11:17:42 GMT

Hi,

Could be related to the RAM or the CPU shooting up. Keep the task manager running and watch that and then try, see if any of these shoot up?

Are you manking any Join, or there any loops in your QlikView document. You can do limited load of some 1000 records and check the schema.

thanks,

Rajesh Vaswani

Re: Problem regarding reload

Mon, 15 Dec 2014 11:26:37 GMT

Use Debug option and check the progress and see where it is getting stopped at.

Check your errormode as well.

Re: Problem regarding reload

sarfaraz_sheikh — Mon, 15 Dec 2014 11:42:10 GMT

Hi eddie,

what is error mode ....how to check it ..where to check it...

Sarfaraz

Re: Problem regarding reload

engishfaque — Mon, 15 Dec 2014 11:57:52 GMT

Dear Sarfaraz,

You need to enable logfile option and check that where is the issue, here are the step for generating log file.

Document Property > Tab "General" > Checked to checkbox "Generate Logfile" and Checked to checkbox "Timestamp in Logfile Name" > Apply > OK

Reload Script > log file will be generated at the same place where your qvw file exist. Now open the log file and check.

Kind regards,

Ishfaque Ahmed

Re: Problem regarding reload

Mon, 15 Dec 2014 12:42:35 GMT

Error mode handles errors and what errors it needs to be handled and how to ignore them based on the parameters given,

Check this blog post, It has been explained in detail over here.

https://businessintelligenceassistance.wordpress.com/2014/07/08/error-handling-in-qlikview/