Microsoft KB Archive/940496

From BetaArchive Wiki

Article ID: 940496

Article Last Modified on 1/4/2008



APPLIES TO

  • Microsoft Dynamics CRM 3.0



The hotfix that is discussed in this article is not available for the Chinese version of Microsoft Dynamics CRM or for the Japanese version of Microsoft Dynamics CRM.

SYMPTOMS

When you try to view activities in Microsoft Dynamics CRM 3.0, you receive the following error message:

SQL Server Error
A SQL Server error occurred. For more information, contact your system administrator.

This problem occurs if the following conditions are true:

  • Many users are creating appointments.
  • The appointments contain many parties.
  • Other users try to view activities.

When this problem occurs, the following users receive the error message:

  • The users who create the appointments.
  • The users who view activities.


RESOLUTION

A supported hotfix is now available from Microsoft. However, this hotfix is intended to correct only the problem that this article describes. Apply this hotfix only to systems that are experiencing this specific problem.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

Microsoft Dynamics CRM 3.0 server

File name File version File size Date Time Platform
Setup.exe 3.0.5300.1630 474,984 13-Nov-2007 17:54 x86
Articleseditcontent.xsl Not applicable 5,527 17-Aug-2007 22:06 Not applicable
Crmbulkmailservice.exe 3.0.5300.1726 2,832,400 14-Dec-2007 00:12 x86
Crmmsg.dll 1.2.3297.123 16,088 13-Nov-2007 17:54 x86
Crmnativeinteropproxy.dll 3.0.5300.1726 3,402,256 13-Dec-2007 08:16 x86
Crmobjectmodel.dll 3.0.5300.1726 6,740,496 14-Dec-2007 00:16 x86
Crmsecurity.dll 3.0.5300.1726 770,576 14-Dec-2007 00:18 x86
Crmworkflowservice.exe 3.0.5300.1726 3,888,144 14-Dec-2007 00:12 x86
Edit_article.aspx Not applicable 6,927 16-Nov-2007 21:15 Not applicable
Grid.htc Not applicable 17,560 10-Dec-2007 21:05 Not applicable
Kbtemplateeditor.js Not applicable 5,666 10-Dec-2007 21:05 Not applicable
Listaction.js Not applicable 9,102 10-Dec-2007 21:05 Not applicable
Microsoft.crm.application.components.application.dll 3.0.5300.1726 689,168 14-Dec-2007 00:01 x86
Microsoft.crm.application.components.core.dll 3.0.5300.1726 291,856 14-Dec-2007 00:02 x86
Microsoft.crm.application.components.platform.dll 3.0.5300.1726 369,680 14-Dec-2007 00:02 x86
Microsoft.crm.application.components.strings.dll 3.0.5300.1726 726,032 14-Dec-2007 00:02 x86
Microsoft.crm.application.components.ui.dll 3.0.5300.1726 222,224 14-Dec-2007 00:00 x86
Microsoft.crm.application.pages.dll 3.0.5300.1726 967,696 13-Dec-2007 08:01 x86
Microsoft.crm.dll 3.0.5300.1726 381,968 14-Dec-2007 00:02 x86
Microsoft.crm.managedinterop.dll 3.0.5300.1726 82,960 14-Dec-2007 00:02 x86
Microsoft.crm.metadatahelper.dll 3.0.5300.1726 82,960 14-Dec-2007 00:02 x86
Microsoft.crm.objectmodel.dll 3.0.5300.1726 324,624 14-Dec-2007 00:02 x86
Microsoft.crm.platform.bulkoperationcontrolassembly.dll 3.0.5300.1726 37,904 13-Dec-2007 23:58 x86
Microsoft.crm.platform.server.dll 3.0.5300.1726 246,800 14-Dec-2007 00:02 x86
Microsoft.crm.reports.reportschedule.dll 3.0.5300.1726 99,344 13-Dec-2007 23:58 x86
Microsoft.crm.tools.workflowlibrary.dll 3.0.5300.1726 275,472 13-Dec-2007 23:58 x86
Mscrmcustom.dll 3.0.5300.1656 181,096 13-Nov-2007 17:54 x86
Msvcr71.dll 7.10.3052.4 355,032 13-Nov-2007 17:54 x86
Pkgutil.cmd Not applicable 113 13-Nov-2007 01:54 Not applicable
Pkgutil.exe 1.2.3297.101 88,792 13-Nov-2007 17:54 x86
Print_dlg.aspx Not applicable 8,822 13-Dec-2007 21:02 Not applicable
Crmsecurity.dll 3.0.5300.1726 770,576 14-Dec-2007 00:18 x86
Microsoft.crm.dll 3.0.5300.1 375,560 17-Nov-2005 04:39 x86
Microsoft.crm.managedinterop.dll 3.0.5300.1 80,648 17-Nov-2005 04:38 x86
Microsoft.crm.metadatahelper.dll 3.0.5300.1 80,648 17-Nov-2005 04:38 x86
Microsoft.crm.objectmodel.dll 3.0.5300.1 318,216 17-Nov-2005 04:39 x86
Microsoft.crm.platform.server.dll 3.0.5300.1 244,488 17-Nov-2005 04:39 x86
Crmdbhotfix.dll 3.0.5300.1656 105,832 13-Nov-2007 17:54 x86
Crmhotfix.cdf Not applicable 14,366 14-Dec-2007 01:12 Not applicable
Kb927207_client.dll 3.0.5300.1726 61,456 14-Dec-2007 00:08 x86
Kb930604_client.dll 3.0.5300.1726 65,040 13-Dec-2007 08:08 x86
Kb930610_client.dll 3.0.5300.1726 116,752 13-Dec-2007 08:08 x86
Kb931627_client.dll 3.0.5300.1726 159,760 14-Dec-2007 00:08 x86
Kb932205_client.dll 3.0.5300.1726 63,504 14-Dec-2007 00:08 x86
Kb933214_client.dll 3.0.5300.1726 70,672 14-Dec-2007 00:08 x86
Kb933423_client.dll 3.0.5300.1726 91,152 14-Dec-2007 00:08 x86
Kb933658_client.dll 3.0.5300.1726 67,088 14-Dec-2007 00:08 x86
Kb935529_client.dll 3.0.5300.1726 71,184 14-Dec-2007 00:08 x86
Kb935844_client.dll 3.0.5300.1726 115,728 14-Dec-2007 00:08 x86
Kb936019_client.dll 3.0.5300.1726 61,968 14-Dec-2007 00:08 x86
Kb936204_client.dll 3.0.5300.1726 92,176 14-Dec-2007 00:08 x86
Kb938125_client.dll 3.0.5300.1726 61,968 14-Dec-2007 00:08 x86
Kb938238_client.dll 3.0.5300.1726 70,160 14-Dec-2007 00:08 x86
Kb940496_client.dll 3.0.5300.1726 71,696 14-Dec-2007 00:08 x86
Kb940761_client.dll 3.0.5300.1726 81,936 14-Dec-2007 00:08 x86
Mscrmcustom.dll 3.0.5300.1656 181,096 13-Nov-2007 17:54 x86

