// Id: #5686
using Services.DealerServices;
var dealerServicesSyncService = Activate<IDealerServicesSyncService>();
await dealerServicesSyncService.DownloadCases();
| CurrentCulture | |
| RecurringJobId | |
| RetryCount | |
| Time | |
An exception occurred during performance of the job.
Invalid column name 'SourceSystem'. Invalid column name 'CaseType'. Invalid column name 'CompanyId'. Invalid column name 'CompletedOn'. Invalid column name 'ContactUserId'. Invalid column name 'CustomerExternalId'. Invalid column name 'CustomerName'. Invalid column name 'CustomerType'. Invalid column name 'ExternalId'. Invalid column name 'FutureBrandPartner'. Invalid column name 'LastSyncedAt'. Invalid column name 'ModifiedOn'. Invalid column name 'NonAffiliatedBrandExternalId'. Invalid column name 'NonAffiliatedBrandName'. Invalid column name 'Origin'. Invalid column name 'OwnerName'. Invalid column name 'OwnerType'. Invalid column name 'OwnerUserId'. Invalid column name 'PrimaryContactEmail'. Invalid column name 'SourceCaseTypeCode'. Invalid column name 'SourceOriginCode'. Invalid column name 'SourceStageCode'. Invalid column name 'SourceStateCode'. Invalid column name 'SourceStatusCode'. Invalid column name 'SourceSystem'. Invalid column name 'Stage'. Invalid column name 'State'.
Microsoft.Data.SqlClient.SqlException: Invalid column name 'SourceSystem'. Invalid column name 'CaseType'. Invalid column name 'CompanyId'. Invalid column name 'CompletedOn'. Invalid column name 'ContactUserId'. Invalid column name 'CustomerExternalId'. Invalid column name 'CustomerName'. Invalid column name 'CustomerType'. Invalid column name 'ExternalId'. Invalid column name 'FutureBrandPartner'. Invalid column name 'LastSyncedAt'. Invalid column name 'ModifiedOn'. Invalid column name 'NonAffiliatedBrandExternalId'. Invalid column name 'NonAffiliatedBrandName'. Invalid column name 'Origin'. Invalid column name 'OwnerName'. Invalid column name 'OwnerType'. Invalid column name 'OwnerUserId'. Invalid column name 'PrimaryContactEmail'. Invalid column name 'SourceCaseTypeCode'. Invalid column name 'SourceOriginCode'. Invalid column name 'SourceStageCode'. Invalid column name 'SourceStateCode'. Invalid column name 'SourceStatusCode'. Invalid column name 'SourceSystem'. Invalid column name 'Stage'. Invalid column name 'State'. at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToDictionaryAsync[TSource,TKey,TElement](IQueryable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToDictionaryAsync[TSource,TKey,TElement](IQueryable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer, CancellationToken cancellationToken) at Services.DealerServices.Intake.DesignServiceCaseUpserter.UpsertAsync(DealerServiceSource source, IReadOnlyList`1 records, Boolean prune, Func`3 resolveCompanyIds, CancellationToken ct) in C:\Agents\Indeal\_work\r2\a\_Axiom-na_axiomAPI\Services\DealerServices\Intake\DesignServiceCaseUpserter.cs:line 47 at Services.DealerServices.DealerServicesSyncService.DownloadCases() in C:\Agents\Indeal\_work\r2\a\_Axiom-na_axiomAPI\Services\DealerServices\DealerServicesSyncService.cs:line 90 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
Triggered by DelayedJobScheduler
Retry attempt 2 of 2: Invalid column name 'SourceSystem'. Invalid colu…
An exception occurred during performance of the job.
Invalid column name 'SourceSystem'. Invalid column name 'CaseType'. Invalid column name 'CompanyId'. Invalid column name 'CompletedOn'. Invalid column name 'ContactUserId'. Invalid column name 'CustomerExternalId'. Invalid column name 'CustomerName'. Invalid column name 'CustomerType'. Invalid column name 'ExternalId'. Invalid column name 'FutureBrandPartner'. Invalid column name 'LastSyncedAt'. Invalid column name 'ModifiedOn'. Invalid column name 'NonAffiliatedBrandExternalId'. Invalid column name 'NonAffiliatedBrandName'. Invalid column name 'Origin'. Invalid column name 'OwnerName'. Invalid column name 'OwnerType'. Invalid column name 'OwnerUserId'. Invalid column name 'PrimaryContactEmail'. Invalid column name 'SourceCaseTypeCode'. Invalid column name 'SourceOriginCode'. Invalid column name 'SourceStageCode'. Invalid column name 'SourceStateCode'. Invalid column name 'SourceStatusCode'. Invalid column name 'SourceSystem'. Invalid column name 'Stage'. Invalid column name 'State'.
Microsoft.Data.SqlClient.SqlException: Invalid column name 'SourceSystem'. Invalid column name 'CaseType'. Invalid column name 'CompanyId'. Invalid column name 'CompletedOn'. Invalid column name 'ContactUserId'. Invalid column name 'CustomerExternalId'. Invalid column name 'CustomerName'. Invalid column name 'CustomerType'. Invalid column name 'ExternalId'. Invalid column name 'FutureBrandPartner'. Invalid column name 'LastSyncedAt'. Invalid column name 'ModifiedOn'. Invalid column name 'NonAffiliatedBrandExternalId'. Invalid column name 'NonAffiliatedBrandName'. Invalid column name 'Origin'. Invalid column name 'OwnerName'. Invalid column name 'OwnerType'. Invalid column name 'OwnerUserId'. Invalid column name 'PrimaryContactEmail'. Invalid column name 'SourceCaseTypeCode'. Invalid column name 'SourceOriginCode'. Invalid column name 'SourceStageCode'. Invalid column name 'SourceStateCode'. Invalid column name 'SourceStatusCode'. Invalid column name 'SourceSystem'. Invalid column name 'Stage'. Invalid column name 'State'. at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToDictionaryAsync[TSource,TKey,TElement](IQueryable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToDictionaryAsync[TSource,TKey,TElement](IQueryable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer, CancellationToken cancellationToken) at Services.DealerServices.Intake.DesignServiceCaseUpserter.UpsertAsync(DealerServiceSource source, IReadOnlyList`1 records, Boolean prune, Func`3 resolveCompanyIds, CancellationToken ct) in C:\Agents\Indeal\_work\r2\a\_Axiom-na_axiomAPI\Services\DealerServices\Intake\DesignServiceCaseUpserter.cs:line 47 at Services.DealerServices.DealerServicesSyncService.DownloadCases() in C:\Agents\Indeal\_work\r2\a\_Axiom-na_axiomAPI\Services\DealerServices\DealerServicesSyncService.cs:line 90 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
Triggered by DelayedJobScheduler
Retry attempt 1 of 2: Invalid column name 'SourceSystem'. Invalid colu…
An exception occurred during performance of the job.
Invalid column name 'SourceSystem'. Invalid column name 'CaseType'. Invalid column name 'CompanyId'. Invalid column name 'CompletedOn'. Invalid column name 'ContactUserId'. Invalid column name 'CustomerExternalId'. Invalid column name 'CustomerName'. Invalid column name 'CustomerType'. Invalid column name 'ExternalId'. Invalid column name 'FutureBrandPartner'. Invalid column name 'LastSyncedAt'. Invalid column name 'ModifiedOn'. Invalid column name 'NonAffiliatedBrandExternalId'. Invalid column name 'NonAffiliatedBrandName'. Invalid column name 'Origin'. Invalid column name 'OwnerName'. Invalid column name 'OwnerType'. Invalid column name 'OwnerUserId'. Invalid column name 'PrimaryContactEmail'. Invalid column name 'SourceCaseTypeCode'. Invalid column name 'SourceOriginCode'. Invalid column name 'SourceStageCode'. Invalid column name 'SourceStateCode'. Invalid column name 'SourceStatusCode'. Invalid column name 'SourceSystem'. Invalid column name 'Stage'. Invalid column name 'State'.
Microsoft.Data.SqlClient.SqlException: Invalid column name 'SourceSystem'. Invalid column name 'CaseType'. Invalid column name 'CompanyId'. Invalid column name 'CompletedOn'. Invalid column name 'ContactUserId'. Invalid column name 'CustomerExternalId'. Invalid column name 'CustomerName'. Invalid column name 'CustomerType'. Invalid column name 'ExternalId'. Invalid column name 'FutureBrandPartner'. Invalid column name 'LastSyncedAt'. Invalid column name 'ModifiedOn'. Invalid column name 'NonAffiliatedBrandExternalId'. Invalid column name 'NonAffiliatedBrandName'. Invalid column name 'Origin'. Invalid column name 'OwnerName'. Invalid column name 'OwnerType'. Invalid column name 'OwnerUserId'. Invalid column name 'PrimaryContactEmail'. Invalid column name 'SourceCaseTypeCode'. Invalid column name 'SourceOriginCode'. Invalid column name 'SourceStageCode'. Invalid column name 'SourceStateCode'. Invalid column name 'SourceStatusCode'. Invalid column name 'SourceSystem'. Invalid column name 'Stage'. Invalid column name 'State'. at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToDictionaryAsync[TSource,TKey,TElement](IQueryable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToDictionaryAsync[TSource,TKey,TElement](IQueryable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer, CancellationToken cancellationToken) at Services.DealerServices.Intake.DesignServiceCaseUpserter.UpsertAsync(DealerServiceSource source, IReadOnlyList`1 records, Boolean prune, Func`3 resolveCompanyIds, CancellationToken ct) in C:\Agents\Indeal\_work\r2\a\_Axiom-na_axiomAPI\Services\DealerServices\Intake\DesignServiceCaseUpserter.cs:line 47 at Services.DealerServices.DealerServicesSyncService.DownloadCases() in C:\Agents\Indeal\_work\r2\a\_Axiom-na_axiomAPI\Services\DealerServices\DealerServicesSyncService.cs:line 90 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
Triggered by recurring job scheduler