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
Workopia