[Gelöst] Workflow legt keine Serviceakt. an

Hallo zusammen,

ich habe folgenden Workflow erstellt:

Ausführung bei Bedarf
Bereich Organisation

Schritte:
Erstellen Serviceakt.
WF beenden mit Status: Erfolgreich.

Wenn ich diesen WF anfordere finde ich Ihn unter:
Systemauftrag: Workflow expansion task
Statusgrund: Es wird gewartet

und dort bleibt er.

Kann mir jemand erklären warum keine Serviceakt. angelegt wird und der WF nicht endet?
Dank für Hilfe!
Service

Zuletzt geändert von Service am 11. August 2010 13:44, insgesamt 1-mal geändert.

Hallo Wolfgang,

erst einmal herzlich willkommen in unserem Forum.

Funktionieren denn andere Workflows, oder verhalten sich alle Workflows gleich?

Wenn du den Workflow von Serviceaktivität auf z.B. eine Aufgabe umstellst, funktioniert er dann?

Hallo Michael,

danke für das freundliche Willkommen!

die "nicht"Reaktion erfolgt auch bei einer Aufgabe - kein Unterschied

Hallo Wolfgang,

dann überprüfe einmal auf dem SQL Server mit folgendem Code die Einstellungen in der MSCRM_config Datenbank

Code:

SELECT ColumnName, NVarCHarColumn FROM DeploymentProperties
WHERE ColumnName in ('AsyncSdkRootDomain', 'ADWebApplicationRootDomain', 'ADSdkRootDomain')


In allen drei Feldern sollte der gleiche Eintrag angezeigt werden, wenn nicht, die fehlenden Eniträge bitte hinzufügen.

Und überpürfe, das der AsyncService des CRM gestartet ist.

Hallo Michael,

hier die Antwort:

ADSdkRootDomain WBCRM
ADWebApplicationRootDomain WBCRM
AsyncSdkRootDomain

WBCRM ist der Servername!

Der Asynchrone Verarbeitungsdienst läuft, angemeldet als Lokales System
Den Eintrag für AsyncSdkRootDomain=WBCRM habe ich nachgeflegt - Ohne Erfolg

Hallo Wolfgang,

du musst den AsyncService neu starten, damit die Änderungen gelesen werden.

Hallo Michael,

Danke für die Zeit die Du mir widmest!

Dienstneustart - keine Änderung

Hallo Wolfgang,

kein Problem

Welchen RU Stand habt ihr denn auf eurem Server?

Hast du bei dem Workflow nach der Änderung einmal die Veröffentlichung aufgehoben, den Workflow wieder veröffentlicht und anschließend manuell neu ausgelöst?

Hallo MIchael,

4.0.7333.2148

Ja - aber ohne Änderung... er wartet halt (worauf auch immer)

Hallo,

dann würde ich einmal das Tracing auf dem Server einschalten, um eine genauere Fehlermeldung zu erhalten.

Hallo MIchael,

hier das Ergebniss:

# CRM Tracing Version 2.0
# LocalTime: 2010-08-11 11:19:30.0
# Categories: *:Verbose
# CallStackOn: Yes
# ComputerName: WBCRM
# CRMVersion: 4.0.7333.2148
# DeploymentType: OnPremise
# ScaleGroup:
# ServerRole: AppServer, AsyncService, DiscoveryService, WebService, ApiServer, HelpServer, DeploymentService

[2010-08-11 11:19:30.0] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 11(MSCRM:-NotificationManager.NotificationWatcherThreadProc) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | NotificationService.GetConfigScopeNotifications
at NotificationService.GetConfigScopeNotifications(ConfigScope scope, Object organizationId, Int32[] events, DateTime lastChecked)
at NotificationService.GetNotifications(Object organizationId, Int32[] events, DateTime lastChecked)
at DBNotificationsProvider.GetNotifications(DateTime lastChecked)
at NotificationManager.NotificationWatcherThreadProc()
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart()
>SELECT OrganizationId, EventId, EventData, CreatedOn FROM Notification WHERE CreatedOn > '08/11/2010 08:15:40'
[2010-08-11 11:19:30.1] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 11(MSCRM:-NotificationManager.NotificationWatcherThreadProc) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at NotificationService.GetConfigScopeNotifications(ConfigScope scope, Object organizationId, Int32[] events, DateTime lastChecked)
at NotificationService.GetNotifications(Object organizationId, Int32[] events, DateTime lastChecked)
at DBNotificationsProvider.GetNotifications(DateTime lastChecked)
at NotificationManager.NotificationWatcherThreadProc()
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart()
>SELECT OrganizationId, EventId, EventData, CreatedOn FROM Notification WHERE CreatedOn > '08/11/2010 08:15:40'
[2010-08-11 11:19:32.8] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>update AsyncOperationBase
set
HostId = 'WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca',
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(2000) AsyncOperationId from AsyncOperationBase (UPDLOCK) where StateCode = 0 and DeletionStateCode = 0 order by Sequence asc)
# CRM Tracing Version 2.0
# LocalTime: 2010-08-11 11:19:32.8
# Categories: *:Verbose
# CallStackOn: Yes
# ComputerName: WBCRM
# CRMVersion: 4.0.7333.2148
# DeploymentType: OnPremise
# ScaleGroup:
# ServerRole: AppServer, AsyncService, DiscoveryService, WebService, ApiServer, HelpServer, DeploymentService

