topic Scheduled update task hangs up in QlikView

Scheduled update task hangs up

Sat, 06 Sep 2014 17:47:17 GMT

Hi all,

I have scheduled task (a file .bat) on Windows that hangs up loading data from database (Mssql server 2008 R2).

The command line included in the bat file is :

"C:\Program Files (x86)\QlikView\Qv.exe" /r "E:\EVOLVE\MyFile.qvw"

If I launch the bat from the prompt it works and loads all data correctly.

When it is scheduled it doesn't complete the job and hangs up.

I can't understand what is happening because the log file says the process is running.

Is there a way to have a log more verbose?

How can I debug this strange behavior ?

Thank you veryu much

Claudio

Re: Scheduled update task hangs up

IAMDV — Sat, 06 Sep 2014 18:32:54 GMT

Hi Claudio,

That's strange issue. Have you tried to use .bat file without connecting to SQL Server and just reloading Inline load or excel spreadsheet? Just to make sure if it's the ODBC/OLEDB connection which is contributing the issue. And also recommend you to create your own custom application loggin in QVW. I mean for each logical step within your QVW should write to a text file. You can write a simple subroutine which does the custom application logging and this way you can always track the issue.

Also, try to enable below option "Can Execute External Programs". Ignore "Open Databases in Read and Write mode" - which I have accidentally highlight.

I hope this helps!

Cheers,

www.QlikShare.com

Re: Scheduled update task hangs up

ashfaq_haseeb — Sun, 07 Sep 2014 06:01:04 GMT

Hi,

Apart from what Deepak Vadithala had suggested.

Make sure close when finished is selected. Have a look at attached image.

let me know if that worked.

Regards

ASHFAQ

Re: Re: Scheduled update task hangs up

IAMDV — Sun, 07 Sep 2014 08:09:29 GMT

Nice point Ashfaq. I prefer changing the setting at the user preferences as well. Uncheck the "Keep Progress Open after Reload".

See the below screenshot:

Cheers,

www.QlikShare.com

Re: Scheduled update task hangs up

Mon, 08 Sep 2014 07:35:50 GMT

Thank you Deepak and Ashfaq.

The problem, in fact, was the flag "Close when finished".

I had already unchecked the flag "Keep Progress Open after Reload".

Probably for test purposes the flag "Close when finished" was removed.

Thank you very much for the support.

Claudio B.

Re: Scheduled update task hangs up

IAMDV — Mon, 08 Sep 2014 07:51:24 GMT

That's great that you resolved it. Please can you close this thread by marking correct answer/helpful answer. It helps other users to find the correct answer.

Cheers,

www.QlikShare.com

Re: Scheduled update task hangs up

Thu, 27 Nov 2014 11:22:18 GMT

How can I close the thread?