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.

<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

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

• 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