topic Re: Some tasks hangings in QlikView

Some tasks hangings

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Some tasks hangings

rajeshvaswani77 — Sat, 31 Aug 2013 13:22:40 GMT

Hi Ralph,

Any very recent changes in the data sources?

thanks,

Rajesh Vaswani

Re: Some tasks hangings

Sat, 31 Aug 2013 13:26:06 GMT

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.

Thanks,

Ralph

Re: Some tasks hangings

rajeshvaswani77 — Sat, 31 Aug 2013 13:28:24 GMT

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?

thanks,

Rajesh Vaswani

Re: Some tasks hangings

Anonymous — Sun, 01 Sep 2013 12:40:47 GMT

Ralph,

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 (?)

Regards,

Michael

Re: Some tasks hangings

Mon, 02 Sep 2013 06:06:08 GMT

Hi Graham,

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

If the value is 100 then please change it to 20.

Thanks,

D J

Re: Some tasks hangings

Mon, 02 Sep 2013 09:36:47 GMT

I've managed to identify the reason why the jobs were hanging:

There was an issue on the server (this is something that I'm not clear of yet but essentially is the root of everything) and a couple of tasks that were running basically corrupted the qvds that they were being stored to (looks like they were only partially saved as the usual file size 2GB but it was just 650MB this time). As these qvds were used elsewhere it caused an adverse effect on other jobs which caused the rebuilds to hang
Another thing that has happened since the 1am server problem on Saturday morning is that a qvd that usually gets overwritten (again around 2GB) is failing on the store. I removed the qvd that it was overwriting and it worked fine but seems to fail if the qvd already exists

Any ideas why the store would fail?

Thanks,

Ralph

Re: Some tasks hangings

rajeshvaswani77 — Mon, 02 Sep 2013 09:42:56 GMT

Hi Ralph,

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.

thanks,

Rajesh Vaswani

Re: Some tasks hangings

dmohanty — Mon, 02 Sep 2013 09:45:57 GMT

Hi Ralph,

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.

Re: Some tasks hangings

Mon, 02 Sep 2013 10:14:12 GMT

Thanks, I think it might require a server restart as I've deleted the original qvd and still fails on the store.

Re: Some tasks hangings

dmohanty — Mon, 02 Sep 2013 10:18:00 GMT

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.

Re: Some tasks hangings

Mon, 02 Sep 2013 10:18:33 GMT

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

Re: Some tasks hangings

Mon, 02 Sep 2013 10:21:09 GMT

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

Re: Some tasks hangings

dmohanty — Mon, 02 Sep 2013 10:25:57 GMT

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!!