Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 893043 - Last Review: September 8, 2006 - Revision: 2.2
A delay occurs when you close an activity and then immediately try to open other records in Microsoft CRM 1.2
A delay occurs when you close an activity and then immediately try to open other records in Microsoft CRM 1.2.
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.
- Click Start, click Programs, click Microsoft SQL Server, and then click Enterprise Manager.
- Expand the following nodes:
- Microsoft SQL Servers
- SQL Server Group
- YourSQLServerName
- Expand the following nodes under your server:
- Management
- Current Activity
- Locks / Process ID
- YourSQLServerName
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://kbalertz.com/Feedback.aspx?kbNumber=904435/
)
Update Rollup 2 is available for Microsoft CRM 1.2
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Steps to reproduce the problem
- Start Microsoft CRM.
- Click Workplace, point to Activities, point to New Activity, and then click Appointment.
- Complete all required fields for the appointment.
- Click Lookup next to Attendees.
- Click Account in the Type list, and then click Go.
- Click an account in the Available records list, and then click the arrow to move that account to the Selected records list.
- Click User in the Type list, and then click Go.
- Click a user in the Available records list, click the arrow to move that user to the Selected records list, and then click OK.
- To save the appointment, click Save.
- On the Actions menu, click Add a Note.
- Type a title for the note, and then click Save and Close.
- On the Action menu, click Close Appointment.
- Click Completed in the Status list, and then click OK.
- 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.
APPLIES TO
- Microsoft Business Solutions CRM Sales for Outlook, when used with:
- Microsoft CRM 1.2
| kbqfe kbprb kbmbsmigrate kbhotfixserver KB893043 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate