Error message in Microsoft Dynamics CRM 3.0: "SQL Server timeout expired"

This article has been archived. It is offered "as is" and will no longer be updated.
Symptoms
In Microsoft Dynamics CRM 3.0, you receive the following error message:
SQL Server timeout expired. For more information, contact your system administrator.
This problem may occur in either of the following scenarios.

Scenario 1

You apply a manual workflow rule to a sales order that has associated products. Then, the manual workflow rule updates the sales order.

Scenario 2

You use order workflow rules. The order workflow rules update a Boolean field when a sales order is assigned to another user.
Resolution

Microsoft Dynamics CRM 3.0

This problem is fixed in Microsoft Dynamics CRM 3.0 Update Rollup 1. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
922815 Update Rollup 1 for Microsoft Dynamics CRM 3.0 is available

Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers

This problem is fixed in Update Rollup 2 for Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
944373 Update Rollup 2 for Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers is available
More information
For information about performance tuning for CRM 3.0, see the following white paper:
For more information about the terminology that is used to describe Microsoft software updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards
The error message that is discussed in the "Symptoms" section can be viewed in the Microsoft CRM Workflow Monitor for the order rules. To view the error message, follow these steps on the Microsoft Dynamics CRM server:
  1. Click Start, point to All Programs, point to Microsoft CRM, and then click Workflow Monitor.
  2. Change the view to Running.
  3. Change the value in the Type field to Order.
  4. Open any running rule that has the name of the workflow rule that updates a Boolean field after assigning a sales order.
  5. View the Status field and the Description field. The Status field displays "failed." The Description field displays the following message:
    Error Code= 80044151.SQL Server error. SQL Server Timeout expired. For more information, contact your system administrator.
Properties

Article ID: 913802 - Last Review: 01/16/2015 01:46:30 - Revision: 7.0

  • Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers
  • kbnosurvey kbarchive kbmbsworkflow kberrmsg kbHotfixServer kbqfe kbmbsmigrate KB913802
Feedback