[2010-08-11 11:19:32.8] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | QueueDataAccess.SelectEvents
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca: Selecting up to 2000 operations - 0 selected.
[2010-08-11 11:19:32.8] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | WorkloadThrottler.TraceWorkloadThrottlingInformation
at WorkloadThrottler.TraceWorkloadThrottlingInformation(Guid organizationId, Int32 priority, Int32 waitIteration, Int32 orgCapacity, Int32 actualWorkDone)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WorkloadThrottlingInformation: WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca_OnSelect, {7162A053-162C-4C63-BEC2-DC5BF8145860}, 0, 0, 2000, 0
[2010-08-11 11:19:37.4] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at WaitSubscriptionDataAccess.Notify(IDbCommand selectCommand, WaitNotificationService waitNotificationService)
at WaitSubscriptionDataAccess.Notify(String hostId, WaitNotificationService waitNotificationService, Int32 maxRetries)
at WorkflowHost.OnNotificationTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select subscription.WorkflowWaitSubscriptionId, subscription.AsyncOperationId, subscription.EntityName, subscription.EntityId, subscription.Data
from WorkflowWaitSubscriptionBase subscription
join AsyncOperationBase asyncOperation on subscription.AsyncOperationId = asyncOperation.AsyncOperationId
where asyncOperation.HostId = 'MSCRMAsyncService'
and asyncOperation.StateCode = Locked
and asyncOperation.DeletionStateCode = 0
and subscription.IsModified = 1
[2010-08-11 11:19:37.4] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteNonQuery
at CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command)
at DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
at WaitSubscriptionDataAccess.RestartWaitingWorkflowInstances(Int32 maxRetries)
at WaitSubscriptionDataAccess.Notify(String hostId, WaitNotificationService waitNotificationService, Int32 maxRetries)
at WorkflowHost.OnNotificationTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>
if exists (select * from WorkflowWaitSubscriptionBase (nolock) where IsModified = 1)
begin
update AsyncOperationBase
set
StateCode = 0,
StatusCode = 0,
ModifiedOn = DATEADD(MILLISECOND, -1*DATEPART(MILLISECOND, GETUTCDATE()), GETUTCDATE()),
ModifiedBy = CreatedBy
where
StateCode = 1
and RetryCount < 5
and DeletionStateCode = 0
and AsyncOperationId in (select AsyncOperationId from WorkflowWaitSubscriptionBase where IsModified = 1)
end
[2010-08-11 11:19:37.4] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteNonQuery
at CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command)
at DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
at QueueDataAccess.MoveSuspendedToReady()
at QueueManager.<OnMoveSuspendedToReadyTimerEvent>b__1(IQueueDataAccess queueDataAccess)
at QueueManager.ExecuteForAllOrganizations(OrganizationQueueDataAccessHandler handler)
at QueueManager.OnMoveSuspendedToReadyTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>With TopSuspendedAsyncOperations(AsyncOperationId)
AS
(
Select Top(2000) AsyncOperationId
from AsyncOperationBase o1
where
StateCode = 1
and DeletionStateCode = 0
and ((PostponeUntil is NULL) or (PostponeUntil <= GETUTCDATE()))
and ((DependencyToken is NULL) or (not exists (
select AsyncOperationId
from AsyncOperationBase o2
where
o2.Sequence < o1.Sequence
and o2.DependencyToken = o1.DependencyToken
and o2.StateCode in (0,2,1) and o2.DeletionStateCode = 0)))
)
update AsyncOperationBase
set
StateCode = 0,
StatusCode = 0,
ModifiedOn = DATEADD(MILLISECOND, -1*DATEPART(MILLISECOND, GETUTCDATE()), GETUTCDATE()),
ModifiedBy = CreatedBy
From AsyncOperationBase join TopSuspendedAsyncOperations on
AsyncOperationBase.AsyncOperationId = TopSuspendedAsyncOperations.AsyncOperationId

[2010-08-11 11:19:37.8] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>update AsyncOperationBase
set
HostId = 'WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca',
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(2000) AsyncOperationId from AsyncOperationBase (UPDLOCK) where StateCode = 0 and DeletionStateCode = 0 order by Sequence asc)
[2010-08-11 11:19:37.8] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | QueueDataAccess.SelectEvents
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca: Selecting up to 2000 operations - 0 selected.
[2010-08-11 11:19:37.8] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | WorkloadThrottler.TraceWorkloadThrottlingInformation
at WorkloadThrottler.TraceWorkloadThrottlingInformation(Guid organizationId, Int32 priority, Int32 waitIteration, Int32 orgCapacity, Int32 actualWorkDone)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WorkloadThrottlingInformation: WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca_OnSelect, {7162A053-162C-4C63-BEC2-DC5BF8145860}, 0, 0, 2000, 0
[2010-08-11 11:19:42.8] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>update AsyncOperationBase
set
HostId = 'WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca',
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(2000) AsyncOperationId from AsyncOperationBase (UPDLOCK) where StateCode = 0 and DeletionStateCode = 0 order by Sequence asc)
[2010-08-11 11:19:42.8] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | QueueDataAccess.SelectEvents
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca: Selecting up to 2000 operations - 0 selected.
[2010-08-11 11:19:42.8] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | WorkloadThrottler.TraceWorkloadThrottlingInformation
at WorkloadThrottler.TraceWorkloadThrottlingInformation(Guid organizationId, Int32 priority, Int32 waitIteration, Int32 orgCapacity, Int32 actualWorkDone)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WorkloadThrottlingInformation: WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca_OnSelect, {7162A053-162C-4C63-BEC2-DC5BF8145860}, 0, 0, 2000, 0
[2010-08-11 11:19:47.4] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at WaitSubscriptionDataAccess.Notify(IDbCommand selectCommand, WaitNotificationService waitNotificationService)
at WaitSubscriptionDataAccess.Notify(String hostId, WaitNotificationService waitNotificationService, Int32 maxRetries)
at WorkflowHost.OnNotificationTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select subscription.WorkflowWaitSubscriptionId, subscription.AsyncOperationId, subscription.EntityName, subscription.EntityId, subscription.Data
from WorkflowWaitSubscriptionBase subscription
join AsyncOperationBase asyncOperation on subscription.AsyncOperationId = asyncOperation.AsyncOperationId
where asyncOperation.HostId = 'MSCRMAsyncService'
and asyncOperation.StateCode = Locked
and asyncOperation.DeletionStateCode = 0
and subscription.IsModified = 1
[2010-08-11 11:19:47.4] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteNonQuery
at CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command)
at DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
at WaitSubscriptionDataAccess.RestartWaitingWorkflowInstances(Int32 maxRetries)
at WaitSubscriptionDataAccess.Notify(String hostId, WaitNotificationService waitNotificationService, Int32 maxRetries)
at WorkflowHost.OnNotificationTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>
if exists (select * from WorkflowWaitSubscriptionBase (nolock) where IsModified = 1)
begin
update AsyncOperationBase
set
StateCode = 0,
StatusCode = 0,
ModifiedOn = DATEADD(MILLISECOND, -1*DATEPART(MILLISECOND, GETUTCDATE()), GETUTCDATE()),
ModifiedBy = CreatedBy
where
StateCode = 1
and RetryCount < 5
and DeletionStateCode = 0
and AsyncOperationId in (select AsyncOperationId from WorkflowWaitSubscriptionBase where IsModified = 1)
end
[2010-08-11 11:19:47.5] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteNonQuery
at CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command)
at DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
at QueueDataAccess.MoveSuspendedToReady()
at QueueManager.<OnMoveSuspendedToReadyTimerEvent>b__1(IQueueDataAccess queueDataAccess)
at QueueManager.ExecuteForAllOrganizations(OrganizationQueueDataAccessHandler handler)
at QueueManager.OnMoveSuspendedToReadyTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>With TopSuspendedAsyncOperations(AsyncOperationId)
AS
(
Select Top(2000) AsyncOperationId
from AsyncOperationBase o1
where
StateCode = 1
and DeletionStateCode = 0
and ((PostponeUntil is NULL) or (PostponeUntil <= GETUTCDATE()))
and ((DependencyToken is NULL) or (not exists (
select AsyncOperationId
from AsyncOperationBase o2
where
o2.Sequence < o1.Sequence
and o2.DependencyToken = o1.DependencyToken
and o2.StateCode in (0,2,1) and o2.DeletionStateCode = 0)))
)
update AsyncOperationBase
set
StateCode = 0,
StatusCode = 0,
ModifiedOn = DATEADD(MILLISECOND, -1*DATEPART(MILLISECOND, GETUTCDATE()), GETUTCDATE()),
ModifiedBy = CreatedBy
From AsyncOperationBase join TopSuspendedAsyncOperations on
AsyncOperationBase.AsyncOperationId = TopSuspendedAsyncOperations.AsyncOperationId

