topic Re: Clustering Issues in QlikView

Clustering Issues

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

We recently got a cluster license and after trying to cluster the 2 server we are experiencing inconsistency.

The setup:

- 2 Servers (for the sake of server names lets call server 1 as server A and server 2 as server B)

- Each server running all the default QV services

- We have put a VIP (Vitual IP with Stickeness) on top of the 2 server in round robin mode so that the load on the web app is distributed equally

- The QVD files are located on server A and are shared with a UNC path (\\ servername\C$\path....). Both servers are pointing to a shared drive

- 64bit server on windows 2008

Issues we are facing:

- Server A where we have put in the cluster license first sees both servers and it appears that the cluster is setup correectly

- Server B does not see server A. It appears that its pointing to local host even though the cluster license has been put in and all the clustering steps are followed

- Server A shows the cluster name and Server B shows local host under cluster section as well as access point server connections

- I have tried to use the QvsStatus tool from server A and see clustering for both server up and running however when going fro B server, I only see localhost

Clustering Issues

garystrader — Thu, 12 Apr 2012 16:13:00 GMT

First problem - you shouldn't install all the default QV services on each server. In particular, you should only have one QMS installed. There is supposed to be one master QMS within an environment that coordinates everything between the multiple servers. If you have multiple the can conflict with each other, and it's possible this is your problem.

Rather than trying to fix it, I would get the official clustering setup document from QlikTech Support and start from scratch. Otherwise you may spend days troubleshooting a corrupted environment.

Re: Clustering Issues

Bill_Britt — Thu, 12 Apr 2012 17:13:00 GMT

I would agree with Gary here. This isn't something you can easly fix. I am going to mark Gary's answer as the correct answer also.

Clustering Issues

Thu, 12 Apr 2012 17:23:14 GMT

Gary,

Thanks for your inputs. Interestingly enough, I did follow Qlikview white paper documentation on clustering, however it still does not seem to work as expected. It does not say anywhere in the document that all the services should not be installed on the same servers. I think the issue is that the 2nd server does not recognize the 1st server as a cluster and I think there are some settings which need to be configured on the second server to get it recognized.

Have you setup clustering before and if so, did you have to copy or replicate the xml files from master server to the other servers in the cluster?

Thanks.

Clustering Issues

garystrader — Thu, 12 Apr 2012 17:33:16 GMT

I have set up clustering many times. I've never done anything with XML files. When properly set up, the cluster servers coordinate with the others via the shared PGO files.

Can you attach the documentation you're using, and if I have time I will see if it's the same documentation I've used before.

Clustering Issues

Bill_Britt — Thu, 12 Apr 2012 17:35:41 GMT

Gray, I am writing him an email offline right now. I am going to try to explain the differences in setup so he will understand that he doesn't need everything on the second server.

Re: Clustering Issues

markmccoid — Mon, 23 Apr 2012 18:21:26 GMT

Hi,

I'm going through the same thing with Clustering. I'm going to try and attach the document I followed, but would be very appreciative if you have more detailed information.

This document (From QV Support) seems focused just on the clustering the server without mention of the other services.

Thanks,

Mark

Re: Clustering Issues

garystrader — Wed, 25 Apr 2012 11:28:45 GMT

That's the correct document, although there might be a new version out. The steps in the document aren't very detailed, but the basic idea is that you should only have one QlikView Management Service installed in your environment. In the minimal possible configuration, you would have three servers. On the first server you would do a full service install - all five services will be installed - QVS, QVWS, QDS, DSC, and QMS. On server 2 and 3, you only install QVS. These two servers are "headless", they don't have a local QMS to manage them. You would license server 1, and add server 2 and 3 QVS instances to the server 1 cluster configuration in QEMC system/setup. You do NOT add server 2 and 3 to the "QlikView Servers" list shown in the tree menu in system/setup. Again, they're headless and you're not supposed to be able to configure them independently of the cluster.

As of version 10 you can cluster QDS and DSC, but this isn't something that you would do by default. The clustering of each service serves a different purpose and it's only worth purchasing and setting it up if you need it.

Re: Clustering Issues

markmccoid — Wed, 25 Apr 2012 20:24:06 GMT

Thanks for the clarification Gary.

Another question...we had originally thought about doing an active/passive failover, but then decided to go with the cluster, however when looking at the recommended configuration, it looks like if the server with the Managment server and web server on it failed, we would be dead in the water.

Do you have any recomendations on making a cluster more resilant?

I'm no expert with clusters and the like, so I may have missed something obvious.

Thanks,

Mark

Re: Clustering Issues

garystrader — Wed, 25 Apr 2012 23:16:42 GMT

In a QlikView Server cluster, the single point of failure are the PGO files which are located on a network share. Since QlikTech does not currently support storing PGO files on a SAN or NAS, you are stuck with local drive shares. If the drive fails (hopefully you have RAID), or the server dies or crashes, your cluster is dead. I am not aware of a workaround or alternative.

A single web server would also be a single point of failure. For this reason they are commonly put in a "cluster" of two or more web server machines, with a hardware load balancer directing sticky sessions to them. You can do this without any special licensing, but it does require a hardware load balancer.

