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

Article translations Article translations
Article ID: 913802 - View products that this article applies to.
Expand all | Collapse all

On This Page

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:
Optimizing the Performance of Microsoft Dynamics CRM 3.0 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: May 15, 2008 - Revision: 6.1
APPLIES TO
  • Microsoft CRM 3.0
  • Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers
Keywords: 
kbmbsworkflow kberrmsg kbhotfixserver kbqfe kbmbsmigrate KB913802

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com