Time-out errors occur when the Microsoft Dynamics CRM 4.0 E-mail Router runs Microsoft SQL Server queries

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

SYMPTOMS

When the Microsoft Dynamics CRM 4.0 E-mail Router runs Microsoft SQL Server queries, time-out errors are generated. 

CAUSE

This problem occurs when Microsoft Dynamics CRM 4.0 E-mail Router uses inefficient Microsoft SQL Server queries to retrieve email messages.This problem occurs if Microsoft Dynamics CRM 4.0 contains lots of records for the Activity entity and for the Email entity.

RESOLUTION

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
949256 Microsoft Dynamics CRM 4.0 updates and hotfixes
Note This problem was originally fixed in Update Rollup 13 for Microsoft Dynamics CRM 4.0.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2267499 Update Rollup 13 for Microsoft Dynamics CRM 4.0 is available
To enable this hotfix on the computer that is running Microsoft Dynamics CRM 4.0, follow these steps:  
  1. Under the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM registry subkey on the Microsoft Dynamics CRM server, add the following REG_DWORD registry entry:
    SmartMatchingForceOrder
  2. Set the value of the registry entry that you just added to 1.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
For more information about Microsoft Business Solutions CRM software hotfix and update package terminology, click the following article number to view the article in the Microsoft Knowledge Base:
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Properties

Article ID: 2403296 - Last Review: October 28, 2010 - Revision: 4.0
APPLIES TO
  • Microsoft Dynamics CRM 4.0, when used with:
    • Microsoft Dynamics CRM E-mail Router
Keywords: 
kbqfe kbfix kbexpertiseinter kbmbsmigrate kbsurveynew KB2403296

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