Qlikview Server stops responding V9 SR5

[#1]

Hi All,

We recently upgraded to V9 SR5 (last Wednesday) and this week I have noticed that each day around midday the Qlikview Server service is showing as stopped in the Qlikview Management Console, even though it is still running as far as Windows is concerned.

(When the problem happens the QlikviewServer is shown as Stopped)

I had a look through the Event Viewer in Windows and noticed a number of failures for the CommandCenterService:

This is happening around the time that we get the issue, however I did see a successful connection at 12:26PM. Im not sure if these errors are related to the issue I am getting with the Server or not. The error for the CommandCenterService is:

System.TimeoutException: The operation has timed out.

at QlikTech.NetClient.QvClient.GetMessageDataFromSocket(Byte[] buffer)
at QlikTech.NetClient.QvClient.GetMessageSizeFromSocket()
at QlikTech.NetClient.QvClient.Execute(Byte[] request)
at QlikTech.NetClient.QvClient.Execute(String request)
at QlikView.Backstage.Wrappers.QvsWrapper.CallFunction(String methodname, String iStartElement, String iStartAttribute, IXmlSerializable arguments, IXmlSerializable outpar)
at QlikView.Backstage.Wrappers.QvsWrapper.GetServerStatus()
at QVPublisherCommandCenterService.ServiceImpl.DoGetServiceStatuses()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

We are running the following:

Windows Server 2003 R2 (Service Pack 2) x64
Qlikview Server 9.0.7502.8 SR5
Qlikview Client 9.00.7469.8 SR4

Any help would be appreciated!

Regards,

Trevor

[markmccoid]

When this happens what does the memory usage look like?

I've had this happen to me, but the cause was QVS was using all my memory.

[rwunderlich]

Take a look at the QVS Event*.log to see if there are any useful messages.

You're not using the same QVS license key on another machine, correct?

-Rob

[johnan]

Same Problem here, i upgrade memory to 16 GB and i'ts gone.

[#5]

As alerady mentionned could be the memory growing up untill there is nothing left.

You should check if you see memory issues.

This can be also caused by calculated dimensions returning null values ( i saw that in some cases calculated dimensions make the memory increasing indefinitely ( I saw it went to more than 72 GB RAM !).

Not always easy to solve but you should try some of your applications and manipulate them to see if server hangs or not.

Hope it helps.

Sébastien

[#6]

Thanks for the replies, it is appreciated! We have 16GB of RAM on the server, and I have not seen the memory usage at unusual levels when this issue occurs. It usually idles around the 4GB area, however next time it happens I will have a closer look at the memory in case there is a problem there.

Regards,

Trevor

[#7]

Hi, Trevor

I have the same problem and complete the same environment as you.

Windows Server 2003 R2 (Service Pack 2) x64
QlikView Server 9.0.7502.8 SR5
16GB of RAM

We have faced the same difficulty.
I appreciate if you could share your information if you had already sort it out.

Aki

[#8]

Hello ,

I have got the same kind of problem ?

Please suggest ?

Thanks

[#9]

When ever you make upgrade of any product try to do the server sizeing first.

It may be the cause of the memeory and the sever configuration.

Try to check this and increase your hardware memory.

I hope this will work

[#10]

Hi Aki,

We have managed to fix the problem with the following changes:

• Disabled the QlikView WebServer and just run IIS to manage our QlikView webpage
• Disabled tunneling and forced QlikView to run on port 4747 - this was done by editing the "opendoc.js" file in the <path to QlikView>\QlikView\Server\QvClients\QvPlugin folder. See below for the modifications we made:

 if (tunnel != null) {
 host = window.location.host + ";" + tunnel;
 }

 host += "<server>:" + 4747;
......
 var tunneler = /[\?\&]tunneler=([^\&]*)/.exec(window.location.search);
 if (tunneler != null) {
// url += (url.indexOf ('?') == -1) ? '?' : '&';
 tunneler = tunneler[1];
 var pos = tunneler.indexOf("/scripts/");
 if (pos > 0) {
 tunneler = window.location.protocol + "//" + window.location.host + tunneler.substring(pos);
 }
// url += "tunneler=" + tunneler;
 }
 return url;
}

Hope this helps