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

Article translations Article translations
Article ID: 975490 - View products that this article applies to.
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.

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 Microsoft Dynamics CRM 4.0 updates and hotfixes

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 975490 - Last Review: October 22, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Dynamics CRM 4.0
Keywords: 
kberrmsg kbfix kbexpertiseinter kbsurveynew kbmbsmigrate kbqfe kbhotfixserver KB975490

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com