Some tasks hangings - Page 2 - Qlik Community

Report Inappropriate Content · ‎2013-08-31

Hello,

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,

Ralph

dmohanty · ‎2013-09-02

Ralph,

The best practice is to restart the Services and the Server on which the many tasks are running, on a daily basis, to ensure a smoother performance.

You can compare the same (RAM Usage, Memory, Threads etc) in Task Manager before and after restarting the server.

Report Inappropriate Content · ‎2013-09-02

Hi,

Generrally in this kind of error occurs when the QVD is getting used by some other process, or due to some reason the process of that QVD is not closed. So, kindly check the open file details and if this is the case then kill the process manually.

Thanks,

D J

Report Inappropriate Content · ‎2013-09-02

I was actually just about to ask that question about restarting the services and server on a daily basis as this is something that I have used in the past but is not implemented in my present organisation.

Thanks,

Ralph

dmohanty · ‎2013-09-02

Yes Ralph,

you could suggest for the same currently as well. Better to keep a track of the same on daily basis. RAM Consumption, Memory, Usage, Thread etc are to be noted down before and after restarting the services and servers.

REgards!!