Microsoft Dynamics CRM workflows are amazing and versatile tools. Workflows let organizations automate daily tasks within Dynamics CRM – saving users time and ensuring accuracy. CRM workflows consist of a series of steps and rules that serve to automate a business process. In today’s blog, we will explore workflows in more detail and show you how to increase the maximum number of nested child workflows allowed in CRM!
If you have ever needed to call a chain of workflows, you may have run into the following error:
This workflow job was canceled because the workflow that started it would include an infinite loop. Correct the workflow logic and try again. For information about workflow logic, see Help.
The error is triggered because, by default, CRM only allows for up to eight nested child workflows. When you attempt to run more, CRM will recognize it as an infinite loop. Even though you typically want to avoid a scenario where you would be calling more than eight child workflows, you may sometimes need to. So what do you do then?
If you have an on-premises CRM solution and have access to the SQL database, you can increase the maximum limit. While this is unsupported, the setting is generally safe to do as long as you are accurate when you are typing the change into the database.
To increase the limits, follow the steps below:
1. Locate the setting in the MSCRM_CONFIG database in the table deploymentproperties.
2. Find the columnname called MessageProcessorMaximumDepth.
3. Update the value in that column.
4. After updating the value, complete an IS reset on the CRM application server.
That’s all it takes! Make sure you check out The CRM Book if you’d like to learn more about CRM. The CRM Book is a comprehensive, online guide to working with Microsoft Dynamics CRM. No matter what your background or experience level is, The CRM Book has something for everyone! You can learn more about workflows and so much more!