Today qlikview server and publisher stop responding, no msg or alert was generated by server. In winder service viewer all services were running but i found errors in Event Viewer.
System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
at QlikTech.NetClient.QvClient.GetMessageDataFromSocket(Byte buffer, Double timeout)
at QlikTech.NetClient.QvClient.GetMessageSizeFromSocket(Double timeout)
at QlikTech.NetClient.QvClient.Execute(Byte request)
at QlikTech.NetClient.QvClient.Execute(String request)
This issue was caused by our CPUs maxing to 100% for a certain length of time when the QMS was trying to initiate a task execution. We overcame this issue, by ensuring that all our loads were optimized so that the CPUs would never be maxed out at any time when tasks were reloaded over night.
A few things that you could do to reduce CPU usage:
Ensure that all your loads are optimized when loading in QVDs, It's good practice not to try and do everything at once. Instead break it into steps, for example..
Load the Data QVD first into a resident table
Format Dates or Text of that resident table
Then Aggregate the Data.
One function that we came across that was constantly max the CPUs was the DayStart() Function. Use an alternative such as Date(Floor(date_field)) instead.