locked
Microsoft CRM SQL error time out RRS feed

  • Question

  • We are facing two errors after upgrading our server config from 2 CRM servers (App and DB) to 3 CRM (App, Async+ mail router, DB) servers. We have not modified any workflows or plugins. Our workflows did not time out before the server changes and now they are not firing or mostly erroring and causing lot of our backoffice processes to halt. Please can you suggest what we can do?

    1. Sync Record error

    Plugin Trace:

    [Microsoft.Xrm.Sdk.Workflow: Microsoft.Xrm.Sdk.Workflow.Activities.UpdateEntity]

    [UpdateStep1]

    Error Message:

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #50F933A2Detail:

    <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">

      <ErrorCode>-2147220970</ErrorCode>

      <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />

      <Message>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #50F933A2</Message>

      <Timestamp>2017-08-09T15:43:48.0189671Z</Timestamp>

      <InnerFault i:nil="true" />

      <TraceText>[Microsoft.Xrm.Sdk.Workflow: Microsoft.Xrm.Sdk.Workflow.Activities.UpdateEntity]

    [UpdateStep1]

    </TraceText>

    </OrganizationServiceFault>

       at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.Update(Entity entity, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType)

       at Microsoft.Crm.Extensibility.InprocessServiceProxy.UpdateCore(Entity entity)

       at Microsoft.Crm.Workflow.Services.UpdateActivityService.<>c__DisplayClass1.<UpdateInternal>b__0(IOrganizationService sdkService)

       at Microsoft.Crm.Workflow.Services.ActivityServiceBase.ExecuteInTransactedContext(ActivityDelegate activityDelegate)

       at Microsoft.Crm.Workflow.Services.UpdateActivityService.UpdateInternal(Entity entity, String stepId)

       at Microsoft.Crm.Workflow.Services.UpdateActivityService.ExecuteInternal(ActivityContext executionContext, UpdateEntity updateEntity)

       at Microsoft.Crm.Workflow.Services.UpdateActivityService.Execute(ActivityContext executionContext, UpdateEntity updateEntity)

       at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)

       at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

    2. Work flow error

    Workflow suspended temporarily due to error: Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail: <o:p></o:p>

    <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts"><o:p></o:p>

      <ErrorCode>-2147204784</ErrorCode><o:p></o:p>

      <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" /><o:p></o:p>

      <Message>Generic SQL error.</Message><o:p></o:p>

      <Timestamp>2017-08-03T11:42:33.2080561Z</Timestamp><o:p></o:p>

      <InnerFault><o:p></o:p>

        <ErrorCode>-2147204784</ErrorCode><o:p></o:p>

        <ErrorDetails xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" /><o:p></o:p>

        <Message>Generic SQL error.</Message><o:p></o:p>

        <Timestamp>2017-08-03T11:42:33.2080561Z</Timestamp><o:p></o:p>

        <InnerFault><o:p></o:p>

          <ErrorCode>-2147220970</ErrorCode><o:p></o:p>

          <ErrorDetails xmlns:d4p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" /><o:p></o:p>

          <Message>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #3DDA0354</Message><o:p></o:p>

          <Timestamp>2017-08-03T11:42:33.2080561Z</Timestamp><o:p></o:p>

          <InnerFault i:nil="true" /><o:p></o:p>

          <TraceText i:nil="true" /><o:p></o:p>

        </InnerFault><o:p></o:p>

        <TraceText i:nil="true" /><o:p></o:p>

      </InnerFault><o:p></o:p>

      <TraceText>[Microsoft.Xrm.Sdk.Workflow: Microsoft.Xrm.Sdk.Workflow.Activities.UpdateEntity]<o:p></o:p>

    [UpdateStep1]<o:p></o:p>

    <o:p> </o:p>

                    [MC.Plugins: MC.Plugins.Registration_UpdateContactType]<o:p></o:p>

                    [094a00ee-d69e-e611-8df6-005056be6269: MC.Plugins.Registration_UpdateContactType: Update of mc_registration]<o:p></o:p>

                    Starting RegistrationUpdateContactType plug-in execution<o:p></o:p>

                    Retrieving registration image.<o:p></o:p>

                    Retrieving student information.<o:p></o:p>

                    Retrieved contact type (ES/IR)</TraceText><o:p></o:p>

    </OrganizationServiceFault><o:p></o:p>

       at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.Update(Entity entity, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType)<o:p></o:p>

       at Microsoft.Crm.Extensibility.InprocessServiceProxy.UpdateCore(Entity entity)<o:p></o:p>

       at Microsoft.Crm.Workflow.Services.UpdateActivityService.<>c__DisplayClass1.<UpdateInternal>b__0(IOrganizationService sdkService)<o:p></o:p>

       at Microsoft.Crm.Workflow.Services.ActivityServiceBase.ExecuteInTransactedContext(ActivityDelegate activityDelegate)<o:p></o:p>

       at Microsoft.Crm.Workflow.Services.UpdateActivityService.UpdateInternal(Entity entity, String stepId)<o:p></o:p>

       at Microsoft.Crm.Workflow.Services.UpdateActivityService.ExecuteInternal(ActivityContext executionContext, UpdateEntity updateEntity)<o:p></o:p>

       at Microsoft.Crm.Workflow.Services.UpdateActivityService.Execute(ActivityContext executionContext, UpdateEntity updateEntity)<o:p></o:p>

       at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)<o:p></o:p>

       at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)<o:p></o:p>


    • Edited by NaveenCR Wednesday, August 9, 2017 4:16 PM Need to modify desciption
    Wednesday, August 9, 2017 4:13 PM