SYMPTOMS

The Microsoft CRM 1.2 Sales for Outlook client or Web client may become unresponsive during Advanced Find searches.

CAUSE

When an Advanced Find is executed by using the Microsoft CRM 1.2 Sales for Outlook client or Web client, all columns in the database table are returned for the entity that you are querying on. You expect that Advanced Find will return only those columns that are relevant to the Advance Find results grid. This behavior may cause Microsoft SQL Server blocking and may cause the application to become unresponsive.

While this query is being executed, all other selects, updates, and deletes for the queried table are blocked. Microsoft CRM must wait for the original query to finish running before any other changes to the table can be completed.

RESOLUTION

Microsoft CRM has a fix for this problem that is part of a cumulative update. 

MORE INFORMATION

You can contact a Microsoft CRM support professional directly at 877-752-1122

For Additional Information, please see:

http://mscrm.exiis.net/microsoft-crm-consulting/Pages/default.aspx