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