Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register 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

Tags

Classifications

Public