Network Management

Node list is empty after migrating a polling engine in the Orion Platform

This article shows how to fix and update the Server Engine ID in the Orion Database seen when the Node list is empty after a migration of a polling engine.

First published date

10/24/2018 8:41 AM

Last published date

1/25/2023 8:04 PM

Overview

This article explains the behavior seen in Manage Nodes after migration of the primary or additional polling engine to an entire new server. 


You may also see the Polling Details resource on the Node Details view empty as well:

Product section

Network Performance Monitor

Cause

This issue is commonly found when a new server is implemented and the old Orion server is decommissioned. If the migration steps located in the Migration Guide  are not properly completed as exactly shown in the Admin Guide, there will be orphaned nodes with the wrong EngineID. This happens when the nodes are not migrated after the old engine is removed from the database via Web Console > Settings > Polling Engines > Delete Unused Polling Engine .

Resolution

  • Open Database Manager on the main Orion server.
  • Click Add Default Server.
  • Click + to expand Server.
  • Click + to expand Database.
  • Right click on the table 'Engines', and click Query table.
  • Click Execute query to run the query, which lists the contents of the table in the Results page.
  • Find the EngineID of the correct Primary engine:
  • Right click on the database and select 'New query'.
  • Enter and update the following query to reflect the correct EngineID for Migrated polling engine:
-- 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 [dbo].[NodesData] Set EngineID ='NewengineID' where EngineID ='PreviousEngineID'
  • Execute the query by clicking 'Execute query' at the top of the window.