Submit a ticketCall us
Home > Success Center > Network Performance Monitor (NPM) > Unable to delete additional polling engine: The DELETE statement conflicted with the REFERENCE constraint FK_VoipEngines_EngineID

Unable to delete additional polling engine: The DELETE statement conflicted with the REFERENCE constraint FK_VoipEngines_EngineID

Updated May 24, 2017

Overview

The Orion Web Console returns a website error when deleting an additional polling engine and the following message is shown in the OrionWeb.log file when deleting the same polling engine via Database Manager:

ERROR ASP.global_asax - (null)  Application_Error(80749eaa57c24d51a16420a15bb08b3f) System.ServiceModel.FaultException`1[SolarWinds.Orion.Core.Common.CoreFaultContract]: ProvideFault failed, check fault information. (Fault Detail is equal to SolarWinds.Orion.Core.Common.CoreFaultContract(Unknown): System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_VoipEngines_EngineID". The conflict occurred in database "SolarWindsOrion", table "dbo.VoipEngines", column 'EngineID'.

Environment

  • NPM 12.0.1

  • All VNQM versions

Resolution

  1. Stop all Orion services using Orion Service Manager.
  2. Go to  Start > Solarwinds Orion > Advanced Features > Database Manager.
  3. Click Add Server and add the Orion server.
  4. Log in with your SQL Orion account.
  5. Right-click the SolarWindsOrion database.
  6. Locate the dbo.VoipEngines table, and then delete the additional polling engine that you would like to delete.
    Note: 
    You need to delete it first from dbo.VoipEngines to perform the next step.
  7. Locate the Engine table, and then delete the additional polling engine.
  8. Restart Orion services.
  9. Open the Orion Web Console and verify that the additional polling engine was deleted.

 

 

Last modified

Tags

Classifications

Public