Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Network Performance Monitor (NPM) > Remove orphaned standby High Availability servers

Remove orphaned standby High Availability servers

Updated March 23, 2017

Overview

This article provides brief information and steps to resolve an issue when the NPM server High Availability (HA) Deployment Summary status shows as down with no obvious way to remove the server. 

 

 

Environment

NPM 12.0.1

Cause 

Limitations of HA v1. This will be automatic or GUI in HA v2.

Resolution

Clean up HA tables after renaming server/Orion server migration/...

  1. Locate the orphaned Orion polling engine and use the following DELETE SQL statement:
    Note: This part will remove the orphaned records, but is recommended to clean up orphaned records for HA as shown in steps 5 below.
    If the server is orphaned and not in an HA pool, proceed with step 4. Otherwise, continue with the procedure.

    * DELETE FROM [dbo].[OrionServers] where OrionServerID = xyz  

    * SELECT TOP 1000 * FROM [dbo].[OrionServers]

  2. Disable HA pool and then stop the HA service on both members.
  3. In the database, manually delete obsolete servers in the OrionServers table.
    DELETE FROM [dbo].[OrionServers] where OrionServerID = xyz   
  4. Run the following script:

    /****** Script for deleting obsolete pool members ******/

    DELETE HA_PoolMembers

    FROM   HA_PoolMembers

           LEFT JOIN OrionServers

                  ON HA_PoolMembers.HostName = OrionServers.HostName

    WHERE  OrionServers.HostName IS NULL

     

    /****** Script for deleting obsolete resources ******/

    DELETE HA_ResourcesInstances

    FROM   HA_ResourcesInstances

           LEFT JOIN OrionServers

                  ON HA_ResourcesInstances.PoolMemberId = OrionServers.OrionServerID

    WHERE  OrionServers.OrionServerID IS NULL

     

    /****** Script for deleting obsolete facilities ******/

    DELETE HA_FacilitiesInstances

    FROM   HA_FacilitiesInstances

           LEFT JOIN OrionServers

                  ON HA_FacilitiesInstances.PoolMemberId = OrionServers.OrionServerID

    WHERE  OrionServers.OrionServerID IS NULL

     

    /****** Script for deleting obsolete IP addresses ******/

    DELETE HA_PoolMemberInterfacesInfo

    FROM   HA_PoolMemberInterfacesInfo

           LEFT JOIN OrionServers

                  ON HA_PoolMemberInterfacesInfo.PoolMemberId = OrionServers.OrionServerID

    WHERE  OrionServers.OrionServerID IS NULL

  5. Start the HA services then enable the pool.

Query is deleting poolmemberswhich are not in the OrionServerstable and then all Resources/Facilities/IP addresses of non existing pool members.

 

 

 

 

Last modified
18:48, 22 Mar 2017

Tags

Classifications

Public