Skip to main content

Notifications

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) / Workflows erroring out
Microsoft Dynamics CRM (Archived)

Workflows erroring out

(0) ShareShare
ReportReport
Posted on by USA80 2

I am getting an error message in all of my workflows that says: "A SQL Server error occurred. Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization's Microsoft Dynamics CRM Administrator. Finally, you can contact Microsoft Support."

Workflow suspended temporarily due to error: Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
  <ErrorCode>-2147204784</ErrorCode>
  <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
  <Message>Generic SQL error.</Message>
  <Timestamp>2019-01-04T00:40:32.5503513Z</Timestamp>
  <InnerFault>
    <ErrorCode>-2147204784</ErrorCode>
    <ErrorDetails xmlns:d3p1="schemas.datacontract.org/.../System.Collections.Generic" />
    <Message>Generic SQL error.</Message>
    <Timestamp>2019-01-04T00:40:32.5503513Z</Timestamp>
    <InnerFault>
      <ErrorCode>-2147220970</ErrorCode>
      <ErrorDetails xmlns:d4p1="schemas.datacontract.org/.../System.Collections.Generic" />
      <Message>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #E64D34D7</Message>
      <Timestamp>2019-01-04T00:40:32.5503513Z</Timestamp>
      <InnerFault i:nil="true" />
      <TraceText i:nil="true" />
    </InnerFault>
    <TraceText i:nil="true" />
  </InnerFault>
  <TraceText>[Microsoft.Xrm.Sdk.Workflow: Microsoft.Xrm.Sdk.Workflow.Activities.SendEmail]
[SendEmailStep3]
</TraceText>
</OrganizationServiceFault>
   at Microsoft.Crm.Workflow.Services.SendEmailActivityService.Execute(ActivityContext executionContext, SendEmail sendEmail)
   at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
   at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

Any help is appreciated.  Thank you

*This post is locked for comments

  • Verified answer
    USA80 Profile Picture
    USA80 2 on at
    RE: Workflows erroring out

    I ended up restarting the server, that seemed to work for the most part.  At times I still get the error, but waiting a few minutes and retrying the workflow or whatever the user is trying to do seems to work again.

  • RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: Workflows erroring out

    Have you tried restarting async service?

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: Workflows erroring out

    You can use trace reader which will help you identify trace: archive.codeplex.com, you can look for red one specifically

  • Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,626 on at
    RE: Workflows erroring out

    Hi,

    share the log file in here

  • USA80 Profile Picture
    USA80 2 on at
    RE: Workflows erroring out

    What should I be looking for in the logs after I turn on trace?

  • USA80 Profile Picture
    USA80 2 on at
    RE: Workflows erroring out

    I have tried another browser, same issue.

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: Workflows erroring out

    Hi,

    This is a generic SQL error which can be related to different reasons, as you are using CRM on premise?, I will suggest you to enable tracing in your CRM server and SQL server and check for the log files, log files should give you some pointer what's wrong.

    This tool should help you to enable tracing :archive.codeplex.com

    You can also enable to manually : support.microsoft.com/.../how-to-enable-tracing-in-microsoft-dynamics-crm

  • Verified answer
    Priyesh Profile Picture
    Priyesh 7,396 User Group Leader on at
    RE: Workflows erroring out

    This happens on Microsoft's end. Can you check your service health in Office365 is you're the Global admin?

    Also, this should work fine in sometime.

    Just try another browser.

    This happens at times but gets resolved once some background processes which are stuck get through.

    Hope this helps.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,401 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans