Wednesday, March 2, 2011

Crm 4.0 Workflows Not Running Resolution

First, verify that the Microsoft CRM Asynchronous Processing Service is running. If not start it and workflows should work now.

If it is running, verify that the following query returns the correct server name (from the MSCRM_Config database).

SELECT ColumnName, NVarCharColumn FROM DeploymentProperties WHERE ColumnName in ('ADSdkRootDomain', 'ADWebApplicationRootDomain', 'AsyncSdkRootDomain')

If any are incorrect run the update to set the correct server name in the NVarCharColumn using the ColumnName as the WHERE parameter like so:

UPDATE DeploymentProperties SET NVarCharColumn = 'crmservername' WHERE ColumnName = 'ADSdkRootDomain'

Once you update, restart the Asynch service and IIS.

No comments:

Post a Comment