Null entries found in the VOIP Engines table in VNQM

Services may have started on an old decommissioned polling engine. When services are not disabled, and only in a stopped state, the old poller may start the SolarWinds Platform services.

When this occurs, an entry should not exist in the [dbo].[Engines] table. If an entry is present, you would need to run the Configuration Wizard to update that table. You will then start to get NULL entries in [dbo].[VoipEngines] table as the VNQM business layer is trying to find the engine in the engines table, which no longer exists.

1. Connect to the SolarWinds Platform server.
2. Disable or uninstall the SolarWinds services on the old poller.
3. Open the Database Manager from the SolarWinds Platform folder of the Start menu.
4. Select Add Orion Server and expand the SQL Server and database in bold.
5. Right-click the database and select New Query.
6. Paste the below into the window on the right and click Execute.

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

SELECT TOP 1000 * FROM [dbo].[VoipEngines]

7. Locate the VoipEngineID entries. 
8. Execute:

-- 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].[VoipEngines]
WHERE VoipEngineID = the ID you want to remove.

Replace VoipEngineID with the ID you want to remove.