Microsoft Dynamics CRM client for Microsoft Office Outlook

File name File version File size Date Time Platform
Articleseditcontent.xsl Not applicable 5,527 17-Aug-2007 22:06 Not applicable
Crmmsg.dll 1.2.3297.123 16,088 13-Nov-2007 17:54 x86
Crmnativeinteropproxy.dll 3.0.5300.1726 3,402,256 13-Dec-2007 08:16 x86
Crmobjectmodel.dll 3.0.5300.1726 6,740,496 14-Dec-2007 00:16 x86
Crmsecurity.dll 3.0.5300.1726 770,576 14-Dec-2007 00:18 x86
Edit_article.aspx Not applicable 6,927 16-Nov-2007 21:15 Not applicable
Grid.htc Not applicable 17,560 10-Dec-2007 21:05 Not applicable
Listaction.js Not applicable 9,102 10-Dec-2007 21:05 Not applicable
Microsoft.crm.application.components.application.dll 3.0.5300.1726 599,056 14-Dec-2007 00:01 x86
Microsoft.crm.application.components.core.dll 3.0.5300.1726 295,952 14-Dec-2007 00:02 x86
Microsoft.crm.application.components.platform.dll 3.0.5300.1726 410,640 14-Dec-2007 00:03 x86
Microsoft.crm.application.components.strings.dll 3.0.5300.1726 726,032 14-Dec-2007 00:03 x86
Microsoft.crm.application.components.ui.dll 3.0.5300.1726 222,224 14-Dec-2007 00:01 x86
Microsoft.crm.application.pages.dll 3.0.5300.1726 738,320 14-Dec-2007 00:02 x86
Microsoft.crm.dll 3.0.5300.1726 381,968 14-Dec-2007 00:02 x86
Microsoft.crm.managedinterop.dll 3.0.5300.1726 82,960 14-Dec-2007 00:02 x86
Microsoft.crm.metadatahelper.dll 3.0.5300.1726 82,960 14-Dec-2007 00:02 x86
Microsoft.crm.objectmodel.dll 3.0.5300.1726 324,624 14-Dec-2007 00:03 x86
Microsoft.crm.platform.server.dll 3.0.5300.1726 246,800 14-Dec-2007 00:03 x86
Mscrmcustom.dll 3.0.5300.1656 181,096 13-Nov-2007 17:54 x86
Msvcr71.dll 7.10.3052.4 355,032 13-Nov-2007 17:54 x86
Pkgutil.cmd Not applicable 113 13-Nov-2007 01:54 Not applicable
Pkgutil.exe 1.2.3297.101 88,792 13-Nov-2007 17:54 x86
Print_dlg.aspx Not applicable 8,822 13-Dec-2007 21:02 Not applicable
Microsoft.crm.dll 3.0.5300.1 375,576 17-Nov-2005 04:42 x86
Microsoft.crm.managedinterop.dll 3.0.5300.1 80,664 17-Nov-2005 04:42 x86
Microsoft.crm.metadatahelper.dll 3.0.5300.1 80,664 17-Nov-2005 04:42 x86
Microsoft.crm.objectmodel.dll 3.0.5300.1 318,232 17-Nov-2005 04:42 x86
Microsoft.crm.platform.server.dll 3.0.5300.1 244,504 17-Nov-2005 04:42 x86
Crmhotfix.cdf Not applicable 7,848 14-Dec-2007 01:10 Not applicable
Mscrmcustom.dll 3.0.5300.1656 181,096 13-Nov-2007 17:54 x86

Microsoft Dynamics CRM client for Microsoft Office Outlook Compatibility Update

File name File version File size Date Time Platform
Setup.xml Not applicable 3,381 14-Dec-2007 01:30 Not applicable
V3cclientpatch30.msp Not applicable 2,921,472 14-Dec-2007 02:07 Not applicable
Articleseditcontent.xsl Not applicable 5,527 17-Aug-2007 22:06 Not applicable
Crmnativeinteropproxy.dll 3.0.5300.1726 3,402,256 14-Dec-2007 00:16 x86
Crmobjectmodel.dll 3.0.5300.1726 6,740,496 14-Dec-2007 00:16 x86
Crmsecurity.dll 3.0.5300.1726 770,576 14-Dec-2007 00:18 x86
Edit_article.aspx Not applicable 6,927 16-Nov-2007 21:15 Not applicable
Grid.htc Not applicable 17,560 10-Dec-2007 21:05 Not applicable
Listaction.js Not applicable 9,102 10-Dec-2007 21:05 Not applicable
Microsoft.crm.application.components.application.dll 3.0.5300.1726 599,056 14-Dec-2007 00:00 x86
Microsoft.crm.application.components.core.dll 3.0.5300.1726 295,952 14-Dec-2007 00:01 x86
Microsoft.crm.application.components.platform.dll 3.0.5300.1726 410,640 14-Dec-2007 00:01 x86
Microsoft.crm.application.components.strings.dll 3.0.5300.1726 726,032 14-Dec-2007 00:01 x86
Microsoft.crm.application.components.ui.dll 3.0.5300.1726 222,224 14-Dec-2007 00:00 x86
Microsoft.crm.application.pages.dll 3.0.5300.1726 738,320 13-Dec-2007 08:00 x86
Microsoft.crm.dll 3.0.5300.1726 381,968 14-Dec-2007 00:01 x86
Microsoft.crm.managedinterop.dll 3.0.5300.1726 82,960 14-Dec-2007 00:01 x86
Microsoft.crm.metadatahelper.dll 3.0.5300.1726 82,960 14-Dec-2007 00:01 x86
Microsoft.crm.objectmodel.dll 3.0.5300.1726 324,624 14-Dec-2007 00:02 x86
Microsoft.crm.platform.server.dll 3.0.5300.1726 246,800 14-Dec-2007 00:02 x86
Print_dlg.aspx Not applicable 8,822 13-Dec-2007 21:02 Not applicable
Setup.xml Not applicable 1,760 14-Dec-2007 01:29 Not applicable
V3clightclientpatch30.msp Not applicable 585,728 14-Dec-2007 02:07 Not applicable
Microsoft.crm.application.components.core.dll 3.0.5300.1726 295,952 14-Dec-2007 00:01 x86
Microsoft.crm.application.components.platform.dll 3.0.5300.1726 410,640 14-Dec-2007 00:01 x86
Microsoft.crm.application.components.strings.dll 3.0.5300.1726 726,032 14-Dec-2007 00:01 x86
Microsoft.crm.dll 3.0.5300.1726 381,968 14-Dec-2007 00:01 x86
Microsoft.crm.platform.server.dll 3.0.5300.1726 246,800 14-Dec-2007 00:02 x86

