Article ID: 975490 - View products that this article applies to.
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:
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.
Event Type: Error
Event Source: MSCRMAsyncService
Event Category: None
Event ID: 17415
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.ReadInternal(Boolean setTimeout)
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.
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:
(http://support.microsoft.com/kb/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.
Contact us for more help
Connect with Answer Desk for expert help.