Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
curiousfellow
Specialist
Specialist

Reload time increases and resets after restart server

every night a reload and republish is started.

At one point a part of the script takes almost two 10 minutes and the next day it takes two hours and is increasing the  next days. After resetting the server time of reload returns to normal. After restarting the server it is not always the same number of days when the reload time starts to increase.

The part of the script that is taking so much time has about 10 applymap functions and some if statements with peek functions in it.

I know that I could try to split this part of the script in some smaller parts but I am wondering why there can be some difference in loading time while there (as far as I know)  are no other reasons that could explain this. Expecially because a restart of the server helps.

Load balancer often informs like this : "LoadMeasurer: The system is currently overloaded. Memory value: 55,1787958879139 CPU value: 81,3251495361328"but I get this message to when time of reload is normal.

Because of this problem we recently upgraded to the latest version of Qlik, but that did not help?

Could there be some memory leak or something like that ?

 

 

 

 

1 Solution

Accepted Solutions
cwolf
Creator III
Creator III

This can happen in a single server environment when the server has allocated all of its memory and then there is no longer enough memory for other processes like reload or publishing jobs.

In this case you have to decrease the settings for Low and High of the Working Set.

You find it in QMC -> System -> Setup -> QlikView Server -> Performance.

View solution in original post

5 Replies
Lucas_Gatling
Support
Support

What version of QlikView are you on? Is this a single node or multi-node environment? What Windows Server OS are you on as well? Is this happening for all reloads or one specific reload? 

If the issue is solved please mark the answer with Accept as Solution.
curiousfellow
Specialist
Specialist
Author

We run Qlikview May 2021 in a single node environment (when that means that no other Qlik servers are involved),problem was there allready before we upgraded to this version.

Windows server = Windows Server 2016 Dataserver. 

It is a specific reload.

reload time is back to normal when the server is restarted

guillemsdg
Partner - Contributor
Partner - Contributor

We are in the same problem. There is any solution?

cwolf
Creator III
Creator III

This can happen in a single server environment when the server has allocated all of its memory and then there is no longer enough memory for other processes like reload or publishing jobs.

In this case you have to decrease the settings for Low and High of the Working Set.

You find it in QMC -> System -> Setup -> QlikView Server -> Performance.

guillemsdg
Partner - Contributor
Partner - Contributor

Thank you very much cwolf, but this is not our case.

The problem occurs even using less than 30% of available memory . Also CPU usage has been checked.

In addition, when we try to reload from Qlikview Desktop, reloading time is quite less as well as being constant.

We would appreciate new suggestions.

In the meantime, we will keep investigating.