Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 913802 - Last Review: May 15, 2008 - Revision: 6.1
Error message in Microsoft Dynamics CRM 3.0: "SQL Server timeout expired"
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=944373/
)
Update Rollup 2 for Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers is available
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=824684/
)
Description of the standard terminology that is used to describe Microsoft software updates
887283Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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.
APPLIES TO
- Microsoft CRM 3.0
- Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers
| kbmbsworkflow kberrmsg kbhotfixserver kbqfe kbmbsmigrate KB913802 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate