Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

fredericvillemi
Contributor III

Publisher 12.1 : Overloaded and tasks are queued

Hello,

I'm new in Publisher. I have a big Qlikview Server with more than one hundred documents and I'm migrating into Publisher now.

Publisher is installed on a specific server with 64GB RAM. I have tried to launch several refreshes but I have discovered that when refreshing big documents, other tasks are queued !

And the logs say :

20171218T151822.958+0100 Information LoadMeasurer: The system is not overloaded anymore.

20171218T151922.959+0100 Information LoadMeasurer: The system is currently overloaded. Memory value: 34.8714194483695 CPU value: 96.4844284057617

20171218T152050.960+0100 Information LoadMeasurer: The system is not overloaded anymore.

20171218T154111.463+0100 Information LoadMeasurer: The system is currently overloaded. Memory value: 7.38380757317449 CPU value: 81.2502975463867

20171218T154211.495+0100 Information LoadMeasurer: The system is not overloaded anymore.

20171218T154920.470+0100 Information LoadMeasurer: The system is currently overloaded. Memory value: 10.1731577734552 CPU value: 78.8089141845703

20171218T155020.502+0100 Information LoadMeasurer: The system is not overloaded anymore.

20171218T161045.005+0100 Information LoadMeasurer: The system is currently overloaded. Memory value: 10.9483163630299 CPU value: 79.9807434082031

20171218T161149.037+0100 Information LoadMeasurer: The system is not overloaded anymore.

20171218T164041.850+0100 Information LoadMeasurer: The system is currently overloaded. Memory value: 15.745754563075 CPU value: 100

20171218T164143.805+0100 Information LoadMeasurer: The system is not overloaded anymore.

20171218T164752.094+0100 Information LoadMeasurer: The system is currently overloaded. Memory value: 9.71843875831095 CPU value: 93.677131652832

20171218T164852.783+0100 Information LoadMeasurer: The system is not overloaded anymore.

20171218T165656.946+0100 Information LoadMeasurer: The system is currently overloaded. Memory value: 8.97990183438543 CPU value: 90.7887573242188

What should I do ? I only have two refreshes and it estimates that the system is overloaded.. Should I add RAM or CPU ?  I think it is normal to have CPU at 100% with several simultaneous refreshes. What can I do to have more than 2 refreshes ? to force Publisher to make more refreshes at the same time, even if the system is full

Thanks

1 Solution

Accepted Solutions
fmarvnnt
Contributor

Re: Publisher 12.1 : Overloaded and tasks are queued

Increase the following directives

<add key="CpuOverloadLimit" value="75" />

<add key="MemoryOverloadLimit" value="90" />

up to 95 or 98  (it is a percentage, take care)

within  C:\Program Files\QlikView\Distribution Service\QVDistributionService.exe.cfg

FM

2 Replies
fmarvnnt
Contributor

Re: Publisher 12.1 : Overloaded and tasks are queued

Increase the following directives

<add key="CpuOverloadLimit" value="75" />

<add key="MemoryOverloadLimit" value="90" />

up to 95 or 98  (it is a percentage, take care)

within  C:\Program Files\QlikView\Distribution Service\QVDistributionService.exe.cfg

FM

fredericvillemi
Contributor III

Re: Publisher 12.1 : Overloaded and tasks are queued

Thanks for your answer, I will test that right now

Community Browser