13 Replies Latest reply: Jan 29, 2015 10:27 AM by Alejandro Nahuel Cañete RSS

    QV-application not running properly as scheduled task on Windows Server 2008

      Hello all,

       

      We have a bit of an unorthodox setup that I've started having problems with since we upgraded from Windows Server 2003 to Windows Server 2008 some weeks ago.

       

      I have a scheduled task that runs once per week that starts a QV-app while also giving it an input-parameter like this:

       

      "C:\Program Files\QlikView\qv.exe" /vexParam=1 "C:\QlikView\Data\App.qvw"

       

      What the input-parameter does is trigger a macro that uses VBA to open a hidden instance of Excel, build and save a couple of Excel-files and finally shut the QV-app down.

       

      Under Windows Server 2003 this ran perfectly. No problems at all. But on Windows Server 2008 it will only run if I choose the option "Run only when user is logged in" and remain logged in on the server while it runs. What I want is to have it work with the option "Run whether user is logged in or not" but when I try that it behaves strangely. The QV-app starts in the background - I can't actually see it but I'm watching the processes work in Task Manager - and I can see that it starts the hidden instance of Excel and starts doing some work. A couple of minutes later, which is the point where it should be saving the first Excel-file from within the macro, the QV-app just exits and the Task Scheduler claims that "The operation ran successfully". However, no Excel-files have been created so I'm thinking the QV-app actually crashed and never told the Scheduler about it.

       

      I'm really wracking my brain (and Google) trying to find the solution to this and I find it really odd that everything works if I just choose the "Run only when user is logged in"-option since if it was a permissions problem I'm thinking it wouldn't work that way either since either way it runs using my login and credentials.

       

      I have very limited experience with Windows Server 2008 (basically none) so I'm pretty much at an end here and don't know where to go from here. Anybody have a clue as to what is tripping me up here? I'm really starting to get desperate.

       

      Oh, and I'm sure there's a "better" way to do this but that is outside of the scope of this question, we're not looking to change the setup at this point. We just want it to start working again like it did before we switched servers.