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:

image

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.

image

 

 

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
Workopia

Advertisements

About Microsoft Dynamics CRM Online

Microsoft Dynamics CRM and CRM Online specialist. Microsoft CRM MVP since 2006
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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s