topic Re: reload task not ending in QlikView

reload task not ending

samuel_brierley — Fri, 12 Feb 2016 09:17:23 GMT

Hi all,

i have the below line in a CMD file that i call from windows task manager. the task launches and runs ok, the document is saved but the Task doesnt end.

the same occurs if i run the file manually.

has anyone experienced this or is aware of a solution?

"C:\Program Files\QlikView\qv.exe" /R "C:\Users\samuel.brierley\Desktop\XXX\Download.qvw"

thanks

Re: reload task not ending

awhitfield — Fri, 12 Feb 2016 09:24:42 GMT

Hi Samuel,

have you got 'Generate Logfile' enabled for the qvw?

Andy

Re: reload task not ending

MayilVahanan — Fri, 12 Feb 2016 09:24:50 GMT

Hi Samuel,

The task doesn't end due to some of the following reasons

1. may be any cross join in ur application

2. Circular loop

3. Data size is very huge in any of the tables.

Please check your data model, is any cross join available or not

Re: reload task not ending

Peter_Cammaert — Fri, 12 Feb 2016 10:46:08 GMT

Please post the CMD file in this thread.

If your QVW gets saved, this means that script execution has finished without errors.

Check Task Manager->Processes. Is Qv.exe still present in the list of running processes?

Best,

Peter

Re: reload task not ending

awhitfield — Fri, 12 Feb 2016 10:57:34 GMT

Looking again at this, it doesn't actually sounds like a Qlik issue though, more like an issue with your CMD file.

If you run it manually, do you see the script progress windows open, run the script and then close again?

Andy

Re: reload task not ending

sathishkumar_go — Fri, 12 Feb 2016 11:43:43 GMT

I will suggest, Generate the log file and check the log file has Reload task finished successfully

-Sathish

Re: reload task not ending

samuel_brierley — Fri, 12 Feb 2016 15:11:13 GMT

Hi apologies for the late reply my son fell ill at work

anyway i agree that the issue is unlikely to be qlikview as the script runs fine i simply think im missing some form of end command at the end of my script.

Re: reload task not ending

samuel_brierley — Fri, 12 Feb 2016 15:32:02 GMT

yes it is still running. is there a line within the command file to close the application?

Re: reload task not ending

awhitfield — Fri, 12 Feb 2016 15:33:32 GMT

Hi Sam,

just add Exit on the next line, should do the trick

Andy

Re: reload task not ending

samuel_brierley — Fri, 12 Feb 2016 16:19:46 GMT

Hi Andy

unfortunately not, it would appear that my script isnt going any further than the first line. i think this is because the Qv.exe process is still running. i did try killing that task but that hasnt work because my code wont get past the first line.

Re: reload task not ending

awhitfield — Fri, 12 Feb 2016 16:33:55 GMT

Hi Sam,

was the example .cmd supplied not the full monty then?

Andy