Cannot change relationship behavior from Referential to Configurable Cascading

(0) Share

Report

Posted on by KrishnaReddy95

Hi All,

We have one custom entity to that entity we have 1:N relationship to Opportunity (custom entity - Opportunity) , by default the relationship behavior is Referential. When i try to change the relationship behavior from Referential to Configurable Cascading getting below error.

Error Message: The related entity has already been configured with a cascading or parental relationship.

I have cross checked the error message on this two entities but there is no relationship exist either with cascading or parental. Any leads on resolving this issue. Please post here.

Thanks,

Krishna Reddy Yeruva

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Nya 29,060 on at

Like (0)

Report

Hi,

There is a message in the error log saying that “Opportunity is parented to Entity with id: ……”.

The “parented” here means one in which anything cascades, not just the parental type relationship.

Here is a documentation on cascading behavior which you can refer to know more about how the actions of the entities governed by this relationship interact with each other:

https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/gg309412(v=crm.8)?redirectedfrom=MSDN#cascading-behavior

Opportunity has this relationship with two entities by default – Contact and Account.

Also, you can find a Note which says that:

A custom entity cannot be the primary entity in a relationship with a related system entity that cascades.

in the following documentation.

https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/administering-dynamics-365/dn531171(v=crm.8)#create-or-edit-1n-relationships-between-entities

So "Referential: restrict delete" is the best option for you.

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Nya

Was this reply helpful? Yes No