Показать сообщение отдельно
Старый 15.02.2010, 11:53   #4  
slivka_83 is offline
slivka_83
Консультант-джедай
Аватар для slivka_83
MCBMSS
Лучший по профессии 2015
Лучший по профессии 2014
Лучший по профессии AXAWARD 2013
Лучший по профессии 2011
Лучший по профессии 2009
 
1,683 / 374 (16) ++++++
Регистрация: 18.12.2008
Адрес: default city
Итого у Вас четыре разные ошибки:
X++:
>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)
X++:
>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)
X++:
>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()
X++:
>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()
Не подскажите чего делает Ваш БП?
__________________
Крокодил, крокожу и буду крокодить.
Человек человеку - волк , а зомби зомби - зомби.
Экстремал и буду экстремать!
Блога