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.
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.