topic Relaoding from BAT file in QlikView

Relaoding from BAT file

johnan — Tue, 27 Oct 2009 12:34:17 GMT

Hi,

I have a issue, when i reload a application from a Batfile and windows Scheduler, the application will not closing.

The Scheduler is running and QV.exe are active in task manager.

When i open in QV and reload it, its working fine.
Any ideas?

Relaoding from BAT file

tseebach — Tue, 27 Oct 2009 14:26:55 GMT

Hi,

Are you running as the scheduler as the same user as you? Does that user have a license? Are the paths the same?

Try turning on create log file from the Documents Properties menu general tab. So you can see what happen.

Relaoding from BAT file

mongolu — Tue, 27 Oct 2009 14:56:31 GMT

and what is the command line?

Relaoding from BAT file

johnan — Tue, 27 Oct 2009 15:02:03 GMT

Hi,

Its:

"C:\Program Files\QlikView8\Qv.exe" /R "E:\xxx.qvw"

Relaoding from BAT file

johnan — Tue, 27 Oct 2009 15:09:56 GMT

I have turn on logfile now. The Paths are the same.
I have checked "Run whether user is logged on or not" in in scheduler
The user is a admin user, same user i use when i log in.

Relaoding from BAT file

tseebach — Tue, 27 Oct 2009 15:13:52 GMT

Whats does the logfile output?

Relaoding from BAT file

johnan — Tue, 27 Oct 2009 15:19:22 GMT

Just waiting to happend. Its just happen sometimes... Not Always

Relaoding from BAT file

tseebach — Tue, 27 Oct 2009 15:25:02 GMT

Can it be that its fails to reload when you have the document opened with the developer. I've experienced that reloads may fail if I'm working on the document.

Relaoding from BAT file

Tue, 27 Oct 2009 15:29:30 GMT

Hi,

Are you using the batch file content as below.

"C:\Program Files\QlikView\Qv.exe" /r "D:\clients\Sales.qvw"

Regards,

Silvia

Relaoding from BAT file

johnan — Tue, 27 Oct 2009 15:35:25 GMT

Hi, Yes thats correct.

Relaoding from BAT file

mongolu — Tue, 27 Oct 2009 15:57:29 GMT

you could try the VBS way.

put this lines into a file with the extension .VBS (a must) and then double-qlik it.

SET QV = CreateObject("QlikTech.QlikView")
QV.OpenDoc ("E:\xxx.qvw")

QV.ActiveDocument.Reload()
QV.ActiveDocument.Save

QV.QUIT
SET QV = NOTHING

Relaoding from BAT file

johnan — Tue, 27 Oct 2009 16:09:50 GMT

Okay, this work fine. And i can call the VBS file with Win Scheduler?

Relaoding from BAT file

mongolu — Tue, 27 Oct 2009 16:24:34 GMT

yes. you can.

but take that in consideration: using this method (a vbs script), the qv doc will open in the currently qv process and reloads, save, and then quits the entire process.

more explicitily: if you open a qv doc, let's say SALES.qvw. and you work in it. and the sched runs. after that, it quits. and so your SALES.qvw and the work you've done by that moment.

this is something i couldn't bypass.