How to enable load balancing when opening the AccessPoint to load the list of document

[Bastien_Laugiero]

Load balancing of documents opened on the AccessPoint is configured in the following section in the QlikView Management Console:

> System > Setup > QlikView Web Servers > AccessPoint > Server Connections

The choices are Random, Loaded Document, CPU with RAM Overload.

See the QlikView online QlikView Web Server [Load Balancing section] for details on load balancing methods. 

However, this setting will only load balance when an application (.qvw) is being opened on the AccessPoint and not the actual method of obtaining the list of available documents.  

When opening the AccessPoint, the QlikView Web Server requests the list of documents a user is allowed to view. This request is sent to the QlikView Server.

As the above configuration do not load balance this process, you might end up in a situation where the QlikView Web Server is going to ask the list of documents to a very busy QlikView Server which might then time out. 

Environment:

QlikView 

Resolution:

There is another setting to also load balance this process. To enable this load balancing you will need to: 

QlikView WebServer

1. Stop the QlikView WebServer service in the Windows Services console
2. Navigate to C:\Program Files\QlikView\Server\Web Server Settings
3. Locate and open QVWebServerSettingsService.exe.config in a text editor with administrative permissions
4. Locate the setting called OpenAccessPointLoadBalancer 
   

   <add key="OpenAccessPointLoadBalancer" value="True"/>

   
   
5. Change false to true
6. Save the configuration file
7. Start the QlikView WebServer service

QlikView IIS

1. Open the Internet information Service (IIS) Manager
2. Open the Default Web Site (or whichever Site QlikView has been configured in)
3. In the ASP.NET section open Application Settings
   
   
4. Click Add... (top right corner, or right click into white space)
5. Add a new Application Setting 
   Name: OpenAccessPointLoadBalancer
   Value: true
6. Click OK
7. Restart the QlikView Application Pool, or reset IIS