Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Removing Failover Candidate status from a Qlik Sense Rim Node

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Removing Failover Candidate status from a Qlik Sense Rim Node

Last Update:

Feb 13, 2024 4:51:21 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jan 26, 2018 5:16:56 AM

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:

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

    reveal node ID.png

Removing a Failover Candidate using the Qlik Sense Enterprise Management Console

This method will delete the removed node.

  1. Open the Qlik Sense Enterprise Management Console
  2. Navigate to Nodes
  3. 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.
  4. Add the node again (Creating a node)
  5. 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.

  1. Stop all Qlik Sense services except the Qlik Sense Repository Database
  2. Once you've connected to the database, navigate to the table ServiceNodeConfiguration
  3. Right-click and select "View/Edit Data > All Rows"

    view and edit data in servicenodeconfiguration table.png

  4. Scroll to the end of the table, and double-click the FailoverCandidate boolean value
  5. Edit that value, setting it to false

    set failovercandidate boolean value to false.png

  6. Click Save

    save settings in table.png

 

Labels (2)
Version history
Last update:
‎2024-02-13 04:51 AM
Updated by: