Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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

  • Orion

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

 

Resolution Two

  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 Engine table, and get the engineID you want to delete.
  7. Execute the query below replacing * with the EngineID

Delete from [dbo].[VoipEngines] where EngineID = '*'

Delete from [dbo].[Engines] where EngineID = '*'

   8. Restart Orion services.

   9. Open the Orion Web Console and verify that the additional polling engine was deleted.

 

 

Last modified

Tags

Classifications

Public