One of the qlikview document took very long and still did not open (load into memory). The users had been waiting for almost an hour and then we had to restart the server and it worked fine. I was going through the event logs and found the below entries
It kept on like that with entries like updateshared file or Document Load ODE1 etc as you can see below
It never finished the document load
eventually we had to restart the server and then it worked fine
My Assumption: This is a big document and usually takes 3-4 minutes to load first time. However, could it be possible that when it was not in memory, a lot of users tried to open the document and it tried to load it into memory for all users or something like that. I dont know but could the multiple users accessing the same file slow it down if the document is first time loading into memory?
but here, I am talking about document load (opening the document on qlikview server) and not document data reload . Sorry for the miscommunicating my problem. I have updated the problem description. Thanks for identifying it
The server has a very good resources. It has 384 gb of ram and when the issue happened, even half of the ram was not in use. The CPU was also making the normal peaks and spikes and there did not seem anything abnormal on the server side
The customers are using Ajax. This is indeed a very big document and has around 40 million records. However, this document works fine and it was only today when it happened and we are looking for an explanation to see why has it happened and how to prevent this