web
You’re offline. This is a read only version of the page.
close
Skip to main content
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

  • Syed Ibrahim Profile Picture
    Syed Ibrahim on at
    RE: <ErrorCode>-2147220970</ErrorCode> Unable to delete a field from entity as role from Admin

    Is it a custom entity or OOB entity

  • Community Member Profile Picture
    Community Member on at
    RE: <ErrorCode>-2147220970</ErrorCode> Unable to delete a field from entity as role from Admin

    Its custom entity Syed

  • Suggested answer
    Syed Ibrahim Profile Picture
    Syed Ibrahim on at
    RE: <ErrorCode>-2147220970</ErrorCode> Unable to delete a field from entity as role from Admin

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

  • Community Member Profile Picture
    Community Member on at
    RE: <ErrorCode>-2147220970</ErrorCode> Unable to delete a field from entity as role from Admin

     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 on at
    RE: <ErrorCode>-2147220970</ErrorCode> Unable to delete a field from entity as role from Admin

    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
    RE: <ErrorCode>-2147220970</ErrorCode> Unable to delete a field from entity as role from Admin

    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 on at
    RE: <ErrorCode>-2147220970</ErrorCode> Unable to delete a field from entity as role from Admin

    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 on at
    RE: <ErrorCode>-2147220970</ErrorCode> Unable to delete a field from entity as role from Admin

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans