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