I have a significant issue at the moment with a number of Qlikview tasks that are hanging in the middle of a reload and not completing. Since 1:00am this morning we should have had about 100 tasks reloaded (some of the tasks reload every hour, while some are just one offs) and because some of the tasks are hanging it has resulted in about 70 of the tasks failing to complete. Nothing has changed from a Qlikview point of view (I'm not sure whether other issues could affect this) and these jobs have been running for years now with no problems.
- The tasks that seem to be the problem do an incremental load (although not all incremental loads are failing)
- We use QV 10 SR3 and have a cluster environment
- I don't think it is an issue with Publisher as I've manually run through the development application and same thing exists
- Publisher server has been restarted and have had no effect at all.
If anyone has ever encountered a situation like this please let me know!
Thanks in advance,
Not that I'm aware of, and some of the jobs that have failed bear no relation to each other (i.e. they don't go near the same data set). It seems to be an issue on files that are doing incremental loads and concatenating onto 4M+ rows.
Any new software installations on that server by another team? Could you check the windows eventviewer as to what happened in the recent? What do the QlikView server logs say on failure?
Any new windows hot fix hit the server?
I had something similar recently. Publisher usually executes reload in 30 min, and distributes (copies to another machine) in two or three additional minutes. In one case last week, the distribution portion took more than 30 min, although the reload took the expected time.
I don't know what's the reason. Worked fine before and after. Maybe some network issue (?)
Qlikview task hanging is a know issue and I think the case is already raised for the same. Meanwhile can you let me know the "Chunk size" value in the config file.
C:\Program Files\QlikView\Management Service\QVManagementService.exe.config
<add key="QMSChunkSize" value="100"/>
If the value is 100 then please change it to 20.
I've managed to identify the reason why the jobs were hanging:
Any ideas why the store would fail?
Nice to know you have found the issue.
The second bullet point you have mentioned is because of a file lock. Due to this it cannot overwrite that file.
This is something which I have faced in the past.
Solution was to delete and re-create that file OR sometimes had to restart the server for the lock to release.
Everytime a task fails, better check the logs in the Show Tasks Details section (Log tab). There you can find what the error is.
Otherwise post your logs in the communities, those will be investigated.