Network Management

Ensure Orion database tables have correct EngineIDs and WebsiteIDs so NPM can operate properly

Check Orion database to make sure the WebsiteIDs and EngineIDs are correct for the following tables: Alerts EngineProperties Events NodesData ReportJobs ReportJobURLs Syslog Traps.

First published date

10/10/2018 5:15 PM

Last published date

1/8/2025 1:03 PM

Overview

For NPM to work properly, ensure Orion database EngineIDs and WebsiteIDs are correct for the following tables:

  • Alerts
  • EngineProperties
  • Events
  • NodesData
  • ReportJobs
  • ReportJobURLs
  • Syslog
  • Traps

Product section

Orion Platform

Cause

This issue can be caused by a change of the IP Address or hostname of the SolarWinds server or even migration of the server.

Resolution

  1. Open the Orion Database Manager
  2. Click Add Default Server
  3. Expand and select the Orion database
  4. To get EngineIDs, query the Engines table.
  5. To get WesiteIDs, query the Websites table.
  6. Query each of the following tables to check if the EngineID or WebsiteID values match with those from the AllEngines table and Websites table:
    • Alerts
    • EngineProperties
    • Events
    • NodesData
    • ReportJobs
    • ReportJobURLs
    • Syslog
    • Traps

If you have migrated check the tables below and other steps:

Check the following Tables for Old Server Name:

  • OrionServers
  • WebSettings
  • Websites,
  • Engines,
  • Subscriptions

In all tables remove the old Engine value:

  • OrionServers,
  • WebSettings
  • Websites
  • Engines


Depending on your issue, you may want to Stop and start all services on all pollers (including the Aditional Web Server)