Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Feb 13, 2024 4:51:21 AM
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:
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:
This method will delete the removed node.
All settings related to this node will be deleted, such as Engine settings, Proxies, and Schedulers.
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.