In my scenario, We have Qlikview Small Business server QVS 10 SR1 on Windows server 2003 64 bit. We have hosted 8 documents on it.
The problem started one month ago, when document reload getting failed again and again. Manually they were reloading, if we restart qlikview services and then reload the documents then they were reloading and again next morning scheduled jobs were failed.
So we did 2 things, Wrote a batch file for restarting qlikview services using net stop and net start, and migrated scheduled jobs from qlikview server to windows scheduler.
Again the batch file for restarting qlikview services failed.
Any idea what can be the reasons. I have framed out some of the possible reasons.
1. QVS 10 SR1 should be replaced with QVS 10 SR3.
2. Some windows updates hindering it.
3. In the first batch file for restarting qlikview services using net start / stop commands, using echo for logging errors is blocking the execution.
Updating to the latest version is always recommended, since they keep improving and debugging the software. Anyway, Are you running the 64 bit of QlikView Server or the 32 bit one? What happens if you click on the "play" button in the QEMC to reload? Are you creating log files (Settings menu, Document Properties, General, Generate Logfile) so you can see when the script stops or even if the reload starts?
Since it's not working in the scheduled task in Windows I think of something related to the operating system, such as problems with the drivers you use to pull data from your database, IP addresses change or something.
Did you check the Event Viewer (startup, run, eventvwr.msc) to see if those errors are being recorded in Windows?
Ok, so the restarting of services is what fails. Are you allowing (using PAUSE in your batch file) some time for each service to stop and then to start again or even killing the services should they don't respond to the "net stop"? Depending on how much memory are the services running, it can take longer to stop a service than to execute the next "net start" line.
Apart from that, when services restart right, do the logs say anything regarding the reload? Are they performed fine?