Qlik Community

Ask a Question

Knowledge Base

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY

Lost connection to server, Reconnecting or Session Lost when accessing QlikView documents

Juli_K
Support
Support

Lost connection to server, Reconnecting or Session Lost when accessing QlikView documents

Opening or navigating a QlikView application with the Full Browser client leads to "Lost Connection, Reconnecting." or "Session Lost". This is often caused by large documents or complex calculations that take longer then the configured timeout. 
 

User-added image


The same behaviour is not seen when using the Internet Explorer plugin.
The problem can occur for both the QlikView WebServer and Microsoft IIS.

Environment:

  • QlikView 



 

Cause:

This issue may happen if the document contains complex formulas/calculations, or the data set is too large for the standard timeout. 
The Internet Explorer plugin communicates directly with the QlikView Server, while the Full Browser Client (AJAX) communicates with the web server first. Different timeout values apply.
QlikView WebServer, as well as Microsoft IIS, have a timeout value which at a default of 60 seconds.

 

Resolution:


There are different timeout values that can be adjusted to allow the webserver to wait for a return from the QlikView server longer, as well as to allow calculations more time to complete. Keep in mind that it is recommended to tune these settings to an appropriate level based on your environment. The settings used in the examples below are based on very large applications. 

QlikView WebServer 

Increase QvsTimeout value. 

  • Stop the QlikView WebServer Service
  • Navigate to %ProgramData%\QlikTech\WebServer
  • Open config.xml
  • Change <QvsTimeout>60</QvsTimeout> accordingly
  • Save the file, and start the QlikView WebServer Service
User-added image


For QlikView November 2017 SR1 and above:  Release notes attached for QV 12.20 SR1

Increase SocketTimeOutInSeconds value. See QlikView 12.10 and November 2017 AccessPoint to Server timeout: Lost Connection to Server Reconnecti...

If using QlikView Web Server:

  • Stop the QlikView WebServer Service
  • Navigate to C:\Program Files\QlikView\Web Server
  • Open QVWebServer.exe.config
  • Inside the <appSettings> section, add the following key (if not already present): 
  • <add key="SocketTimeOutInSeconds" value="600"/>
  • Save the file, and start the QlikView WebServer Service

 
If using IIS:

  • Open IIS manager on the web server
  • Highlight the Default Web Site (if not using Default Web Site, select the web site which was chosen during the QlikView Settings Service installation process)
  • Double-click Application Settings
  • Right-click in blank space and choose Add
  • In Name field, enter SocketTimeOutInSeconds, In Value field, enter desired value, click OK

*a value of 600 will set the timeout value to 10 minutes

The configuration file that shows the current value can be found in C:\inetpub\wwwroot\web.config on a default installation.
 

QlikView Server Calculation Timeout


Increase Object Calculation Time Limit in the QlikView Management Console (QMC). Default is 60 seconds.

In the QlikView Mananagement Console, navigate to System > Setup > QVS@node > Performance tab 
Modify the Object Calculation Time Limit.
 

User-added image

 

Optional: Turn off Session Recovery


This will prevent the Full Browser Client to reconnect to a previous session and may help with stability. It will not adjust any timeout values, however. 

In the QlikView Mananagement Console, navigate to System > Setup > QVS@node > Documents tab 
Uncheck the Allow Session Recovery box.
 

User-added image

 

Microsoft IIS as the WebServer

Increase execution timeout in the Configuration Editor of IIS Manager. 
Navigate to the WebSite which has QlikView installed and open the Configuration editor. 
 

User-added image
Labels (1)
Version history
Revision #:
3 of 3
Last update:
‎2021-02-11 04:45 AM
Updated by:
 
Contributors