Orion services showing 'Machine 'XXXXX' doesn't host any Engine.' errors after migration

11/5/2020 3:52 AM

1/11/2022 12:00 PM

SolarWinds Events logs show the following:
 

Network Performance Monitor

Migration was not performed correctly which cause duplicate 'Primary' server entries in the Engines Table. 
   
 

Please perform the following steps:
1. Logon to your Orion Server and stop all Orion services
2. Go to Start > All Program > SolarWinds Orion > Database Manager
3. Expand the database > query any table in your database (ex: right-click on a table and choose Query table)
4. Remove the default query, paste the query below then click on Execute 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.
DECLARE @oldHostname nvarchar(max)
SET @oldHostname = 'Server1' /* Replace Server1 with OLD hostname */
DECLARE @newHostname nvarchar(max)
SET @newHostname = 'Server2' /* Replace Server2 with NEW hostname */
UPDATE Engines SET ServerName = @newHostname WHERE ServerName = @oldHostname
UPDATE WebSettings SET SettingValue = @newHostname WHERE SettingName = 'JobSchedulerHost'
UPDATE Websites SET ServerName = @newHostname WHERE ServerName = @oldHostname
UPDATE OrionServers SET HostName = @newHostname WHERE HostName = @oldHostname

5. Remove the query above again and paste in the following:

-- 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 [dbo].[Engines] where engineid=AAA

Note:
Replace AAA with the EngineID that has no elements assigned. In this case, it would be EngineID=2 since it is the duplicate engine and has no elements assigned to it. 
 
6. Clear Information Service Subscriptions
7. Start All Orion services and verify if the services start successfully.