Setup High Availability Pool button is missing in the SolarWinds Platform Web Console

10/15/2018 8:39 PM

11/20/2024 4:47 PM

Review information and steps on how to resolve the issue where the NPM server High Availability (HA) Deployment Summary does not display options to create an HA Pool.

The SET UP HIGH AVAILABILITY POOL button is missing from the HA Summary page: SolarWinds Observability Self-Hosted Demo - High Availability Deployment Summary
 

 

Network Performance Monitor

This issue occurs when:

• The secondary HA member is installed as another primary polling engine and its registry RunType is set to MainPoller.

• There is no record of the secondary HA member in the OrionServers table, which is crucial in the model for the HA summary.
• This helps to remove only SPECIFIC Pool Member without removing all HA Pools
• The installer  has created an entry  in the Engine table (edit the table and delete )

Fix the registry HA keys and clean up the HA tables.

1. Stop all the SolarWinds services on the standby server via SolarWinds Platform Service Manager.
2. Stop the High Availability service via services.msc and on other non-standby SolarWinds Platform servers.
3. Remove the standby server from the Engines table using the delete SQL statement.
4. Remove respective records from the EngineProperties table and verify that there are no orphaned junk records.
5. Remove the standby server from the Websites table.
6. On secondary HA member, update its RunType to MainPollerStandby:
   HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SolarWinds\HighAvailability\
7. In the following code, provide the orphaned server host name instead of ServerHostname, and run the script in SQL Management Studio or Use Database Manager to view the SolarWinds database:

Script for deleting obsolete pool members:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.


DECLARE @HostnameToClear nvarchar(max)
SET @HostnameToClear = 'ServerHostname'
DELETE FROM Engines WHERE ServerName = @HostnameToClear
DELETE FROM EngineProperties WHERE EngineID NOT IN (SELECT EngineID FROM Engines)
DELETE FROM Websites WHERE ServerName LIKE ('%' + @HostnameToClear +'%')
DELETE FROM OrionServers WHERE HostName = @HostnameToClear
DELETE FROM HA_PoolMembers WHERE HostName NOT IN (SELECT HostName FROM OrionServers)
DELETE FROM HA_ResourcesInstances WHERE PoolMemberId NOT IN (SELECT PoolMemberId FROM HA_PoolMembers)
DELETE FROM HA_FacilitiesInstances WHERE (RefId like '%' + @HostnameToClear + '%')
DELETE FROM HA_PoolMemberInterfacesInfo WHERE PoolMemberId NOT IN (SELECT PoolMemberId FROM HA_PoolMembers)

 

The script deletes references to the orphaned server from the database.

8. If you want to continue using the server as a High Availability server, Run the Orion Configuration wizard  on the server. The Configuration Wizard provides information about the server into the OrionServers table.
9. Restart SolarWinds High Availability Services on the SolarWinds Platform servers via services.msc.

You should now be able to see the "SET UP HIGH AVAILABILITY POOL" button when you open the High Availability Deployment Summary page and proceed to create an HA Pool.