web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Cannot delete Case rec...
Microsoft Dynamics CRM (Archived)

Cannot delete Case record - DELETE statement conflicted with the REFERENCE constraint

(0) ShareShare
ReportReport
Posted on by VarunMca

We have a custom entity called case history which has a N:1 relationship with Case (incident). The relationship behavior is set to Configurable with Delete set to 'RemoveLink'. But when we delete a case, irrespective of whether it has associated case history records or not, we get an 'SQL error'. When we turn on tracing we see this error:

The DELETE statement conflicted with the REFERENCE constraint "xxx_incident_xxx_casehistory_IncidentId". (xxx = solution prefix)

We even tried changing the relationship type to Parental so that case history gets deleted with case, but we still get the same error. Anybody seen this before or have a solution?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Karsten Wirl Profile Picture
    Karsten Wirl 4,477 on at

    Hello.

    Here is an older blog article, but I guess, you're facing a similar problem:

    edwardsdna.com/.../delete-business-unit-crm-2011

    Kind regards,

    Karsten

  • VarunMca Profile Picture
    VarunMca on at

    Thanks. In our case we already tried that - deleted the child records (case history) before attempting to delete case - when we saw the error initially. Refer this part in my question: "irrespective of whether it has associated case history records or not".

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans