Article ID: 975490 - Last Review: October 22, 2009 - Revision: 1.0

A deadlock occurs when the Microsoft Dynamics CRM 4.0 asynchronous service is running on multiple servers

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
Expand all | Collapse all

SYMPTOMS

Assume that you deploy multiple servers that host the Microsoft Dynamics CRM 4.0 asynchronous service. Therefore, the Microsoft Dynamics CRM 4.0 asynchronous service is running on multiple servers. When the asynchronous service selects asynchronous operation records, a deadlock occurs.

Additionally, the following error message is logged in the event log:
Event Type: Error
Event Source: MSCRMAsyncService
Event Category: None
Event ID: 17415
Date: Date
Time: Time
User: N/A
Computer: Computer Name
Description:
Host Computer Name: error while processing organization 7a292759-ddfe-dd11-b4a4-00155dc95102. Exception: System.Data.SqlClient.SqlException: Transaction (Process ID 86) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at Microsoft.Crm.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at Microsoft.Crm.Asynchronous.QueueDataAccess.SelectEvents(Int32 numberOfEvents)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Note The Date placeholder is a placeholder for the date of the event, the Time placeholder is a placeholder for the time of the event, and the Computer Name placeholder is a placeholder for the computer name of the computer.
Back to the top

RESOLUTION

This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
949256  (http://support.microsoft.com/kb/949256/ ) Microsoft Dynamics CRM 4.0 updates and hotfixes
Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top
APPLIES TO
  • Microsoft Dynamics CRM 4.0
Back to the top
Keywords: 
kberrmsg kbfix kbexpertiseinter kbsurveynew kbmbsmigrate kbqfe kbhotfixserver KB975490
Back to the top