Installation information

Install this hotfix on computers that are running the Microsoft Dynamics CRM 3.0 server components and the Microsoft Dynamics CRM client for Microsoft Office Outlook components.

Prerequisites

You must have Microsoft Dynamics CRM 3.0 installed to apply this hotfix.

Restart requirement

If you are prompted to restart the computer, you must restart the computer after you apply this hotfix.

Removal information

To remove this hotfix from a computer that is running Windows Server 2003, Windows XP, or Windows 2000, use Add or Remove Programs in Control Panel. System administrators can use the Spuninst.exe tool to remove this hotfix from a computer that is running Windows Server 2003, Windows XP, or Windows 2000.

The Spuninst.exe tool is located in the %Windir%\$NTUninstallKB940496$\Spuninst folder. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

832475 Description of the new features in the package installer for Windows software updates


MORE INFORMATION

If you have enabled platform tracing, you also receive an error message in the trace log file that resembles the following error message:

Transaction (Process ID 71) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at System.Data.SqlClient.SqlDataReader.Read()
at Microsoft.Crm.BusinessEntities.BusinessProcessObject.FillEntityCollectionFromDataReader(BusinessEntityCollection entities, SqlDataReader reader, EntityExpression entityExp, PagingHelper pagingHelper)
at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, ExecutionContext context)
at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, ExecutionContext context)
at Microsoft.Crm.ObjectModel.CommunicationActivityServiceBase.RetrieveMultiple(EntityExpression entityExpression, ExecutionContext context)
at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression)
at Microsoft.Crm.ObjectModel.QueryService.RetrieveMultiple(EntityExpression entityExpression)
at Microsoft.Crm.WebServices.QueryWebService.RetrieveMultiple(QueryBase query)

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates


887283 Microsoft Business Solutions CRM software hotfix and update package naming standards


Keywords: kberrmsg kbmbsperformance kbhotfixserver kbqfe kbmbsmigrate kbpubtypekc KB940496