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

View products that this article applies to.

Expand all | Collapse all

SYMPTOMS

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

Back to the top

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.

Back to the top

RESOLUTION

Microsoft CRM has a fix for this problem that is part of a cumulative update. The cumulative update information is described in the following Microsoft Knowledge Base article:

904435 (http://support.microsoft.com/kb/904435/ ) Update Rollup 2 is available for Microsoft CRM 1.2

Back to the top