topic Command line reload in QlikView

Command line reload

Fri, 17 Jul 2009 20:26:16 GMT

Hello,

I need to relaod a qvw file with a batch that will be launch from $U.

Two questions :

1/ Will it work without any user's session open on the server ?

2/ How to get e return code OK or KO from the qv.exe /r command line : I need to pass a return code to $U.

Many thanks,

Command line reload

Fri, 17 Jul 2009 20:53:24 GMT

1° It will work without a user logged on if you specify an authorized user in the run as field in Task scheduler. ( to be sure it is working run it the first time when you are connected on the server as the user).

2) If you want the return code, there is two choices: If you have Qlikviex developper on the machine, you can activate the log and check the last line of the log via a script.

Or you can generate a table in Qlikview containing the errors ( see error handling in tutorial) Then store this table into a text file. Then you send the result of this table to your scheduler.

Hope this is clear enough for you.

Rgds,

Sébastien

Command line reload

Fri, 17 Jul 2009 21:02:50 GMT

Thanks for your quick answer, I'm sorry I cant' understand everything in your first answer :

What do you mean by Task Scheduler, is that in $U or Qv or System ?

Command line reload

Fri, 17 Jul 2009 21:11:04 GMT

I assume he is talking about the "scheduled tasks" in the Control Panel. When you schedule your .bat files to run at certain times there you can select which user the batch job should be run as. Then you don't have to be logged in for it to run.

Command line reload

Fri, 17 Jul 2009 21:18:46 GMT

Ah ok, but it won't be launch by the scheduled tacks, it will be launch by $U which ordonates tasks on differents servers (Unix server, windows, linux a lot of servers)...

Command line reload

Fri, 17 Jul 2009 21:25:31 GMT

I was talking about Windows task schedulerI don't know $U but I guess settings are similar .

Command line reload

Fri, 17 Jul 2009 21:26:04 GMT

Ok. Then I have no clue. Sorry.