locked
MSCRMAsync process error RRS feed

  • Question

  • 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

    Friday, February 1, 2013 1:06 PM

Answers

  • 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
    Wednesday, February 20, 2013 9:41 AM

All replies