You are currently offline, waiting for your internet to reconnect

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

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
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
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.
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 Microsoft Dynamics CRM 4.0 updates and hotfixes
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Article ID: 975490 - Last Review: 10/22/2009 15:22:50 - Revision: 1.0

Microsoft Dynamics CRM 4.0

  • kberrmsg kbfix kbexpertiseinter kbsurveynew kbmbsmigrate kbqfe kbhotfixserver KB975490