Dynamics CRM Workflow: SQL Server Error Occured

April 20, 2012 11:32 pm
Andri Kasta Marengga

Dynamics CRM Workflow: SQL Server Error Occured

While testing my Dynamics CRM workflow development, the following error occurs:

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.

Dynamics CRM Workflow Error: SQL Server error occuredI think it was an uncommon error, i never found this error before.

To handle this error, first check your trace log which is usually located in “Program Files\Microsoft Dynamics CRM\Trace” folder, and check what error written while you received this error. Mine was “System.Data.SqlClient.SqlException: Transaction (Process ID XX) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.”

What I do after found this error was just clicking “Resume” button, and my workflow resume its job again without any problem.

After having some googling I found that this error has been fixed in the Update Rollup for Microsoft Dynamics CRM, so don’t be hesitate to patch your Dynamics CRM to the latest rollup.

, , , ,

One Response to “Dynamics CRM Workflow: SQL Server Error Occured”

  1. Take your time June 10, 2013 at 9:04 pm #

    I do believe all of the ideas you’ve introduced to your post. They are really convincing and will definitely work. Nonetheless, the posts are too quick for newbies. Could you please lengthen them a bit from subsequent time? Thanks for the post.

Leave a Reply