With any QlikView service, you can always set up a cold failover. Have servers on standby and when one of the active servers dies, apply the license to the failover machine, repoint DNS, etc.

Re: Clustering Issues

Fri, 22 Jun 2012 12:15:33 GMT

Gary,

In a QlikView Server cluster, the single point of failure are the PGO files which are located on a network share.
Since QlikTech does not currently support storing PGO files on a SAN or NAS, you are stuck with local drive shares.
If the drive fails (hopefully you have RAID), or the server dies or crashes, your cluster is dead. I am not aware of a workaround or alternative.

Could you explain this further? We are running QVS in a HOT HOT configuration with a pair of servers. Don't the pgo files have to be in a shared location accessible by both QVS.exe processes ?

Re: Clustering Issues

stevedark — Wed, 05 Sep 2012 13:36:15 GMT

Hi,

We have clustering set up and working successfully (QV11 SR1 Cluster Licence). We currently have two servers clustered and distribution services installed on both servers but the services are stopped on one server (Hot/Cold). In the event of the server with distribution services failing we can start distribution services on the other server and hook that into QMC and things carry on as before.

Where we currently have an issue though is if we can not get to QMC because this is on the machine that has failed. In this case we could not bring the distribution services up properly on the other server.

Our first thought was to install Management Services on the second server so that it can be accessed from either server. However, the server install documentation (and indeed this thread) warns against doing this.

Given that, what would the best way forward be? We are considering a similar approach for QMC as distribution services - where the server is installed on both machines but only running on one at any given time. Another consideration is not running the management services on either QlikView server - but rather having it on a separate VM that can be imaged and be protected with VM fail over. This way whatever affects either of the QlikView servers would not also affect the management console.

Any thoughts anyone has on any of this would be greatly appreciated.

Steve

Re: Clustering Issues

dde — Wed, 05 Sep 2012 17:34:12 GMT

In that scenario I would install the QMS on two servers but set one to disabled. Move your QMS application config and QVPR to the share. You would the need a process in place to ensure only one QMS can be up at any one time.

Looking at other comments in this thread:

DSC - I always cluster this, there are no cost implications so why not?

File Share - yes a single point of failure but could be on a Microsoft cluster so will still be a "true" Windows share. Note it can be a NAS/SAN providing a true Windows share is in front of it (e.g. a VM).

Web Server - for resilience your should have 2+ of these also with a network load balancer in front to handle incoming traffic. All web servers would talk to all QVSes.

Thanks

Dave

Re: Clustering Issues

stevedark — Thu, 06 Sep 2012 21:26:34 GMT

Hi Dave,

Many thanks for your input here. The QMS on both servers - but only ever one at a time sounds like a sound approach. Can you please advise how we can move the QMS application config to our file share? We already have the root folder (all pgo files), logs, extensions and temporary files on the share - but I believe all the xml config files are still sitting on the master server.

Thanks in advance.

Steve

Re: Clustering Issues

dde — Thu, 06 Sep 2012 21:41:20 GMT

In C:\Program Files\QlikView\ManagementService (exact path may differ) there is a file named QVManagementService.exe.config. Within there is an application base path. Two caveats though:

1.) Because the above path is in Program Files it may be overwritten during upgrades

2.) Some of these .config files have some settings you should *never* change.

Re: Clustering Issues

stevedark — Thu, 06 Sep 2012 22:18:15 GMT

Just to make absolutely sure I have this correct, we should:

1. Stop QV services

2. Find the current folder loction in QVManagementService.exe.config

3. Copy all files from that location to a location on the shared drive

4. Modify QVManagementService.exe.config to point to new location

5. Start up services and test single QMS

6. Stop QMS services on first server

7. Install QMS on second server

8. Modify QVManagementService.exe.config on the second server to point to shared location

9. Start QMS services on second machine and test

10. Test stopping and starting QMS on each each server to ensure switch over solid

Many thanks for your help.

Re: Clustering Issues

rwunderlich — Thu, 06 Sep 2012 22:42:19 GMT

Steve, another option is to host your QVPR on SQL Server instead of XML. This makes the config of mutiple QMS' easier.

While a hot/cold QMS is possible, I actually prefer your solution of a seperate QMS image.

-Rob

Re: Clustering Issues

stevedark — Thu, 06 Sep 2012 23:07:06 GMT

Hi Rob - thanks for your input. The separate QMS image certainly feels simpler to me. It will be up to the client what they go with though.

Cheers,

Steve

Re: Clustering Issues

danielrozental — Fri, 07 Sep 2012 00:23:08 GMT

Steve, instead of changing config files (that get overwriten by upgrades) you can create a soft link to the correct folder.

Something like this. http://qliktips.blogspot.com.ar/2012/02/move-your-qliktech-programdata-folder.html

Re: Clustering Issues

dde — Fri, 07 Sep 2012 05:45:46 GMT

That's the gist of it yes Steve. You would need to ensure you were able to be 100% certain that only one QMS can be active at any one time, whether this is done by technology (e.g. MSCS) or having robust manual procedures is up to you.

The single image solution containing the QMS and maybe even the QDS is more common and I deploy that sometimes too.