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

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 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 )

Connecting to %s