Loading...

Knowledge Center


The DELETE statement conflicted with the REFERENCE constraint (when Application and Change Control events are purged from ePolicy Orchestrator)
Technical Articles ID:   KB87648
Last Modified:  10/13/2016

Environment

McAfee Application and Change Control 7.0.x, 6.x
ePolicy Orchestrator 5.x

Problem

The following error appears in the Orion.log file when you attempt to purge Application and Change Control events from the ePO database:
 
 The DELETE statement conflicted with the REFERENCE constraint "SCOR_EVENTS_EPO_EVENTS".
 The conflict occurred in database "", table "dbo.SCOR_EVENTS", column 'EPO_EVENT_AUTO_ID'.
 

Cause

The EPO_EVENT_AUTO_ID field, in the SCOR_EVENTS table of the ePO database, is missing the cascade option. The cascade option cannot be applied because an FK constraint is present on the field.

To view the constraint, run the following command against the ePO database:
 
 SELECT  
     f.name AS foreign_key_name
     ,OBJECT_NAME(f.parent_object_id) AS table_name
     ,COL_NAME(fc.parent_object_id, fc.parent_column_id) AS
 constraint_column_name
     ,OBJECT_NAME (f.referenced_object_id) AS referenced_object
     ,COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS referenced_column_name
     ,is_disabled
     ,delete_referential_action_desc
     ,update_referential_action_desc 
 FROM sys.foreign_keys AS f 
 INNER JOIN sys.foreign_key_columns AS fc  
     ON f.object_id = fc.constraint_object_id  
 WHERE f.parent_object_id = OBJECT_ID('scor_events');

 The output should be similar to the example below:

foreign_key_name table_name constraint_column_name referenced_object referenced_column_name is_disabled delete_referential_action_desc update_referential_action_desc
SCOR_EVENTS_EPO_EVENTS SCOR_EVENTS EPO_EVENT_AUTO_ID EPOEventsMT AutoID 0 CASCADE CASCADE

 

Solution

Run the following command against the ePO database to drop the constraint and recreate the constrained AUTO_IDs:

alter table [dbo].[SCOR_EVENTS] drop constraint SCOR_EVENTS_EPO_EVENTS;
alter table [dbo].[SCOR_EVENTS] add constraint SCOR_EVENTS_EPO_EVENTS
foreign key (EPO_EVENT_AUTO_ID) references  [dbo].[EpoEvents] ON DELETE
CASCADE ON UPDATE CASCADE;

 

Rate this document

Languages:

This article is available in the following languages:

English United States
Japanese

Glossary of Technical Terms


 Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.