[2010-08-11 11:19:47.8] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>update AsyncOperationBase
set
HostId = 'WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca',
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(2000) AsyncOperationId from AsyncOperationBase (UPDLOCK) where StateCode = 0 and DeletionStateCode = 0 order by Sequence asc)
[2010-08-11 11:19:47.8] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | QueueDataAccess.SelectEvents
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca: Selecting up to 2000 operations - 0 selected.
[2010-08-11 11:19:47.8] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | WorkloadThrottler.TraceWorkloadThrottlingInformation
at WorkloadThrottler.TraceWorkloadThrottlingInformation(Guid organizationId, Int32 priority, Int32 waitIteration, Int32 orgCapacity, Int32 actualWorkDone)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WorkloadThrottlingInformation: WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca_OnSelect, {7162A053-162C-4C63-BEC2-DC5BF8145860}, 0, 0, 2000, 0
[2010-08-11 11:19:52.9] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>update AsyncOperationBase
set
HostId = 'WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca',
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(2000) AsyncOperationId from AsyncOperationBase (UPDLOCK) where StateCode = 0 and DeletionStateCode = 0 order by Sequence asc)
[2010-08-11 11:19:52.9] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | QueueDataAccess.SelectEvents
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca: Selecting up to 2000 operations - 0 selected.
[2010-08-11 11:19:52.9] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | WorkloadThrottler.TraceWorkloadThrottlingInformation
at WorkloadThrottler.TraceWorkloadThrottlingInformation(Guid organizationId, Int32 priority, Int32 waitIteration, Int32 orgCapacity, Int32 actualWorkDone)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WorkloadThrottlingInformation: WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca_OnSelect, {7162A053-162C-4C63-BEC2-DC5BF8145860}, 0, 0, 2000, 0
[2010-08-11 11:19:57.4] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at WaitSubscriptionDataAccess.Notify(IDbCommand selectCommand, WaitNotificationService waitNotificationService)
at WaitSubscriptionDataAccess.Notify(String hostId, WaitNotificationService waitNotificationService, Int32 maxRetries)
at WorkflowHost.OnNotificationTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select subscription.WorkflowWaitSubscriptionId, subscription.AsyncOperationId, subscription.EntityName, subscription.EntityId, subscription.Data
from WorkflowWaitSubscriptionBase subscription
join AsyncOperationBase asyncOperation on subscription.AsyncOperationId = asyncOperation.AsyncOperationId
where asyncOperation.HostId = 'MSCRMAsyncService'
and asyncOperation.StateCode = Locked
and asyncOperation.DeletionStateCode = 0
and subscription.IsModified = 1
[2010-08-11 11:19:57.4] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteNonQuery
at CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command)
at DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
at WaitSubscriptionDataAccess.RestartWaitingWorkflowInstances(Int32 maxRetries)
at WaitSubscriptionDataAccess.Notify(String hostId, WaitNotificationService waitNotificationService, Int32 maxRetries)
at WorkflowHost.OnNotificationTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>
if exists (select * from WorkflowWaitSubscriptionBase (nolock) where IsModified = 1)
begin
update AsyncOperationBase
set
StateCode = 0,
StatusCode = 0,
ModifiedOn = DATEADD(MILLISECOND, -1*DATEPART(MILLISECOND, GETUTCDATE()), GETUTCDATE()),
ModifiedBy = CreatedBy
where
StateCode = 1
and RetryCount < 5
and DeletionStateCode = 0
and AsyncOperationId in (select AsyncOperationId from WorkflowWaitSubscriptionBase where IsModified = 1)
end
[2010-08-11 11:19:57.5] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteNonQuery
at CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command)
at DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
at QueueDataAccess.MoveSuspendedToReady()
at QueueManager.<OnMoveSuspendedToReadyTimerEvent>b__1(IQueueDataAccess queueDataAccess)
at QueueManager.ExecuteForAllOrganizations(OrganizationQueueDataAccessHandler handler)
at QueueManager.OnMoveSuspendedToReadyTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>With TopSuspendedAsyncOperations(AsyncOperationId)
AS
(
Select Top(2000) AsyncOperationId
from AsyncOperationBase o1
where
StateCode = 1
and DeletionStateCode = 0
and ((PostponeUntil is NULL) or (PostponeUntil <= GETUTCDATE()))
and ((DependencyToken is NULL) or (not exists (
select AsyncOperationId
from AsyncOperationBase o2
where
o2.Sequence < o1.Sequence
and o2.DependencyToken = o1.DependencyToken
and o2.StateCode in (0,2,1) and o2.DeletionStateCode = 0)))
)
update AsyncOperationBase
set
StateCode = 0,
StatusCode = 0,
ModifiedOn = DATEADD(MILLISECOND, -1*DATEPART(MILLISECOND, GETUTCDATE()), GETUTCDATE()),
ModifiedBy = CreatedBy
From AsyncOperationBase join TopSuspendedAsyncOperations on
AsyncOperationBase.AsyncOperationId = TopSuspendedAsyncOperations.AsyncOperationId

