MS CRM Cascade ActiveOnly is not a valid cascade link type for relationships where the referencing entity has no statecode attribute

This week, while working on a CRM 2011 design for a Client in the Bioinformatics industry – I had encountered this error while trying to update the Account to Note Relationship Behavior for Assign to “Cascade Active” setting:


The interesting thing was this same setup didn’t generate an error in MS CRM 4.0.

Cause:  Upon more investigation – the issue was due to the fact that Cascade ActiveOnly is not a valid cascade link type for relationships where the referencing entity has no statecode attribute.

The Microsoft CRM Note (Annotation) object doesn’t have a statecode attribute – which appropriately triggered this error message.

Resolution: Use any of the other Cascade values instead: Cascade All, Cascade User Owned or Cascade None

Note: this will impact any solution import from an upgraded MS CRM 4.0 to 2011 where this value was set since MS CRM 4.0 allowed it without an error message.  To clean this up – navigate to the upgraded CRM 2011 environment and review the Note entity’s N:1 Relationships and update any Relationship Behavior for Assign with an “ActiveOnly” value.




Contact me if you need help with your Microsoft CRM. Free Estimate.

FREE Microsoft CRM Online 30 Day Trial access with our Professional Assistance!

Frank Lee, Microsoft CRM MVP since 2006

About Frank Lee

Microsoft Dynamics 365 CRM/xRM consultant in San Francisco, USA.  Awarded the Microsoft MVP (Dynamics 365/CRM) 12 consecutive years from 2006 to 2018. Actively involved with Microsoft Dynamics CRM implementations since Microsoft CRM v1.0 beta (2002). Super passionate about everything CRM, especially in the areas of Cloud Computing, A.I., Digital Transformation and Automation.
This entry was posted in CRM 2011, Customization, Microsoft CRM, Microsoft Dynamics CRM, Upgrade and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s