Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
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?
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
We are in the same problem. There is any solution?
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.
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.