Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Unable to view and add nodes in the Manage Nodes page

Unable to view and add nodes in the Manage Nodes page

Updated May 19, 2017

Overview

Nodes cannot be viewed or added in the Manage Nodes page after migrating the Orion server.

The following message is shown in the OrionWeb log:

2017-05-17 10:34:15,379 [33] (4) ERROR Orion_Nodes_Add_Default - (null) System.ServiceModel.FaultException`1[SolarWinds.Orion.Core.Common.CoreFaultContract]: ProvideFault failed, check fault information. (Fault Detail is equal to SolarWinds.Orion.Core.Common.CoreFaultContract(Unknown): System.ArgumentOutOfRangeException: Engine Id 1 does not exist

Environment

All Orion Platform versions

Cause 

This issue occurs if the old Orion server is still in the Engines table of the database and the nodes are still using the old Engine ID after migration.

Resolution

Note: Back up your database before performing the following steps.

Verify if the nodes are using the old Engine ID

  1. Go to All Programs > SolarWinds Orion > Advanced Features.
  2. Expand the SolarWinds database and locate the Engines table.
  3. Right-click the Engines table and select Query table.
  4. Take note of the Engine ID of the old and the new servers.
  5. Right-click the NodesData table and select Query table.
  6. Check the nodes if they are using the EngineID of the old server.

Delete the old server entry

  1. In the Database Manager, right-click the Engines table and select Query table.
  2. Select Enable table editing, right-click the old server’s row in the table and select Delete the selected row(s).

Change the Engine ID of the nodes

  1. Right-click the SolarWinds database in the Database Manager and select New Query.
  2. Run the following query:
    SELECT TOP 1000 * FROM [dbo].[AllEngines]
    Update [dbo].[NodesData] set engineid = 'NumberGoesHere' 

    Example: Old EngineId = 1       New EngineId = 2

    Update [dbo].[AllEngines] set EngineId = 2
    Where EngineId =  1
    For NPM 12.x:
    
    Update [dbo].[NodesData] set engineid = NumberGoesHere 
    

    Example: Old EngineId = 1       New EngineId = 2

    Update [dbo].[NodesData] set Engineid = 2

 

Last modified

Tags

Classifications

Public