web
You’re offline. This is a read only version of the page.
close
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) / SQL Server Error in Wo...
Microsoft Dynamics CRM (Archived)

SQL Server Error in Workflow

(0) ShareShare
ReportReport
Posted on by Jesse Dickert 35

Hello -

 

We are having issues with our workflows.  A bunch of the workflows we have setup in Dynamics CRM 4.0 are sitting in a Waiting Status with the following error:

 

"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."

 

I have search different solutions to this issue and it does not seem like anything is helping.  

Please let me know if anyone can offer any support or if more information is needed.

 

Thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Lance Squires Profile Picture
    Lance Squires on at

    Hi Jesse,

    Is this issue still occurring for you? The error message you are referencing can be caused by a number of issues. I would recommend taking a look at the logic of the workflow and see if it can be streamlined first. If it is not the logic of the workflow, then the issue more than likely resides with SQL performance. My best recommendation for you would to be to take a look at the CRM Performance Papers as they contain a good deal of SQL Performance tips.

    (CRM 4.0) www.microsoft.com/.../details.aspx

    (CRM 2011) www.microsoft.com/.../details.aspx

    If in the end the issue is still occurring, I would recommend that you reach out to a Microsoft Partner for guidance. If you are a Microsoft Partner, I would then recommend that you open a support request or pursue a professional service request through us.

    Thanks,

    Lance Squires

    Support Engineer

    Microsoft Dynamics CRM Support

  • Suggested answer
    Adam Surgenor Profile Picture
    Adam Surgenor 425 on at

    A typically helpful CRM error message!

    it might be an idea to fire up SQL Server Profiler, with the tuning settings.  It will give you more information, rather than a precise answer.  It may at least give you an idea of which part of the workflow is causing the problem.

    I guess the alternative would be to insert the odd "stop workflow" statement to try and locate the problem statement, and then follow the tuning guidelines.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans