Impossible to delete commands in entity

(2) Share

Report

Posted on by Anthony Des

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 (2)

Answers (1)

Verified answer

Anthony Des 43 on at

Like (1)

Report

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... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

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