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