Microsoft KB Archive/911480

= A workflow rule does not advance to the next step for a record in Microsoft Dynamics CRM =

Article ID: 911480

Article Last Modified on 8/21/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0

-



SYMPTOMS
Consider the following scenario in Microsoft Dynamics CRM:
 * You create a workflow rule that has a Wait for condition. For example, closing a case may be used as a Wait for condition.
 * You start the workflow rule. Then, you apply it to records in Microsoft Dynamics CRM.
 * You uninstall Microsoft Dynamics CRM.
 * You install Microsoft Dynamics CRM on a new server. The computer account name of this new server differs from the computer account name of the old server.
 * You open one of the records to which you applied the workflow rule. In this situation, you meet the Wait for condition.

In this scenario, the workflow rule does not advance to the next step for this record.



CAUSE
This problem occurs because the WFEventLog and WFProcessInstance tables for the workflow rule incorrectly list the computer account name of the old server. These tables are Microsoft SQL Server tables.



RESOLUTION
To resolve this problem, contact Microsoft Product Support Services. For a list of Microsoft Product Support Services telephone numbers and support options, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support



WORKAROUND
To work around this problem, you must manually update the WFEventLog and WFProcessInstance tables. To do this, follow these steps:  Start Microsoft SQL Query Analyzer. In the Database list, click  _MSCRM.

Note  is a placeholder for the actual name of the company.  Copy and then paste the following script. begin tran Update WFEventLog set MachineName =  where MachineName = 

Update WFProcessInstance set OwningMachine =  where OwningMachine =  commit tran Note  is a placeholder for the computer account name of the new server. is a placeholder for the computer account name of the old server.  Run the script.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: CRM30 CRM3.0

Keywords: kbtshoot kbmbsmigrate kbbug KB911480

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.