Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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
20:22, 23 May 2017

Tags

Classifications

Public