How to clear the cache used by QlikView Server

How to clear the cache used by QlikView Server

Description
The cache is handled automatically by QlikView Server and should not be cleared manually. However in some situations there might be a reason to clear the cache on a regular basis, typically once a day.


Resolution
The first and obvious way to clear the cache is to restart the QlikView Server service. This can be donemanually or through a scheduled stop & start of the service using the command netstop & netstart.

net stop QlikViewServer
net start QlikViewServer

Another option is to add the following entry in the [Settings 7] entry in the settings.ini file for QlikView Server,located in %ProgramData%\QlikTech\QlikView Server:
[Settings 7]
ClearCacheTimesPerDay=1

The value set is the number of times per day the cache will be cleared, syncronized at midnight. A value of 1will clear the cache once per day at midnight.

Attention: Clearing the cache may lead to increased response times from the user's perspective. Use withcaution!

Qlikview Server Clustering

Qlikview Server Clustering

Prerequisites:

Following requirements have to be met before starting the QlikView Server cluster configuration:

• A QlikView Server license allowing QlikView Server clustering.  That means that the QlikView Server LEF must consist of an entry “NUMBER_OF_CLUSTER_NODES;X;;” where X is 2 or higher
• AccessPoint (based on IIS or QlikView Web Server), Management Service, Qlikview Distribution Service, Directory Service Connector are already installed on QlikView system in the network
• A domain user to run the QlikView services on every machine is available.
• A Windows Network-Share
• All QlikView Server cluster nodes need read /write access to the following data centrally stored:
• Server status files aka .pgo
• QlikView Documents aka QVWs
• QlikView Server Logs aka audit, session, performance, event logs

Step-by-Step Installation

1. Prepare the shared device:

Create folders for the files accessed by every QlikView Server cluster node.:

• QvRoot for the .pgo-Files
• QvMount for a Mounted Folder
• QvLogs for the Logfiles
• QvExtensions for the extensions
• QvTemp for the temp files

2. Prepare the cluster nodes:

On each planned QlikView Server cluster node perform the following configuration

•   Login as Administrator
•   Turn Off Windows Firewall 

 

•   Deactivate Internet Explorer Enhanced Security Configuration for Administrators

• Add Domain User the QlikView services should use to Local Administrators Group
• Start QlikView Server setup and install feature “QlikView Server” only

NOTE: Do not install any other services such as QlikView Management Service on multiple nodes in the cluster!

• During the setup check that you will specify the QlikView service account later 

• Do not restart the system immediately after install is completed, but
    o   Add QlikView service user to “QlikView Administrator Group”
    o   Change Logon setting of the QlikView Server Service to the QlikView Service user
• Restart the system

3. Configure QlikView Server-Cluster in QlikView Enterprise Management Console

• Open QlikView Enterprise Management Console and register QlikView Server licence with activated cluster nodes

• Add first QlikView Server cluster node below QlikView Servers

• Switch Root,Mount,Logs,Extensions and Temp Folders to Shared Device folder paths using UNC-syntax (i.e \\Fileshare\QvRoot)

• Press Apply and let QlikView Enterprise Management Console initiate restart of QlikView Server service
• Add each additional QlikView Server cluster node and activate them by entering control number of the registered QlikView Server license

• Press Apply and let QlikView Enterprise Management Console initiate restart of QlikView Server service on all nodes
• Verify all QlikView Server nodes are running

• Configure Load Balancing feature (Functionality see QlikView Server Reference Manual)