I have a crm 4.0 installation ( rollup 9) running on an 2008 R2 server that also host the SQL . The MSCRMAsyncService keeps stopping and none of my workflow jobs are being processed . I'm new at CRM and would like any advice re how to troubleshoot this. I have posted the event log for the service error below. The error message segment : 'Unexpected number of records affected. Expected: 1, actual: -1' is the same each time but the GUID changes. So it looks like the service is having problems processing data in a message queue for the system jobs but I really have no idea where to start.
I have already checked the case of the sql server name in the config database and compared it to the one for the global variable in SQL and everythingh is in uppercase so I dont think its the isse described in http://support.microsoft.com/kb/949844/en-au
any ideas?
Log Name: Application
Source: MSCRMAsyncService
Date: 13/05/2010 8:53:43 AM
Event ID: 17411
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: PIPESQL2.pipe.local
Description:
Host PIPESQL2: failed while monitoring asynchronous operations queue. Exception: Microsoft.Crm.CrmException: PIPESQL2.MSCRMAsyncService.5afb9cf4-af4d-4f87-a5ef-b2bbd083b41d: Unexpected number of records affected. Expected: 1, actual: -1. Query: System.Data.SqlClient.SqlCommand.
at Microsoft.Crm.Asynchronous.DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
at Microsoft.Crm.Asynchronous.QueueDataAccess.UpdateStateAndStatusInternal(Guid eventId, Int32 newState, Int32 newStatus, DateTime nextOccurrence, Boolean retryOperation, Int32 currentRetryCount, Int32 errorCode, String errorMessage, Boolean clearData, Boolean removeEvent, Int32 operationType)
at Microsoft.Crm.Asynchronous.QueueDataAccess.UpdateStateAndStatusCommand.InternalExecute()
at Microsoft.Crm.Asynchronous.QueuedDatabaseCommand.Execute(QueueManager queueManager)
at Microsoft.Crm.Asynchronous.QueueManager.ExecuteAllOutstandingDatabaseOperations()
at Microsoft.Crm.Asynchronous.QueueManager.OnDatabaseOperationTimerEvent(Object sender, ElapsedEventArgs e)
at Microsoft.Crm.Asynchronous.Timer.TimerProcessor.ExecuteTimers(Object data)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart(Object obj)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSCRMAsyncService" />
<EventID Qualifiers="49152">17411</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2010-05-12T22:53:43.000000000Z" />
<EventRecordID>115779</EventRecordID>
<Channel>Application</Channel>
<Computer>PIPESQL2.pipe.local</Computer>
<Security />
</System>
<EventData>
<Data>PIPESQL2</Data>
<Data>Microsoft.Crm.CrmException: PIPESQL2.MSCRMAsyncService.5afb9cf4-af4d-4f87-a5ef-b2bbd083b41d: Unexpected number of records affected. Expected: 1, actual: -1. Query: System.Data.SqlClient.SqlCommand.
at Microsoft.Crm.Asynchronous.DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
at Microsoft.Crm.Asynchronous.QueueDataAccess.UpdateStateAndStatusInternal(Guid eventId, Int32 newState, Int32 newStatus, DateTime nextOccurrence, Boolean retryOperation, Int32 currentRetryCount, Int32 errorCode, String errorMessage, Boolean clearData, Boolean removeEvent, Int32 operationType)
at Microsoft.Crm.Asynchronous.QueueDataAccess.UpdateStateAndStatusCommand.InternalExecute()
at Microsoft.Crm.Asynchronous.QueuedDatabaseCommand.Execute(QueueManager queueManager)
at Microsoft.Crm.Asynchronous.QueueManager.ExecuteAllOutstandingDatabaseOperations()
at Microsoft.Crm.Asynchronous.QueueManager.OnDatabaseOperationTimerEvent(Object sender, ElapsedEventArgs e)
at Microsoft.Crm.Asynchronous.Timer.TimerProcessor.ExecuteTimers(Object data)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart(Object obj)</Data>
</EventData>
</Event>
