Microsoft KB Archive/913802

= Error message in Microsoft Dynamics CRM 3.0: &quot;SQL Server timeout expired&quot; =

Article ID: 913802

Article Last Modified on 8/14/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0
 * Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers

-



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.



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 is available for Microsoft Dynamics CRM 3.0



Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers hotfix information
A supported hotfix is now available from Microsoft. However, it is intended to correct only the problem that is described in this article. Apply it only to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next update that contains this hotfix.

To resolve this problem immediately, contact Microsoft Customer Support Services to obtain the hotfix. For a complete list of Microsoft Customer Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

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

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

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.

Microsoft Dynamics CRM server


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 &quot;Symptoms&quot; 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 &quot;failed.&quot; The Description field displays the following message:

Error Code= 80044151.SQL Server error. SQL Server Timeout expired. For more information, contact your system administrator.

</ol>

Keywords: kbmbsworkflow kberrmsg kbhotfixserver kbqfe kbmbsmigrate kbpubtypekc KB913802

-

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

© Microsoft Corporation. All rights reserved.