topic Re: Reload taking too long in QlikView

Reload taking too long

inescastelhano — Mon, 26 Jan 2026 18:19:17 GMT

Hey folks!

I'm facing a real problem.

My Qlikview document uses incremental load; in the first run it usually takes 3-4 minutes, and after the that (qvds already generated), the document usually takes 30 sec-2 min (maximum) to execute offline (I mean, if I open it and manually execute it). Once I put the document on the server, the run time varies from 1-2 minutes to some hours! There is no reason for this to happen, and it has never happened before. We have already restarted the server, it seemed to get better on first run but now it seems to be the same. I have absolutely no idea of what could cause this. Any help is much appreciated.

Cheers,

Inês

Re: Reload taking too long

Anonymous — Wed, 15 Jun 2016 07:24:40 GMT

Hi Inês,

Could you attach two execution logs? One of normal execution and one of slow execution.

Thanks!

Re: Reload taking too long

inescastelhano — Wed, 15 Jun 2016 07:37:25 GMT

Hi there,

The file "Load Urgências.qvw.2016_06_15_08_31_50" is the normal one, and the file "Load Urgências.qvw" is the slow one. However, for the slow execution, it started at 06:19, although the log file started to be generated at 07:05...

I'm sorry that field names are in portuguese

Thanks in advance.

Inês

Re: Reload taking too long

Anonymous — Wed, 15 Jun 2016 07:47:00 GMT

Hi Inês,

Dont worry about field names.

Why you are loading less tables on Slowly?

There was another task reloading when slowly has started?

Regards!

Re: Reload taking too long

Wed, 15 Jun 2016 07:47:18 GMT

Sounds to me like you might no have any available Engines (QVB). Check (or post) the matching TaskLog.txt

Re: Reload taking too long

inescastelhano — Wed, 15 Jun 2016 07:52:28 GMT

Hey, these are the matching task logs...

Re: Reload taking too long

inescastelhano — Wed, 15 Jun 2016 07:54:05 GMT

Hi! I guess that's because of my incremental load. If the table is already there (like the calendar, which is generated once per day) it will not load the table again. I have several other tasks running at the same time, but they seem to be running fine...

Re: Reload taking too long

Wed, 15 Jun 2016 07:55:44 GMT

Are you sure? Looks more like document logs to me. Referring to TaskLog.txt usually located at C:\ProgramData\QlikTech\DistributionService\[NODEID]\Log\[DATE]\[Time] - [Task name]

Re: Reload taking too long

Anonymous — Wed, 15 Jun 2016 08:02:36 GMT

Ok, you have some tasks at same time, and this task cannot start to load because there are not more Engines to do it. Could you attach the task log? The same log that you view on management console.

Regards!!

Re: Reload taking too long

inescastelhano — Wed, 15 Jun 2016 08:06:58 GMT

Sorry, I didn't get it here it is, one of the slow runs...

Re: Reload taking too long

inescastelhano — Wed, 15 Jun 2016 08:07:44 GMT

I see... Here it is.

Re: Reload taking too long

Wed, 15 Jun 2016 08:21:26 GMT

That's the one. Interesting!!! Not the Engine allocation as I suspected.

6/15/2016 04:43:24.9909095	Information	Task Dependencies are OK
6/15/2016 05:17:46.9770916	Information	Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

For some reason absolutely nothing happens between these two lines. Completely stalled for over 30 minutes. I'll do some investigation and come back to you.

You are running a rather old version of QlikView right? 11.0.11440.0?

Re: Reload taking too long

Anonymous — Wed, 15 Jun 2016 08:21:59 GMT

Hi Inês,

See this two lines:

6/15/2016 04:43:24.9909095 Information Task Dependencies are OK

6/15/2016 05:17:46.9770916 Information Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

The difference of time is because QlikView Publisher, or QlikView Server, is allocating Engines to reload the document. While there aren't resources to do it, it still waiting.

Regards!

Re: Reload taking too long

inescastelhano — Wed, 15 Jun 2016 08:24:40 GMT

Thanks ! I'll wait for your feedback. This is related to low machine resources, right?

The machine where QlikView is running is from our client, so yes, it's a rather old version...

Cheers,

Inês

Re: Reload taking too long

inescastelhano — Wed, 15 Jun 2016 08:25:00 GMT

Machine resources, you mean?

Re: Reload taking too long

Wed, 15 Jun 2016 08:40:40 GMT

Machine resources is for sure something you should check.

I noticed there is massive stall at the very end of the task log.

6/15/2016 05:20:57.6098696	Information	Notifying all triggers of new state:Finished - completed
6/15/2016 06:16:36.2178682	Information	Saving Task Result

Other thing worth checking if there are any issues with Windows Performance Counters on this machine. Cause one thing that is done between the log lines are that we update task related Perfomance Counters.

Re: Reload taking too long

Wed, 15 Jun 2016 08:43:11 GMT

Manuel,

I don't think so. The allocation of the Engine happens between these log lines:

6/15/2016 05:17:46.9770916	Information	Allocating new QlikView Engine. Current usage count=2 of 15 (of type non-reader).
6/15/2016 05:17:46.9770916	Information	Max retries:5
6/15/2016 05:17:46.9770916	Information	Attempt:01
6/15/2016 05:17:47.9754852	Information	Allocated QlikView Engine successfully. Current usage count=3 of 15 (of type non-reader). Ticket number=178.

Re: Reload taking too long

Anonymous — Wed, 15 Jun 2016 09:03:24 GMT

Sorry, I would say processors and rerources, not QlikView Engines.

Re: Reload taking too long

nizamsha — Wed, 15 Jun 2016 10:00:16 GMT

i just want to confirm are you loading the same app in the same machine where server machine is located if not

check the ram size in the server might be one of the reason if ram size is low then it will take some when compare to desktop reload or

check do u have enough space in your drive i hope these are the reason for increasing ur load time on the server

Re: Reload taking too long

inescastelhano — Wed, 15 Jun 2016 10:41:52 GMT

Yes to all your assumptions.