web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Impossible to delete c...

Microsoft Dynamics 365 | Integration, Dataverse...

Answered

Impossible to delete commands in entity

(2) Share

Report

Report

Posted on by Anthony Des

43

My entity has commands that I cannot delete.

This is the error

Sql error: Statement conflicted with a constraint. The DELETE statement conflicted with the REFERENCE constraint "appaction_appactionrule_classicrulesOne". The conflict occurred in database "db_crmcoreemea_20230222_08120298_b3a7", table "dbo.appaction_appactionrule_classicrulesBase", column 'appactionid'. The statement has been terminated. CRM ErrorCode: -2147185375 Sql ErrorCode: -2146232060 Sql Number: 547

Does someone have any idea?

Categories:

Dynamics 365 general

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Anthony Des 43 on at

Like (1)

Report
Copy link

Link copied!

I found this solution, use SQL4CDS to delete this relation with this query:

delete from appaction_appactionrule_classicrules where appactionid in (select appactionid from appaction where appmoduleidname like 'FriendlyNameOfYourModelDrivenApp');

Select commands under table you want to remove commands and delete entries you want delete.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,722 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Anthony,

Can you confirm you found your own answer and the question can be closed? If so, please mark your reply so the thread will get the status Answered.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

#2

ManoVerse 58 Super User 2026 Season 1

#3

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans