please take note that '/r' option should be present in batch command to trigger reload.
"C:\Program Files\QlikView\qv.exe" /r /vexParam=1 "C:\QlikView\Data\App.qvw"
If you have Qlikview server, definitely you can schedule it on server with input parameter configured as well.
I tried adding the /r option but all that did was cause the entire job to hang, i.e. I would see the processes (qv.exe and EXCEL.EXE) pop up in the task manager, start working and the after a couple of minutes just stop and "stay put" seemingly no longer doing any work.
We have a QlikView server but I can't find the option to configure input parameters in the Management Console.
Did you ever figure this issue out?
I've seen similar issues on our side within the past two weeks - file creation (an export/print to PDF macro) setup suddenly 'hang up' at the point where it would write the file.
I've confirmed the line directly before works fine, but the PDF generation does not. Not exactly the same issue, but similar behavior/results.
After trying a bunch of different things over a couple of weeks I tried a couple of things:
Running the command with, and without the /NoSecurity flag
(in your situation):
"C:\Program Files\QlikView\qv.exe" /vexParam=1 /NoSecurity "C:\QlikView\Data\App.qvw"
.. and also, I tried kicking the job off (while configured to run as '... whether logged in or not') as another user who is setup as an admin on that same system.
After doing this, for some bizarre reason, the job runs fine again as the intended user, and whether they are logged in or not.
No idea why or how, but this resolved my issue.
It turns out most of our problems were caused by the way scheduled tasks run in Windows Server and the specifics of the running macro. The macro attempts to configure a report by manipulating the QlikView-GUI. This is not possible when a task runs "headless" without a logged in user since when no user is logged in no GUI is ever created by the OS (no "desktop-object" exists to hold GUI-components), thus the macro would fail.
I had the same problem with my migration, the problem come from Office and not from Qlikview
To work, Office needs a Desktop folder (why? ... good question!).
And on Windows 2008 there is no Desktop folder if you are not logged in, so you have just to create one and it will work fine !
- Windows 2008 Server x64
Please make this folder.
- Windows 2008 Server x86
Please make this folder.
Next, to run the macro I use this command: qv.exe /vParam=1 /NoSecurity App.qvw
But I don't know if the /NoSecurity flag is really usefull
This is a well-documented issue in Windows Server 2008......
But, despite suggestions in the many threads out there, I still can't get Windows Scheduler to run a bacth file which opens a qvw with an OnOpen trigger to run a macro using "run whether user is logged on or not". If a user has to be logged on for it to work, it's quite useless!
I'm sure other QV developers have encountered this issue - there's plenty of threads on the forum discussing using a batch file to trigger a macro - so, please could someone using Windows Server 2008 advise on how to configure the task, qvw, macro etc. to make it work?
Just to confirm, manually opening the batch file triggers the macro correctly.
Thanks in advance.
I once had a logged on/logged off-type of problem, which you can read about here. Anyway, in my case the solution was to add waitForIdle and/or sleep statements to the macro code, since QV otherwise executed all the macro statements before the graphics had been properly rendered.
This may not be helpful in your case, but then again, it might...
Actually, my problem was due to security which I solved by adding /NoSecurity to the batch file (+ configuring the Windows Scheduler task using advice found here: http://social.technet.microsoft.com/Forums/en-US/winservermanager/thread/d47d116e-10b9-44f0-9a30-7406c86c2fbe ).
However, that's a very useful thread. I'm sure I would have encountered that problem at some point and hadn't considered rendering time. Many thanks.