Microsoft KB Archive/885754

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

Article ID: 885754

Article Last Modified on 9/8/2006

-

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

Keywords: kbmbsmigrate kbqfe kbhotfixserver KB885754

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.