Scheduled update task hangs up

[#1]

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

[IAMDV]

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,

DV

www.QlikShare.com

[ashfaq_haseeb · Accepted solution]

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

[IAMDV]

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,

DV

www.QlikShare.com

[#5]

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.

[IAMDV]

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,

DV

www.QlikShare.com

[#7]

How can I close the thread?