Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
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
20:22, 23 May 2017

Tags

Classifications

Public