web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / <ErrorCode>-2147...
Microsoft Dynamics CRM (Archived)

<ErrorCode>-2147220970</ErrorCode> Unable to delete a field from entity as role from Admin

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I was getting this error when my supervisor try to delete a field from a custom entity. He has role a Admin & unable to delete. this field has No business rules, workflows, dependencies or relationships.  Not in any view or lookup.

Can anyone help me in this ? As from previous posts about error -2147220970 are dealing with asynchronous services but I need for confirmation or need to open ticket for MS Online support ?

Version - CRM 2016 On premise (8.2 +)

Error information follows below --

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #4BBB1FFADetail: 
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
  <ActivityId>216950fe-cc9f-4419-9ce2-bdf7c429b3a4</ActivityId>
  <ErrorCode>-2147220970</ErrorCode>
  <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic">
    <KeyValuePairOfstringanyType>
      <d2p1:key>CallStack</d2p1:key>
      <d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)</d2p1:value>
    </KeyValuePairOfstringanyType>
  </ErrorDetails>
  <Message>System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #4BBB1FFA</Message>
  <Timestamp>2017-11-27T19:59:15.6963931Z</Timestamp>
  <ExceptionRetriable>false</ExceptionRetriable>
  <ExceptionSource i:nil="true" />
  <InnerFault>
    <ActivityId>216950fe-cc9f-4419-9ce2-bdf7c429b3a4</ActivityId>
    <ErrorCode>-2147220970</ErrorCode>
    <ErrorDetails xmlns:d3p1="schemas.datacontract.org/.../System.Collections.Generic">
      <KeyValuePairOfstringanyType>
        <d3p1:key>CallStack</d3p1:key>
        <d3p1:value xmlns:d5p1="www.w3.org/.../XMLSchema" i:type="d5p1:string">   at Microsoft.Crm.Dialogs.DeleteDialogPage.ConfigureForm()
   at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</d3p1:value>
      </KeyValuePairOfstringanyType>
    </ErrorDetails>
    <Message>System.Web.Services.Protocols.SoapException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #5B050086</Message>
    <Timestamp>2017-11-27T19:59:15.6963931Z</Timestamp>
    <ExceptionRetriable>false</ExceptionRetriable>
    <ExceptionSource i:nil="true" />
    <InnerFault>
      <ActivityId>216950fe-cc9f-4419-9ce2-bdf7c429b3a4</ActivityId>
      <ErrorCode>-2147220970</ErrorCode>
      <ErrorDetails xmlns:d4p1="schemas.datacontract.org/.../System.Collections.Generic">
        <KeyValuePairOfstringanyType>
          <d4p1:key>CallStack</d4p1:key>
          <d4p1:value xmlns:d6p1="www.w3.org/.../XMLSchema" i:type="d6p1:string">   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
   at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
   at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.DropIndexOrConstraintInSqlIfExistsInternal(DropIndexData dropData, ISqlExecutionContext sqlContext)
   at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.DropIndexesFromSQLByIndexIds(List`1 indexIds, ISqlExecutionContext sqlContext)
   at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.DropAttributeFromAllIndexes(Guid attributeId, Boolean dropAndTrackCustomIndexes, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
   at Microsoft.Crm.Metadata.AttributeDeleteAction.PreprocessAttributeForSqlColumnDrop(Guid attributeId, ISqlExecutionContext sqlContext)
   at Microsoft.Crm.Metadata.AttributeDeleteAction.MetabaseOperation()
   at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue_metabaseActionsToExecute(CounterList listCounters)
   at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue()
   at Microsoft.Crm.Metadata.AttributeService.Delete(Guid attributeId, MetadataHelper metadataHelper, ExecutionContext context)
   at Microsoft.Crm.Metadata.AttributeService.Delete(Guid attributeId, ExecutionContext context)
   at Microsoft.Crm.Metadata.AttributeService.Delete(Guid attributeId, Guid solutionId)
   at Microsoft.Crm.Application.WebServices.SystemCustomization.AttributeDelete.Execute(Guid attributeId, Guid solutionId)
   at Microsoft.Crm.Application.WebServices.SystemCustomization.SystemCustomization.DeleteAttribute(Guid attributeId)</d4p1:value>
        </KeyValuePairOfstringanyType>
      </ErrorDetails>
      <Message>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #FFEF4D37</Message>
      <Timestamp>2017-11-27T19:59:15.6963931Z</Timestamp>
      <ExceptionRetriable>false</ExceptionRetriable>
      <ExceptionSource i:nil="true" />
      <InnerFault i:nil="true" />
      <OriginalException i:nil="true" />
      <TraceText i:nil="true" />
    </InnerFault>
    <OriginalException i:nil="true" />
    <TraceText i:nil="true" />
  </InnerFault>
  <OriginalException i:nil="true" />
  <TraceText i:nil="true" />
</OrganizationServiceFault>


Please let me know if you have any questions.

Thank you 

Deepthi Thotakura

*This post is locked for comments

I have the same question (0)
  • Syed Ibrahim Profile Picture
    Syed Ibrahim 6,257 on at

    Is it a custom entity or OOB entity

  • Community Member Profile Picture
    Community Member on at

    Its custom entity Syed

  • Suggested answer
    Syed Ibrahim Profile Picture
    Syed Ibrahim 6,257 on at

    Can you pls chk any plugin registered for this entity with that attribute.

  • Community Member Profile Picture
    Community Member on at

     First thing I checked about plugins but there is no plugin is written for this attribute & on this entity.

  • Suggested answer
    Syed Ibrahim Profile Picture
    Syed Ibrahim 6,257 on at

    If you couldn't locate any dependency via the interface (re-checked all views, forms, process, etc..), use a console app to remove the fields.

    Refer the below link to do it by code.

    social.microsoft.com/.../manipulating-forms-programmatically

  • Community Member Profile Picture
    Community Member on at

    Syed , Isn't its hard way to do so & I would like to know about cause of error?  Can you suggest for another method to test & resolve this problem ?

  • Suggested answer
    Aric Levin - MVP Profile Picture
    Aric Levin - MVP 30,190 Moderator on at

    HI Deepthi,

    Since you are running On-Prem, you can replicate this error while running SQL Profile, which would provide the details of the SQL Statement that is being executed to delete the field, and the response/failure from SQL Server.

    Once you are able to get that information, you might be able to pinpoint the reason why you are unable to delete this field.

  • Suggested answer
    Syed Ibrahim Profile Picture
    Syed Ibrahim 6,257 on at

    You can follow Mr.Erics's advise also to check the request failure at the DB side. If not able to to find any go for the console approach.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans