MSCRMAsync process error
-
Friday, February 01, 2013 1:06 PM
Hi pls all my workflows are not running. the event log shows this error
Log Name: Application
Source: MSCRMAsyncService
Date: 1/31/2013 3:38:12 PM
Event ID: 17415
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: DYNAMICS.ccsnl.com
Description:
Host DYNAMICS: error while processing organization d89be16a-5405-4d66-9729-3f7d40886c62. Exception: System.Data.SqlClient.SqlException (0x80131904): Internal Query Processor Error: The query processor encountered an unexpected error during execution.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
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 Microsoft.Crm.CrmDataReader.Read()
at Microsoft.Crm.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at Microsoft.Crm.Asynchronous.QueueDataAccess.SelectEvents(Int32 numberOfEvents)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSCRMAsyncService" />
<EventID Qualifiers="49152">17415</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2013-01-31T14:38:12.000000000Z" />
<EventRecordID>3072333</EventRecordID>
<Channel>Application</Channel>
<Computer>DYNAMICS.ccsnl.com</Computer>
<Security />
</System>
<EventData>
<Data>DYNAMICS</Data>
<Data>d89be16a-5405-4d66-9729-3f7d40886c62</Data>
<Data>System.Data.SqlClient.SqlException (0x80131904): Internal Query Processor Error: The query processor encountered an unexpected error during execution.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
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 Microsoft.Crm.CrmDataReader.Read()
at Microsoft.Crm.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at Microsoft.Crm.Asynchronous.QueueDataAccess.SelectEvents(Int32 numberOfEvents)</Data>
</EventData>
</Event>please help as this is driving me crazy
System integrator
All Replies
-
Monday, February 04, 2013 9:10 PMModerator
Is this only in the error logs or is it generating errors to the client? Sometimes resetting the async services and then performing an IIS reset can resolve these types of things. Try that and let me know if that helps.
Jamie Miley
Check out RBA Today!
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter! -
Tuesday, February 05, 2013 10:36 AMModeratorIf restarting doesn't help, then try enabling tracing and check the trace file for the AsyncService. It that gives no more information, then SQL Tracing should help identify what the SQL error is.
Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk
-
Tuesday, February 19, 2013 11:57 PMModeratorDid you get this resolved?
Jamie Miley
Check out RBA Today!
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter! -
Wednesday, February 20, 2013 9:41 AM
Yes i have. i applied the update rollup 12 on the server and it solved the issue
System integrator
- Marked As Answer by youngceaser Wednesday, February 20, 2013 9:41 AM