[2010-08-11 11:19:57.9] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>update AsyncOperationBase
set
HostId = 'WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca',
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(2000) AsyncOperationId from AsyncOperationBase (UPDLOCK) where StateCode = 0 and DeletionStateCode = 0 order by Sequence asc)
[2010-08-11 11:19:57.9] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | MetadataCache.LoadCache
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Loading StaticMetadataCache for organization : {7162A053-162C-4C63-BEC2-DC5BF8145860}
[2010-08-11 11:19:57.9] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | DynamicMetadataCacheFactory.LoadMetadataCache
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Loading metadata, method = Database, type = InstanceUsingSharedSystemData, masks = All, orgid = {7162A053-162C-4C63-BEC2-DC5BF8145860}
[2010-08-11 11:19:57.9] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at MultiOrgSharableMetadataCacheLoader.GetOrganizationVersionFromDatabase(CrmDbConnection connection, IDbTransaction transaction)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select BuildNumber, MajorVersion, MinorVersion, Revision from BuildVersion
[2010-08-11 11:19:57.9] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | MultiOrgSharableMetadataCacheLoader.BuildDataSet
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Multi-org sharable cache build data set for org {7162A053-162C-4C63-BEC2-DC5BF8145860}, system data loaded is False
[2010-08-11 11:19:58.0] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select * from Entity order by CustomizationLevel asc
[2010-08-11 11:19:58.2] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select * from Attribute where InProduction = 1 order by CustomizationLevel asc
[2010-08-11 11:19:58.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select * from AttributeLookupValue where InProduction = 1 order by CustomizationLevel asc
[2010-08-11 11:19:58.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select * from AttributePicklistValue where InProduction = 1 order by CustomizationLevel, DisplayOrder asc
[2010-08-11 11:19:58.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select * from EntityRelationship order by CustomizationLevel asc
[2010-08-11 11:19:58.7] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select * from Relationship order by CustomizationLevel asc
[2010-08-11 11:19:58.7] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select * from RelationshipExtraCondition order by CustomizationLevel asc
[2010-08-11 11:19:58.7] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select * from EntityRelationshipRole order by CustomizationLevel asc
[2010-08-11 11:19:58.8] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select * from EntityRelationshipRelationships order by CustomizationLevel asc
[2010-08-11 11:19:58.8] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select * from ViewAttribute order by CustomizationLevel asc
[2010-08-11 11:19:58.8] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Select priv.*, privotc.ObjectTypeCode from Privilege priv
left outer join PrivilegeObjectTypeCodes privotc on (privotc.PrivilegeId = priv.PrivilegeId) order by ObjectTypeCode asc
[2010-08-11 11:19:58.8] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Select LanguageCode, PricingDecimalPrecision, SiteMapXml, FeatureSet from Organization
[2010-08-11 11:19:58.8] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>SELECT * FROM OrganizationLanguagePack WHERE IsEnabled = 1
[2010-08-11 11:19:58.8] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at DynamicMetadataCacheLoader.GetTimestampDataSet(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.GenerateTimestamp(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.AddVersionTable(DataSet ds, CrmDbConnection connection, IDbTransaction transaction)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select VersionNumber from EntityView order by EntityId
[2010-08-11 11:19:58.8] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at DynamicMetadataCacheLoader.GetTimestampDataSet(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.GenerateTimestamp(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.AddVersionTable(DataSet ds, CrmDbConnection connection, IDbTransaction transaction)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select VersionNumber from AttributeView order by AttributeId
[2010-08-11 11:19:58.9] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at DynamicMetadataCacheLoader.GetTimestampDataSet(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.GenerateTimestamp(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.AddVersionTable(DataSet ds, CrmDbConnection connection, IDbTransaction transaction)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select VersionNumber from LocalizedLabelView order by LocalizedLabelId
[2010-08-11 11:19:59.1] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at DynamicMetadataCacheLoader.GetTimestampDataSet(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.GenerateTimestamp(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.AddVersionTable(DataSet ds, CrmDbConnection connection, IDbTransaction transaction)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select VersionNumber from AttributeLookupValueView order by AttributeLookupValueId
[2010-08-11 11:19:59.1] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at DynamicMetadataCacheLoader.GetTimestampDataSet(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.GenerateTimestamp(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.AddVersionTable(DataSet ds, CrmDbConnection connection, IDbTransaction transaction)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select VersionNumber from AttributePicklistValueView order by AttributePicklistValueId
[2010-08-11 11:19:59.1] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at DynamicMetadataCacheLoader.GetTimestampDataSet(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.GenerateTimestamp(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.AddVersionTable(DataSet ds, CrmDbConnection connection, IDbTransaction transaction)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select VersionNumber from EntityRelationshipView order by EntityRelationshipId
[2010-08-11 11:19:59.1] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at DynamicMetadataCacheLoader.GetTimestampDataSet(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.GenerateTimestamp(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.AddVersionTable(DataSet ds, CrmDbConnection connection, IDbTransaction transaction)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select VersionNumber from RelationshipView order by RelationshipId
[2010-08-11 11:19:59.2] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at DynamicMetadataCacheLoader.GetTimestampDataSet(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.GenerateTimestamp(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.AddVersionTable(DataSet ds, CrmDbConnection connection, IDbTransaction transaction)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select VersionNumber from EntityRelationshipRoleView order by EntityRelationshipRoleId
[2010-08-11 11:19:59.2] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at DynamicMetadataCacheLoader.GetTimestampDataSet(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.GenerateTimestamp(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.AddVersionTable(DataSet ds, CrmDbConnection connection, IDbTransaction transaction)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select VersionNumber from EntityRelationshipRelationshipsView order by EntityRelationshipRelationshipsId
[2010-08-11 11:19:59.2] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.FillDataSet
at CrmDbConnection.FillDataSet(IDbDataAdapter dataAdapter, DataSet dataSet, String tableName)
at DynamicMetadataCacheLoader.PopulateDataSet(CrmDbConnection connection, IDbTransaction transaction, String dataSetName, ReadOnlyCollection`1 fillProperties)
at DynamicMetadataCacheLoader.GetTimestampDataSet(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.GenerateTimestamp(CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.AddVersionTable(DataSet ds, CrmDbConnection connection, IDbTransaction transaction)
at MultiOrgSharableMetadataCacheLoader.BuildDataSet(LoadMasks masks, CrmDbConnection connection, IDbTransaction transaction)
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>select VersionNumber from ViewAttributeView order by ViewAttributeId
[2010-08-11 11:19:59.5] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteNonQuery
at CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)
at CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
at CrmDbConnection.SetTransactionIsolationLevel(IsolationLevel il)
at CrmDbConnection.Close()
at DynamicMetadataCacheLoader.LoadDatSetFromDatabase(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>SET TRANSACTION ISOLATION LEVEL READ COMMITTED
[2010-08-11 11:20:00.0] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | MultiOrgSharableMetadataCacheLoader.SetSystemDataByBuildNumber
at MultiOrgSharableMetadataCacheLoader.SetSystemDataByBuildNumber(MetadataContainer systemContainer, String organizationBuildNumber, Guid organizationId)
at MultiOrgSharableMetadataCacheLoader.BuildContainerFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Multi-org sharable cache setting system metadata with build number 4.0.7333.113
[2010-08-11 11:20:00.4] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 11(MSCRM:-NotificationManager.NotificationWatcherThreadProc) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | NotificationService.GetConfigScopeNotifications
at NotificationService.GetConfigScopeNotifications(ConfigScope scope, Object organizationId, Int32[] events, DateTime lastChecked)
at NotificationService.GetNotifications(Object organizationId, Int32[] events, DateTime lastChecked)
at DBNotificationsProvider.GetNotifications(DateTime lastChecked)
at NotificationManager.NotificationWatcherThreadProc()
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart()
>SELECT OrganizationId, EventId, EventData, CreatedOn FROM Notification WHERE CreatedOn > '08/11/2010 09:19:15'
[2010-08-11 11:20:00.4] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 11(MSCRM:-NotificationManager.NotificationWatcherThreadProc) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at NotificationService.GetConfigScopeNotifications(ConfigScope scope, Object organizationId, Int32[] events, DateTime lastChecked)
at NotificationService.GetNotifications(Object organizationId, Int32[] events, DateTime lastChecked)
at DBNotificationsProvider.GetNotifications(DateTime lastChecked)
at NotificationManager.NotificationWatcherThreadProc()
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart()
>SELECT OrganizationId, EventId, EventData, CreatedOn FROM Notification WHERE CreatedOn > '08/11/2010 09:19:15'
[2010-08-11 11:20:00.5] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.InternalTryLookupEntry
at CrmCache`1.InternalTryLookupEntry(String key, TValue& value)
at CrmCache`1.TryLookupEntry(String key, TValue& value)
at CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key OverrideLabelDictionaryCache{7162a053-162c-4c63-bec2-dc5bf8145860}1031 was not found in cache OverrideLabelDictionaryCache
[2010-08-11 11:20:00.5] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | MetadataProcessObject.ExecuteQuery
at MetadataProcessObject.ExecuteQuery(IDbCommand command)
at MetadataProcessObject.RetrieveMultiple(SimpleQueryExpression queryExpression, ISqlExecutionContext context, Boolean retrieveFromTable)
at LabelDictionaryCacheLoader.LoadCacheData(Int32 languageCode, IOrganizationContext context)
at CrmMultiOrgCache`2.CreateEntry(TKey key, IOrganizationContext context)
at CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>SQL ExecuteQuery: SELECT LocalizedLabelId AS localizedlabelid,
LanguageId AS languageid,
ObjectId AS objectid,
ObjectColumnName AS objectcolumnname,
Label AS label,
CustomizationLevel AS customizationlevel FROM LocalizedLabel WHERE LanguageId = 1031 AND CustomizationLevel IN(Override, Delete) AND InProduction = 1
[2010-08-11 11:20:00.5] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at MetadataProcessObject.ExecuteQuery(IDbCommand command)
at MetadataProcessObject.RetrieveMultiple(SimpleQueryExpression queryExpression, ISqlExecutionContext context, Boolean retrieveFromTable)
at LabelDictionaryCacheLoader.LoadCacheData(Int32 languageCode, IOrganizationContext context)
at CrmMultiOrgCache`2.CreateEntry(TKey key, IOrganizationContext context)
at CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>SELECT LocalizedLabelId AS localizedlabelid,
LanguageId AS languageid,
ObjectId AS objectid,
ObjectColumnName AS objectcolumnname,
Label AS label,
CustomizationLevel AS customizationlevel FROM LocalizedLabel WHERE LanguageId = 1031 AND CustomizationLevel IN(Override, Delete) AND InProduction = 1
[2010-08-11 11:20:00.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.InternalTryLookupEntry
at CrmCache`1.InternalTryLookupEntry(String key, TValue& value)
at CrmCache`1.TryLookupEntryNoLock(String key, TValue& value)
at CrmMultiOrgCache`2.AddEntryFromLookupCallback(String key, TValue value, Object parameter)
at CrmCache`1.AddEntry(String key, TValue value, AddEntryCallback callback, Object callbackParameter)
at CrmMultiOrgCache`2.AddEntryFromLookup(String key, TValue value)
at CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key OverrideLabelDictionaryCache{7162a053-162c-4c63-bec2-dc5bf8145860}1031 was not found in cache OverrideLabelDictionaryCache
[2010-08-11 11:20:00.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.InternalAddDependencyKey
at CrmCache`1.InternalAddDependencyKey(String key)
at CrmCache`1.AddDependencyKeyNoLock(String key)
at CrmMultiOrgCache`2.AddEntryFromLookupCallback(String key, TValue value, Object parameter)
at CrmCache`1.AddEntry(String key, TValue value, AddEntryCallback callback, Object callbackParameter)
at CrmMultiOrgCache`2.AddEntryFromLookup(String key, TValue value)
at CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key OverrideLabelDictionaryCache{7162a053-162c-4c63-bec2-dc5bf8145860} was not found in cache OverrideLabelDictionaryCache
[2010-08-11 11:20:00.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.AddExactDependencyKey
at CrmCache`1.AddExactDependencyKey(String exactDependencyKey, CacheDependency parent)
at CrmCache`1.CreateRootDependency()
at CrmCache`1.InternalAddDependencyKey(String key)
at CrmCache`1.AddDependencyKeyNoLock(String key)
at CrmMultiOrgCache`2.AddEntryFromLookupCallback(String key, TValue value, Object parameter)
at CrmCache`1.AddEntry(String key, TValue value, AddEntryCallback callback, Object callbackParameter)
at CrmMultiOrgCache`2.AddEntryFromLookup(String key, TValue value)
at CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key OverrideLabelDictionaryCache was not found in cache OverrideLabelDictionaryCache
[2010-08-11 11:20:00.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.AddExactDependencyKey
at CrmCache`1.AddExactDependencyKey(String exactDependencyKey, CacheDependency parent)
at CrmCache`1.CreateRootDependency()
at CrmCache`1.InternalAddDependencyKey(String key)
at CrmCache`1.AddDependencyKeyNoLock(String key)
at CrmMultiOrgCache`2.AddEntryFromLookupCallback(String key, TValue value, Object parameter)
at CrmCache`1.AddEntry(String key, TValue value, AddEntryCallback callback, Object callbackParameter)
at CrmMultiOrgCache`2.AddEntryFromLookup(String key, TValue value)
at CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key OverrideLabelDictionaryCache was added to cache OverrideLabelDictionaryCache
[2010-08-11 11:20:00.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.AddExactDependencyKey
at CrmCache`1.AddExactDependencyKey(String exactDependencyKey, CacheDependency parent)
at CrmCache`1.InternalAddDependencyKey(String key)
at CrmCache`1.AddDependencyKeyNoLock(String key)
at CrmMultiOrgCache`2.AddEntryFromLookupCallback(String key, TValue value, Object parameter)
at CrmCache`1.AddEntry(String key, TValue value, AddEntryCallback callback, Object callbackParameter)
at CrmMultiOrgCache`2.AddEntryFromLookup(String key, TValue value)
at CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key OverrideLabelDictionaryCache{7162a053-162c-4c63-bec2-dc5bf8145860} was not found in cache OverrideLabelDictionaryCache
[2010-08-11 11:20:00.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.AddExactDependencyKey
at CrmCache`1.AddExactDependencyKey(String exactDependencyKey, CacheDependency parent)
at CrmCache`1.InternalAddDependencyKey(String key)
at CrmCache`1.AddDependencyKeyNoLock(String key)
at CrmMultiOrgCache`2.AddEntryFromLookupCallback(String key, TValue value, Object parameter)
at CrmCache`1.AddEntry(String key, TValue value, AddEntryCallback callback, Object callbackParameter)
at CrmMultiOrgCache`2.AddEntryFromLookup(String key, TValue value)
at CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key OverrideLabelDictionaryCache{7162a053-162c-4c63-bec2-dc5bf8145860} was added to cache OverrideLabelDictionaryCache
[2010-08-11 11:20:00.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.InternalAddEntry
at CrmCache`1.InternalAddEntry(String cacheKey, Object value, String[] dependencyKeys)
at CrmCache`1.AddEntryNoLock(String key, TValue value, String[] dependencyKeys)
at CrmMultiOrgCache`2.AddEntryFromLookupCallback(String key, TValue value, Object parameter)
at CrmCache`1.AddEntry(String key, TValue value, AddEntryCallback callback, Object callbackParameter)
at CrmMultiOrgCache`2.AddEntryFromLookup(String key, TValue value)
at CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key OverrideLabelDictionaryCache{7162a053-162c-4c63-bec2-dc5bf8145860}1031 was added to cache OverrideLabelDictionaryCache
[2010-08-11 11:20:00.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.InternalTryLookupEntry
at CrmCache`1.InternalTryLookupEntry(String key, TValue& value)
at CrmCache`1.TryLookupEntry(String key, TValue& value)
at BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key SystemLabelDictionaryCache1031 was not found in cache SystemLabelDictionaryCache
[2010-08-11 11:20:00.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | MetadataProcessObject.ExecuteQuery
at MetadataProcessObject.ExecuteQuery(IDbCommand command)
at MetadataProcessObject.RetrieveMultiple(SimpleQueryExpression queryExpression, ISqlExecutionContext context, Boolean retrieveFromTable)
at LabelDictionaryCacheLoader.LoadCacheData(Int32 languageCode, IOrganizationContext context)
at BasicCrmCache`2.CreateEntry(TKey key, IOrganizationContext context)
at BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>SQL ExecuteQuery: SELECT LocalizedLabelId AS localizedlabelid,
LanguageId AS languageid,
ObjectId AS objectid,
ObjectColumnName AS objectcolumnname,
Label AS label,
CustomizationLevel AS customizationlevel FROM LocalizedLabel WHERE LanguageId = 1031 AND CustomizationLevel = System AND InProduction = 1
[2010-08-11 11:20:00.6] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at MetadataProcessObject.ExecuteQuery(IDbCommand command)
at MetadataProcessObject.RetrieveMultiple(SimpleQueryExpression queryExpression, ISqlExecutionContext context, Boolean retrieveFromTable)
at LabelDictionaryCacheLoader.LoadCacheData(Int32 languageCode, IOrganizationContext context)
at BasicCrmCache`2.CreateEntry(TKey key, IOrganizationContext context)
at BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>SELECT LocalizedLabelId AS localizedlabelid,
LanguageId AS languageid,
ObjectId AS objectid,
ObjectColumnName AS objectcolumnname,
Label AS label,
CustomizationLevel AS customizationlevel FROM LocalizedLabel WHERE LanguageId = 1031 AND CustomizationLevel = System AND InProduction = 1
[2010-08-11 11:20:01.1] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.InternalTryLookupEntry
at CrmCache`1.InternalTryLookupEntry(String key, TValue& value)
at CrmCache`1.TryLookupEntryNoLock(String key, TValue& value)
at BasicCrmCache`2.AddEntryFromLookupCallback(String key, TValue value, Object parameter)
at CrmCache`1.AddEntry(String key, TValue value, AddEntryCallback callback, Object callbackParameter)
at BasicCrmCache`2.AddEntryFromLookup(String key, TValue value)
at BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key SystemLabelDictionaryCache1031 was not found in cache SystemLabelDictionaryCache
[2010-08-11 11:20:01.1] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.AddExactDependencyKey
at CrmCache`1.AddExactDependencyKey(String exactDependencyKey, CacheDependency parent)
at CrmCache`1.CreateRootDependency()
at CrmCache`1.InternalAddEntry(String cacheKey, Object value, String[] dependencyKeys)
at CrmCache`1.AddEntryNoLock(String key, TValue value, String[] dependencyKeys)
at BasicCrmCache`2.AddEntityFromLookupInternal(String key, TValue value)
at BasicCrmCache`2.AddEntryFromLookupCallback(String key, TValue value, Object parameter)
at CrmCache`1.AddEntry(String key, TValue value, AddEntryCallback callback, Object callbackParameter)
at BasicCrmCache`2.AddEntryFromLookup(String key, TValue value)
at BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key SystemLabelDictionaryCache was not found in cache SystemLabelDictionaryCache
[2010-08-11 11:20:01.1] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.AddExactDependencyKey
at CrmCache`1.AddExactDependencyKey(String exactDependencyKey, CacheDependency parent)
at CrmCache`1.CreateRootDependency()
at CrmCache`1.InternalAddEntry(String cacheKey, Object value, String[] dependencyKeys)
at CrmCache`1.AddEntryNoLock(String key, TValue value, String[] dependencyKeys)
at BasicCrmCache`2.AddEntityFromLookupInternal(String key, TValue value)
at BasicCrmCache`2.AddEntryFromLookupCallback(String key, TValue value, Object parameter)
at CrmCache`1.AddEntry(String key, TValue value, AddEntryCallback callback, Object callbackParameter)
at BasicCrmCache`2.AddEntryFromLookup(String key, TValue value)
at BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key SystemLabelDictionaryCache was added to cache SystemLabelDictionaryCache
[2010-08-11 11:20:01.1] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.InternalAddEntry
at CrmCache`1.InternalAddEntry(String cacheKey, Object value, String[] dependencyKeys)
at CrmCache`1.AddEntryNoLock(String key, TValue value, String[] dependencyKeys)
at BasicCrmCache`2.AddEntityFromLookupInternal(String key, TValue value)
at BasicCrmCache`2.AddEntryFromLookupCallback(String key, TValue value, Object parameter)
at CrmCache`1.AddEntry(String key, TValue value, AddEntryCallback callback, Object callbackParameter)
at BasicCrmCache`2.AddEntryFromLookup(String key, TValue value)
at BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context)
at LabelCache.TryLookupEntry(Int32 languageCode, Guid objectId, String objectColumnName, IOrganizationContext context)
at LabelCacheLabelCollection.TryGetActualLabel(Int32 languageCode, IOrganizationContext context)
at LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at PicklistAttributeMetadata.CreateOverrideListIfNecessary(Guid attributeId, Int32 displayMask, IMetadataCacheDataProvider metadata)
at PicklistAttributeMetadata.CheckPicklistOptions()
at PicklistAttributeMetadata.OnCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.NotifyCacheDataLoaded(DynamicMetadataCache cache, LoadMasks masks)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.BuildMetadataCacheFromDataSet(DataSet data, LoadMasks masks, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, Guid organizationId)
at DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context)
at DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Cache item with key SystemLabelDictionaryCache1031 was added to cache SystemLabelDictionaryCache
[2010-08-11 11:20:01.1] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | MetadataCache.LoadCache
at MetadataCache.LoadCache(IOrganizationContext context)
at MetadataCache.GetInstance(IOrganizationContext context)
at QueueDataAccess.GetEntityLogicalNameFromObjectTypeCode(Int32 objectTypeCode)
at QueueDataAccess.GetLookup(Object objectId, String objectIdName, Int32 objectDsc, Int32 objectTypeCode)
at <>c__DisplayClass2.<SelectEvents>b__0(Object[] values)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>Loaded MetadataCache. MetadataCacheConfig.LoadMethod = Database Actual LoadMethod = Database
[2010-08-11 11:20:01.1] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | QueueDataAccess.SelectEvents
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca: Selecting up to 2000 operations - 1 selected.
[2010-08-11 11:20:01.1] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 4 |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | PoolHandler.ProcessAsyncEvent
at PoolHandler.ProcessAsyncEvent(AsyncEvent asyncEvent)
at PoolHandler.InvokeHandlerInPool(Object state)
at _ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at _ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at _ThreadPoolWaitCallback.PerformWaitCallback(Object state)
>Processing Event Id: {B24D2D99-29A5-DF11-A859-000AE403DED8} Operation type: 1
[2010-08-11 11:20:01.1] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 4 |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | AsyncService.CreateCommand
at AsyncService.CreateCommand(Int32 operationType, IOrganizationConfiguration config)
at AsyncOperationCommandFactory.GetOperationCommand(AsyncEvent asyncEvent)
at AsyncHostHandler.Handle(AsyncEvent asyncEvent)
at PoolHandler.ProcessAsyncEvent(AsyncEvent asyncEvent)
at PoolHandler.InvokeHandlerInPool(Object state)
at _ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at _ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at _ThreadPoolWaitCallback.PerformWaitCallback(Object state)
>Created AsyncOperationCommand type: Microsoft.Crm.Asynchronous.EventOperation for Operation type: 1
[2010-08-11 11:20:01.1] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 4 |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | AsyncOperationCommand.Execute
at AsyncOperationCommand.Execute(AsyncEvent asyncEvent)
at AsyncHostHandler.Handle(AsyncEvent asyncEvent)
at PoolHandler.ProcessAsyncEvent(AsyncEvent asyncEvent)
at PoolHandler.InvokeHandlerInPool(Object state)
at _ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at _ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at _ThreadPoolWaitCallback.PerformWaitCallback(Object state)
>Executing AsyncOperationId: {B24D2D99-29A5-DF11-A859-000AE403DED8} AsyncOperationType: 1 Command: Microsoft.Crm.Asynchronous.EventOperation
[2010-08-11 11:20:01.2] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | WorkloadThrottler.TraceWorkloadThrottlingInformation
at WorkloadThrottler.TraceWorkloadThrottlingInformation(Guid organizationId, Int32 priority, Int32 waitIteration, Int32 orgCapacity, Int32 actualWorkDone)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WorkloadThrottlingInformation: WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca_OnSelect, {7162A053-162C-4C63-BEC2-DC5BF8145860}, 0, 0, 2000, 1
[2010-08-11 11:20:02.3] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 4 |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | AsyncOperationCommand.GetPluginType
at AsyncOperationCommand.GetPluginType(Guid pluginTypeId)
at EventOperation.InternalExecute(AsyncEvent asyncEvent)
at AsyncOperationCommand.Execute(AsyncEvent asyncEvent)
at AsyncHostHandler.Handle(AsyncEvent asyncEvent)
at PoolHandler.ProcessAsyncEvent(AsyncEvent asyncEvent)
at PoolHandler.InvokeHandlerInPool(Object state)
at _ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at _ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at _ThreadPoolWaitCallback.PerformWaitCallback(Object state)
>AsyncOperationCommand.GetPluginType: loading type '{582F2A68-E023-4600-B8F1-E0BCB6C330C1}'
[2010-08-11 11:20:02.3] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 4 |Category: Platform.Sdk |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmCache`1.TryLookupEntryAsObjectNoLock
at CrmCache`1.TryLookupEntryAsObjectNoLock(String key, Object& value)
at CrmSharedMultiOrgCache`2.TryLookupEntryCallback(String key, Object parameter, TValue& value)
at CrmCache`1.TryLookupEntry(String key, TryLookupEntryCallback callback, Object callbackParameter, TValue& value)
at CrmSharedMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
at PluginTypeCache.LookupEntry(Guid pluginTypeId, IOrganizationContext context)
at AsyncOperationCommand.GetPluginType(Guid pluginTypeId)
at EventOperation.InternalExecute(AsyncEvent asyncEvent)
at AsyncOperationCommand.Execute(AsyncEvent asyncEvent)
at AsyncHostHandler.Handle(AsyncEvent asyncEvent)
at PoolHandler.ProcessAsyncEvent(AsyncEvent asyncEvent)
at PoolHandler.InvokeHandlerInPool(Object state)
at _ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at _ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at _ThreadPoolWaitCallback.PerformWaitCallback(Object state)
>Cache item with key PluginTypeCache{7162a053-162c-4c63-bec2-dc5bf8145860}582f2a68-e023-4600-b8f1-e0bcb6c330c1 was not found in cache PluginTypeCache
[2010-08-11 11:20:02.9] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.InternalExecuteReader
at CrmDbConnection.InternalExecuteReader(IDbCommand command)
at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
at CrmDbConnection.ExecuteReader(IDbCommand command)
at DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>update AsyncOperationBase
set
HostId = 'WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca',
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 (UPDLOCK) where StateCode = 0 and DeletionStateCode = 0 order by Sequence asc)
[2010-08-11 11:20:02.9] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | QueueDataAccess.SelectEvents
at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca: Selecting up to 1999 operations - 0 selected.
[2010-08-11 11:20:02.9] Process:CrmAsyncService |Organization:7162a053-162c-4c63-bec2-dc5bf8145860 |Thread: 18(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | WorkloadThrottler.TraceWorkloadThrottlingInformation
at WorkloadThrottler.TraceWorkloadThrottlingInformation(Guid organizationId, Int32 priority, Int32 waitIteration, Int32 orgCapacity, Int32 actualWorkDone)
at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
at WorkloadThrottler.Execute(Int32 totalCapacity)
at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
at Timer.InvokeElapsed()
at TimerProcessor.ExecuteTimers(Object data)
at ThreadHelper.ThreadStart_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at ThreadHelper.ThreadStart(Object obj)
>WorkloadThrottlingInformation: WBCRM.MSCRMAsyncService.24c7c7d0-3720-4e63-ad36-ced68a3bf6ca_OnSelect, {7162A053-162C-4C63-BEC2-DC5BF8145860}, 0, 0, 1999, 0

Hallo Wolfgang,

da habe ich jetzt erst einmal nichts auffälliges sehen können. Das waren ja mit Sicherheit nicht alle Einträge in der Datei. Du solltest diese einmal nach dem Schlüsselwort error durchsuchen.
Um mir die Arbeit zu erleichtern, verwende ich ich immer dieses Tool von stunware, um mir die Tracefiles anzusehen.

Hallo Michael,

ist das so besser?
Dabei isr mir nicht klar welche Seite er nicht findet!?

at AsyncOperationCommand.Execute(AsyncEvent asyncEvent)
at AsyncHostHandler.Handle(AsyncEvent asyncEvent)
at PoolHandler.ProcessAsyncEvent(AsyncEvent asyncEvent)
at PoolHandler.InvokeHandlerInPool(Object state)
at _ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at _ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at _ThreadPoolWaitCallback.PerformWaitCallback(Object state)
>Exception while trying to execute AsyncOperationId: {10B1A039-34A5-DF11-A859-000AE403DED8} AsyncOperationType: 1 - System.Net.WebException: Fehler bei der Anforderung mit HTTP-Status 404: Not Found.
bei System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
bei System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
bei Microsoft.Crm.SdkTypeProxy.CrmService.Retrieve(String entityName, Guid id, ColumnSetBase columnSet)
bei Microsoft.Crm.Asynchronous.SdkTypeProxyCrmServiceWrapper.Retrieve(String entityName, Guid id, ColumnSetBase columnSet)
bei Microsoft.Crm.Asynchronous.SdkPluginDescriptionProvider.GetPluginTypeDescription(Guid pluginTypeId, IOrganizationContext context)
bei Microsoft.Crm.Caching.PluginTypeCacheLoader.LoadCacheData(Guid key, IOrganizationContext context)
bei Microsoft.Crm.Caching.CrmMultiOrgCache`2.CreateEntry(TKey key, IOrganizationContext context)
bei Microsoft.Crm.Caching.CrmSharedMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
bei Microsoft.Crm.Caching.PluginTypeCache.LookupEntry(Guid pluginTypeId, IOrganizationContext context)
bei Microsoft.Crm.Asynchronous.AsyncOperationCommand.GetPluginType(Guid pluginTypeId)
bei Microsoft.Crm.Asynchronous.EventOperation.InternalExecute(AsyncEvent asyncEvent)
bei Microsoft.Crm.Asynchronous.AsyncOperationCommand.Execute(AsyncEvent asyncEvent)

Hallo Wolfgang,

ja, deutlich besser.
Bei so einer Fehlermeldung des AsyncServices würde ich immer den MS-Support einschalten. Diesen ohne den Support zu finden dürfte ziemlich schwierig sein.

Hallo Michael,

ich habe mir die ganze Story noch einmal durchgelesen und habe dann in der DB DeploymentProperties den Servernamen mit :5555 ergänzt - und, da schau guck - es läuft.

Danke für die Unterstützung und Anregungen.
Das Bier und der Grünkohl im Kiepenkerl geht auf mich!