topic Re: Lost Connection to Server. Reconnecting in QlikView

Lost Connection to Server. Reconnecting

sjhussain — Wed, 10 Sep 2014 05:58:17 GMT

Hello,

We are facing lot of issues with QV Connectivity and are constantly getting “Lost Connection to Server. Reconnecting”

This is posing a big problem for us with our customer. Everything seemed to be working fine but just three a few days back this started. The irony is that it happened during the demo and we were unable to control it.

This error happens randomly – sometimes it is working fine other times it just keeps on giving the “Lost connection” errors. We noticed that when the error starts - it particularly happens when we make the selections and press the search button. I have checked the internet connectivity and it seems fine. This happened a few times on the Server side also.

Will appreciate if someone can assist us with this as this is a real show stopper with the customer

Thanks.

Re: Lost Connection to Server. Reconnecting

Wed, 10 Sep 2014 06:01:52 GMT

Hi,

Even we are facing similar problem...Kindly suggest the solution

Regards,

Prajna

Re: Lost Connection to Server. Reconnecting

ashfaq_haseeb — Wed, 10 Sep 2014 06:07:15 GMT

Hi,

This could happen if you access Qlikview file with same ID's from two different machines.

Make sure you don't use same account to login from multiple place at the same time.

If so, the later will get connection to server by disconnecting current user and you see that error “Lost Connection to Server. Reconnecting”

Regards

ASHFAQ

Re: Lost Connection to Server. Reconnecting

senarath — Wed, 10 Sep 2014 06:09:07 GMT

Hi,

I'm also having the issue sometime. But what I figured out was the browser. If you are using IE, that work fine but issue starts only in Chrome.

So have you tried out changing the browser ?

Thanx

Senarath

Re: Lost Connection to Server. Reconnecting

engishfaque — Wed, 10 Sep 2014 06:42:03 GMT

Dear Syed,

Define your session time in QlikView Server.

Kind regards,

Ishfaque Ahmed

Re: Lost Connection to Server. Reconnecting

Wed, 10 Sep 2014 09:52:01 GMT

what session time we need to declare?

Maximum num,ber of concurrent user?

Regards,

Prajna

Re: Lost Connection to Server. Reconnecting

Wed, 10 Sep 2014 09:57:32 GMT

Hi,

Please check your session time in server,

you should to increase this time,

Best Regards

Re: Re: Lost Connection to Server. Reconnecting

ashfaq_haseeb — Wed, 10 Sep 2014 10:05:52 GMT

HI,

I don't think that will help in this case.

You can find change session timeout as shown in attached image.

It is by default set to 1800 seconds

have a look at attached image.

Regards

ASHFAQ

Re: Lost Connection to Server. Reconnecting

shane_spencer — Wed, 10 Sep 2014 10:14:11 GMT

Have a read of this post:

Lost Connection in Server - Reconnecting - AJAX

We have similar issues when we also make selections and generate a chart that will bring back a lot of data. It seems this is a common problem looking at the number of posts on here. By applying a change to the "QvsTimeout" we were able to prevent the error message but the data was not returned to screen. By observing Task Manager we could see that the process was still running in the back ground (QVS memory utilisation was increasing). Re-submitting the request would usually return the results on the second or third attempt.

We've raised a case with Qlik. I suggest you do the same.

Re: Lost Connection to Server. Reconnecting

mjayachandran — Thu, 18 Sep 2014 11:09:13 GMT

We are facing the same issue today.. Anyways was able to fix the issue? or know the reason..
Also what version and build or QVS are u using.. ?

Re: Lost Connection to Server. Reconnecting

shane_spencer — Thu, 18 Sep 2014 12:04:30 GMT

We're on v11.2 SR4. We still face the issue and still have a case open with Qlik.

Re: Lost Connection to Server. Reconnecting

mjayachandran — Thu, 18 Sep 2014 15:21:00 GMT

Due to pressure from my client. I had to reinstall qvs and upgraded to sr8.

Re: Lost Connection to Server. Reconnecting

Thu, 27 Nov 2014 06:52:11 GMT

Hi Mahesh.

We're running QV 11.2 SR8 x64, but still we see the problem. Did SR8 solve the problem for you?

@everyone:

Is this a known bug - or did anyone find a solution?

Re: Lost Connection to Server. Reconnecting

mjayachandran — Thu, 27 Nov 2014 07:03:16 GMT

Nope.. we are still seeing the issue. We even migrated the user documents

from NAS to server local drive. Slight improvement in terms of loding

document but we still get the message quite often. We were able to reduce

the frequently of timeouts by increasing the session timeout on our sso.

Hope this helps

Re: Lost Connection to Server. Reconnecting

Thu, 27 Nov 2014 07:19:47 GMT

Hi Shane.

Did you get any answer/solution from the Qlik Support on this problem?

Re: Re: Lost Connection to Server. Reconnecting

shane_spencer — Thu, 27 Nov 2014 08:45:20 GMT

Hi CapHF, the last update I got from Qlik was the following on 29/09:

I now been testing your application. I do not get the same problem as you do it so working fine in my test environment, so my next steps in the tests will be to uninstall IE9 run IE8 and install IIS instead of qlikview webserver in order to see if I can replicate the problems you have with your settings. The next actions then will be to find out what kind of setting it could be causing your problems. I will get back to you as soon as possible with results.

I went on holiday a couple of weeks later and must admit I'd forgotten all about this so have asked them for an update.

Re: Lost Connection to Server. Reconnecting

mjayachandran — Thu, 27 Nov 2014 10:20:04 GMT

Yeah, they suggested us also to move out of qlikview webserver and install

iis instead. We havent seen much difference after we migrated though.

Re: Re: Lost Connection to Server. Reconnecting

shane_spencer — Fri, 28 Nov 2014 11:15:45 GMT

Mahesh I've just had a meeting with Qlik today. They were unable to recreate the issue on their systems using QlikView WebServer so they suggested we move away from IIS 7.5. I stopped IIS and started Web Server then increased the QVS Timeout to 600 (from 60) in the C:\ProgramData\QlikTech\WebServer\config.xml

Even though it took about 5 minutes for the Adhoc Analysis to complete (as expected) when it had finished (observed by monitoring the CPU and Memory of QVS in task manager) the chart loaded on to screen.

Qlik want to close the case but I'm keen to see if they can get it working with IIS whilst I check internally to see if there was a reason the environment was built with IIS that's preventing us from moving to QlikView Webserver.

Re: Lost Connection to Server. Reconnecting

rajeshvaswani77 — Fri, 28 Nov 2014 11:19:16 GMT

Hi,

You might have to check the data volumes of the QlikView dashboard you are using.

Provably calls for optimization of the dashboard formulas and correcting the schema to star schema.

Sometimes if the shared file is corrupted, also this is caused.

thanks,

Rajesh Vaswani

Re: Lost Connection to Server. Reconnecting

simondachstr — Fri, 28 Nov 2014 11:22:32 GMT

Check your event, session and audit logs when the disconnect happens. What do they say?