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


The information in this article applies to:

  • Microsoft Business Solutions CRM Sales for Outlook, when used with:
    • Microsoft CRM 1.2
  • Microsoft CRM 1.2

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. The cumulative update information is described in the following Microsoft Knowledge Base article:

904435 Update Rollup 2 is available for Microsoft CRM 1.2

Modification Type:MinorLast Reviewed:9/8/2006
Keywords:kbMBSMigrate kbQFE kbHotfixServer KB885754
©2004 Microsoft Corporation. All rights reserved.