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