Unable to view and add nodes in the Manage Nodes page of the SolarWinds Platform Web Console

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

The following message is shown in the OrionWeb.log that can be found in the  C:\ProgramData\SolarWinds\Logs\Orion folder:

<Timestamp> 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

This issue occurs if the old SolarWinds Platform server is still in the Engines table of the database and the nodes are still using the old EngineID after migration.

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 Platform > Database Manager.
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: 

   -- 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.
   UPDATE [NodesData]
   SET [EngineId] = NumberGoesHere

   Example: Old EngineId = 1       New EngineId = 2

   -- 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.
   UPDATE [NodesData]
   SET [EngineId] = 2