Removing Failover Candidate status from a Qlik Sense Rim Node

Sonja_Bauernfeind — Tue, 13 Feb 2024 09:51:21 GMT

Qlik Sense Enterprise on Windows provides the ability to set a Central Node Failover. See Configuring failover for central node resiliency for details.

This article explains details the possible methods on how to change the Failover Candidate option.

Content:

Removing a Failover Candidate using the Qlik Repository API

This is the recommended method.

It's possible to toggle the Failover Candidate setting using the API. This ensures that no settings are lost. See Manually migrating the central node. For reference and additional instructions, see put /servernodeconfiguration/{id} and Qlik Sense QRS API using Xrfkey header in PowerShell.

Example:

$hdrs = @{}
$hdrs.Add("X-Qlik-xrfkey","12345678qwertyui")
$hdrs.Add("X-Qlik-User","UserDirectory=DOMAIN;UserId=Administrator")
$cert = Get-ChildItem -Path "Cert:\CurrentUser\My" | Where {$_.Subject -like '*QlikClient*'}
$url = "https://qlikserver1.domain.local:4242/qrs/servernodeconfiguration/5acededb-89a2-46f4-b39b-3ff21b4984a5?xrfkey=12345678qwertyui"
$body = '{
  "failoverCandidate" :false,
  "modifiedDate" : "2024-02-14T05:12:29.536Z"
}'
Invoke-RestMethod -Uri $url -Method Put -Headers $hdrs -Certificate $cert -ContentType "application/json" -Body $body

In this code sample, 5acededb-89a2-46f4-b39b-3ff21b4984a5 is your node ID. To locate the ID:

Open the Qlik Sense Enterprise Management Console
Navigate to your Qlik Sense Node
Enable the ID column for view and copy the revealed value

Removing a Failover Candidate using the Qlik Sense Enterprise Management Console

This method will delete the removed node.

Open the Qlik Sense Enterprise Management Console
Navigate to Nodes
Delete the node you wish to discard (Deleting nodes)
All settings related to this node will be deleted, such as Engine settings, Proxies, and Schedulers.
Add the node again (Creating a node)
Restart Qlik services on the node

Removing a Failover Candidate in the Qlik Sense Repository Database

Warning:Qlik cannot support direct queries and access to the underlying product's database hosted by PostgreSQL. If any issues arise for which direct queries are deemed responsible, Qlik Support will reserve the right to request that a previous working backup is restored to the system in order to bring back full operation or resolve any isolated issue(s).

You can toggle the Failover Candidate option in the database under using the ServiceNodeConfiguration table.

pgAdmin is required for this method. See How to connect to the Qlik Sense Enterprise on Windows or Qlik NPrinting PostgreSQL database.

Stop all Qlik Sense services except the Qlik Sense Repository Database
Once you've connected to the database, navigate to the table ServiceNodeConfiguration
Right-click and select "View/Edit Data > All Rows"
Scroll to the end of the table, and double-click the FailoverCandidate boolean value
Edit that value, setting it to false
Click Save

article Removing Failover Candidate status from a Qlik Sense Rim Node in Official Support Articles

Removing Failover Candidate status from a Qlik Sense Rim Node

Removing a Failover Candidate using the Qlik Repository API

Removing a Failover Candidate using the Qlik Sense Enterprise Management Console

Removing a Failover Candidate in the Qlik Sense Repository Database