locked
MSCRM 2011 Async service Issue RRS feed

  • Question

  • The workflows doesn't fire .....

    Async service is already started . tried restarting the same, restarted SQL server  ....no luck

    In the setting > system jobs  workflow extension task i can see an entry added with status in progress ...but workflow associated view shows nothing ..

    The crm trace shows the following :

    
    Exception while trying to execute query: 
    SET DEADLOCK_PRIORITY LOW
    SET XACT_ABORT ON
    BEGIN TRANSACTION
    	DECLARE @res INT
    	EXEC @res = sp_getapplock                 
    				@Resource = 'AsyncService_app_lock',
    				@LockMode = 'Exclusive'
    	IF @res NOT IN (0, 1)
    	BEGIN
    		RAISERROR ( 'Unable to acquire App Lock', 16, 1 )
    	END 
    	ELSE
    	BEGIN
    
    update AsyncOperationBase
    set
    	HostId = 'MVCRMTEST01.MSCRMAsyncService.7221e1e3-f52e-4111-af79-517055fb368f',
    	StateCode = 2,
    	StatusCode = 20,
    	StartedOn = '10/09/2016 17:07:25',
    	ModifiedOn = '10/09/2016 17:07:25',
    	ModifiedBy = CreatedBy,
    	RetryCount = case coalesce(ErrorCode, 0)
    					when 0 then coalesce(RetryCount, 0)
    					else coalesce(RetryCount, 0)+1
    					end
    output
    	INSERTED.AsyncOperationId,
    	INSERTED.OperationType,
    	INSERTED.Data,
    	INSERTED.DependencyToken,
    	INSERTED.RegardingObjectId,
    	INSERTED.RegardingObjectIdName,
    	INSERTED.RegardingObjectTypeCode,
    	INSERTED.OwningBusinessUnit,
    	INSERTED.OwningExtensionId,
    	INSERTED.OwningExtensionIdName,
    	INSERTED.OwningExtensionTypeCode,
    	INSERTED.OwnerId,
    	INSERTED.RetryCount,
    	INSERTED.MessageName,
    	INSERTED.RecurrencePattern,
    	INSERTED.RecurrenceStartTime,
    	INSERTED.CorrelationId,
    	INSERTED.CorrelationUpdatedTime,
    	INSERTED.Depth,
    	INSERTED.PrimaryEntityType,
    	INSERTED.RequestId,
    	INSERTED.CreatedOn,
    	INSERTED.ExecutionTimeSpan
    where
    AsyncOperationId in
    	(select top(96) AsyncOperationId from AsyncOperationBase WITH (READPAST, READCOMMITTEDLOCK, UPDLOCK) 
    		where StateCode = 0 
    		and OperationType IS NOT null 
    		order by Sequence asc)
    EXEC @res = sp_releaseapplock 
    							@Resource = 'AsyncService_app_lock'
    	END    
    COMMIT - System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'AsyncOperationBase'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)
       at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)
       at Microsoft.Crm.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
    ClientConnectionId:d7c3709b-e7d0-4e90-b57d-1eb320eb2741
    Error Number:208,State:1,Class:16

    

    

    Sunday, October 9, 2016 6:58 PM