How to Resolve SQL Server Error on a Microsoft CRM 2015 Rollup field Delete


I had encountered the following SQL Server Error when trying to delete a Microsoft Dynamics CRM 2015 rollup field.  This is deleting the actual rollup field from the entity and not simply removing the field from a form or view – also it is cleared of any dependency.image

<ErrorCode>-2147220970</ErrorCode>
<ErrorDetails xmlns:d2p1=”http://schemas.datacontract.org/2004/07/System.Collections.Generic” />
<Message>System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #DFcA6B5C</Message>
<Timestamp>2016-04-280T18:23:59.7377283Z</Timestamp>
<InnerFault>
  <ErrorCode>-2147220970</ErrorCode>

 

How to Resolve:

  • Open the rollup field definition

image

  • Change the Rollup Field’s Aggregation field to another field

image

  • Save and Close
  • Delete
    Note: After the Delete is done – the Field definition still display.  OK to close it and if you refresh the list of fields – this rollup field is deleted

 

 

Contact me if you need help with your Microsoft Dynamics CRM.

Frank Lee, Microsoft Dynamics CRM MVP since 2006
Workopia, Inc. – Microsoft Dynamics CRM Specialist, San Francisco

Advertisements

About Microsoft Dynamics CRM Online

Microsoft Dynamics CRM and CRM Online specialist. Microsoft CRM MVP since 2006
This entry was posted in CRM 2015, CRM On Premise, Customization, Microsoft CRM, Microsoft Dynamics CRM, MS CRM, Troubleshooting 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