Extra entries are present in Engines or OrionServers tables when using Scalability Engines

If you encounter unspecified issues after upgrade or migration, run the Check Engines and OrionServers integrity test using Active Diagnostics on the Web.

The issues might include:

• Plugins not loading
• Different errors in the logs not leading towards the actual problem

• Upgrade or migration issues can cause this

1. Run the Active Diagnostics test Check Engines and OrionServers integrity.
   1. Connect to the SolarWinds Platform Server.
   2. Open SolarWinds Diagnostics from the SolarWinds Platform folder of the Start Menu.
   3. Select Solarwinds Active Diagnostics at the bottom.
   4. Select Run individual tests, the Check Engines and OrionServers integrity under Orion Database Health.
   5. Select Run Test.

2. Back up the SolarWinds Platform database.

Please note, in High Availability environments, both engines will be listed on the OrionServers table but only the Active server will be listed on the Engines table. These tables are not case-sensitive.
If the test fails:

1. Check the Engines table of the database:
   1. Open Database Manager from the Solarwinds Platform folder of the start menu.
   2. Select "Add Orion Server".
   3. Expand the SQL server and SolarWinds Platform database in bold.
   4. Double-click the Engines Table and execute the query in the window on the right.   
2. Check the OrionServers table of the database:
   1. Navigate to the OrionServers table and double-click.
   2. Execute the query in the window on the right.
3.  Validate that the names listed on the Engines Table are listed on OrionServers table.
4. If there is a server name listed on the OrionServers table  that is not part of your actual SolarWinds Platform deployment, identify the IDs and remove them from the database by executing the following queries:

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

delete from OrionServers where OrionServerID = X
delete from Websites where WebsiteID = X