Ошибка бизнес-процесса

[slivka_83]

Итого у Вас четыре разные ошибки:

>VMS2.MSCRMAsyncService.ccac1a49-9e2d-45f7-8695-d3f6024b4849: Exception while trying to execute query: update AsyncOperationBase
set
HostId = 'VMS2.MSCRMAsyncService.ccac1a49-9e2d-45f7-8695-d3f6024b4849',
StateCode = 2,
StatusCode = 20,
StartedOn = DATEADD(MILLISECOND, -1*DATEPART(MILLISECOND, GETUTCDATE()), GETUTCDATE()),
ModifiedOn = DATEADD(MILLISECOND, -1*DATEPART(MILLISECOND, GETUTCDATE()), GETUTCDATE()),
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.RegardingObjectIdDsc,
INSERTED.RegardingObjectTypeCode,
INSERTED.OwningUser,
INSERTED.RetryCount,
INSERTED.RecurrencePattern,
INSERTED.RecurrenceStartTime,
INSERTED.CorrelationId,
INSERTED.CorrelationUpdatedTime,
INSERTED.Depth,
INSERTED.PrimaryEntityType,
INSERTED.RequestId
where
StateCode = 0
and DeletionStateCode = 0
and AsyncOperationId in
(select top(1999) AsyncOperationId from AsyncOperationBase where StateCode = 0 and DeletionStateCode = 0 order by Sequence asc) - System.Data.SqlClient.SqlException: Transaction (Process ID 83) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
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.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)

>Received SQL Exception accessing organization {E26D7E2D-33B0-417E-8875-7E0C045FDA3E}. Exception: System.Data.SqlClient.SqlException: Transaction (Process ID 83) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
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.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at Microsoft.Crm.Asynchronous.QueueDataAccess.SelectEvents(Int32 numberOfEvents)

>Workflow terminated: {5C886BA2-EA19-DF11-B1A4-003048743D05} - Microsoft.Crm.Workflow.Activities.StopWorkflowException
at Microsoft.Crm.Workflow.Activities.StopWorkflowActivity.Execute(ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(T activity, ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(Activity activity, ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)
at System.Workflow.Runtime.Scheduler.Run()

>Workflow terminated: {FBB6D176-F619-DF11-A3DC-16C03228C478} - System.Net.WebException: The operation has timed out
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at E_mailFromQuote1.ksdb3.ReportExecutionService.LoadReport(String Report, String HistoryID)
at E_mailFromQuote1.SendReport.Execute(ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(T activity, ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.CompositeActivityExecutor`1.Execute(T activity, ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(Activity activity, ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)
at System.Workflow.Runtime.Scheduler.Run()

Не подскажите чего делает Ваш БП?

[Tarasov E]

Вот собственно сам БП. Как вы видите ждем до определенного времени, после чего выполняется кастомный шаг "сканирование", который выдергивает интересующую информацию с заданного вэб ресурса, затем, если нужная информация была найдена - отправляет ответственному за БП пользователю уведомление об этом. Потом меняется дата для следующего запуска БП и снова ждем. Таким образом получаем зацикливание.
Дело в том. что в коне практически ничего не менял и все работало стабильно когда был один сервер

Да, и по ошибкам, чем они могут быть вызваны, не подскажете? Они все касательно именно моего БП?