POWEROBJECTS

718 Washington Ave. N. Suite #101
Minneapolis, MN 55401
View map and all Locations

Send us a message

As you learn about Workflows in Microsoft Dynamics CRM , you may encounter an issue where you find a workflow stuck in “In Progress”. You can see an example of this below. Sometimes these workflows might get processed after a long delay.
workflow stuck in "in progress"

troubleshooting

Today we’ll go over how to resolve this issue in an on-premise instance of Microsoft Dynamics CRM. The issue might be related to a missing or wrong value in the MSCRM_CONFIG database.

  1. To find out, run the following SQL query and AsyncSdkRootDomain value should be same as the remaining two.

    Select ColumnName, NVarCharColumn
    from
    [MSCRM_CONFIG].[dbo].DeploymentProperties
    where
    ColumnName=‘ADSdkRootDomain’
    or
    ColumnName=‘ADWebApplicationRootDomain’
    or
    ColumnName=‘AsyncSdkRootDomain’;

  2. If they don’t have the same values, then update AsyncSdkRootDomain value using the following statement. In this ‘<servername>’, should be same value as ADSdkRootDomainresult.update [MSCRM_CONFIG].[dbo].[DeploymentProperties]
    set
    NVarCharColumn=‘<servername>’
    where
    ColumnName=‘AsyncSdkRootDomain’
  3. WARNING: Always backup your databases if you are updating data in SQL directly.

  4. Restart CRM Async Service and the workflows should start working again.

If this doesn’t resolve your issue, consider opening a request with PowerObjects for support.

Happy CRM’ing!

Avatar for JoeCRM

JoeCRM

Joe CRM is a CRM superhero who runs on pure Microsoft Dynamics CRM adrenaline. As the face of PowerObjects, Joe CRM’s mission is to reveal innovative ways to use Dynamics CRM and bring the application to more businesses and organizations around the world.