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

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

Hotfix information

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem.

To resolve this problem immediately, contact Microsoft Business Solutions Technical Support to obtain the hotfix. You can log on to the Microsoft Business Solutions Support site and create a new support request. To do this, visit the following Microsoft Web site:

https://mbs.microsoft.com/support/newstart.aspx

You can also contact Microsoft Business Solutions Technical Support by telephone at (888) 477-7877.

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Business Solutions Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.

Installation information

Install this hotfix on computers that are running Microsoft Dynamics CRM 3.0 Server.

Prerequisites

You must have Microsoft Dynamics CRM 3.0 installed to apply this hotfix.

Restart requirement

If you are prompted, restart the computer after you install this hotfix.

Removal information

To remove this hotfix from a computer that is running Microsoft Dynamics CRM 3.0, use Add or Remove Programs in Control Panel.

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

File name	File version	File size	Date	Time	Platform
Crmworkflowservice.exe	3.0.5300.1154	3,878,736	June 2, 2006	00:41	x86

MORE INFORMATION

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:

Click Start, point to All Programs, point to Microsoft CRM, and then click Workflow Monitor.
Change the view to Running.
Change the value in the Type field to Order.
Open any running rule that has the name of the workflow rule that updates a Boolean field after assigning a sales order.
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.