Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For several reasons we cannot use Standard publisher reload for the majority of our QlikView applications, so I wrote my own C#-program which in short does the following:
- it proceeds two given directories, the first for data refresh from data sources, the second for application reloads
- the qvw-files in the directories are opened and checked, whether the Scheduler is set to e. g. "Hourly"
- the Qvw-files with "Hourly" are reloaded (invoking Qv.exe /nosecurity /r ....)
One of the main reasons we do it this way is that we can execute up to 8 parallel reloads. When one qv.exe has finished, I call the next one.
For the data directoriy this works also, as I'm waiting until my program has no more child processes meaning data reload has completed and application reload can begin now. On the whole, I can reduce reload time from ca 90 minutes (serial batch reload) to less than 15 minutes (parallel reload as described above).
Now, the only annyoing thing is this:
When I'm running this program as a special user from the command line (it's a Win 2008 64 bit server) there are no problems, everything works fine.
When I run it as a task (as the same user), it does only work when the user is logged on and the task is set to "Run only when user is logged on".
Otherwise when run as a task with the user NOT logged on, almost every call of the Qv.exe crashes, generating lots of errors in the event log, all like this one
Faulting application Qv.exe, version 9.0.7320.7, time stamp 0x4afbd00e, faulting module Qv.exe, version 9.0.7320.7, time stamp 0x4afbd00e, exception code 0x40000015, fault offset 0x0000000001184d3e, process id 0x1470, application start time 0x01cab15077f943e2
and no run of my program has ever been finished completely and correctly
Support team has already checked and tested my program this but they tell me they can't help any more, it works fine in their test scenario.
What I still could find out with Process Monitor is that the errors seem to begin with BUFFER OVERFLOWS when reading Reg-Keys.
I know that this is a very special problem here, but perhaps anybody has an idea.
Thx & rgds,
Joachim
P.S.: I can send source to anyone who wants to engage in the problem.
Problem seems to be solved. Must have had something to do with 2008 Server setup, with a new one it just worked.
Problem seems to be solved. Must have had something to do with 2008 Server setup, with a new one it just worked.
Hi Joachim,
I'm in the process of building an automation similar to what you've done. If it's not a big deal, could you please send me the snippet of your codes that do the reload? Please send it to arielic08@yahoo.com.
Thank you very much!
Ariel
Hello Biester, I'm stucked in the same problem, I have to reload some batch files with the option "not logged in", and it's not working. If I try witth "user logged" it works fine.
Do you know what do I need to do to fix that??
Many thanks in advance!!!
Hi Biester, this is my task xml code. As you can see I have shared paths (\\qlikview\users), instead of (C:\users), because I've seen it in some forums.
If I run the same task with a "logged user" it works fine, but with the option "logged or not" there's no way to make it work.
Many thanks in advance!!!