Microsoft KB Archive/893043

= A delay occurs when you close an activity and then immediately try to open other records in Microsoft CRM 1.2 =

Article ID: 893043

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
A delay occurs when you close an activity and then immediately try to open other records in Microsoft CRM 1.2.



CAUSE
This delay can occur because of a Microsoft SQL Server lock on Microsoft CRM tables. When the Microsoft CRM tables are in a locked state, other Microsoft CRM users may not be able to open activities or other records.

To confirm that Microsoft SQL Server is locking the tables, you can use SQL Server Enterprise Manager to monitor the lock.
 * 1) Click Start, click Programs, click Microsoft SQL Server, and then click Enterprise Manager.
 * 2) Expand the following nodes:
 * 3) * Microsoft SQL Servers
 * 4) * SQL Server Group
 * 5) Expand the following nodes under your server:
 * 6) * Management
 * 7) * Current Activity
 * 8) * Locks / Process ID
 * 1) * Locks / Process ID



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



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



Steps to reproduce the problem

 * 1) Start Microsoft CRM.
 * 2) Click Workplace, point to Activities, point to New Activity, and then click Appointment.
 * 3) Complete all required fields for the appointment.
 * 4) Click Lookup next to Attendees.
 * 5) Click Account in the Type list, and then click Go.
 * 6) Click an account in the Available records list, and then click the arrow to move that account to the Selected records list.
 * 7) Click User in the Type list, and then click Go.
 * 8) Click a user in the Available records list, click the arrow to move that user to the Selected records list, and then click OK.
 * 9) To save the appointment, click Save.
 * 10) On the Actions menu, click Add a Note.
 * 11) Type a title for the note, and then click Save and Close.
 * 12) On the Action menu, click Close Appointment.
 * 13) Click Completed in the Status list, and then click OK.
 * 14) Immediately after you click OK, open another record that you own.

Note You may have to open multiple records for the SQL Server locking to occur.

Additional query words: SQL blocking

Keywords: kbqfe kbprb kbmbsmigrate kbhotfixserver KB893043

-

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

© Microsoft Corporation. All rights reserved.