Bij het downloaden van boekingsregels uit meerdere Exact Online-administraties krijg ik de volgende foutmelding:
One or more errors occurred.
Could not retrieve the value of an additional column with name ‘GLAccountType’ of table ‘ExactOnlineREST.FinancialTransaction.TransactionLinesBulk’.
The GL account with ID ‘9e4a6416-6cc9-4a6b-a3fd-b5f0f9f36c82’ in division 3,272,347 was established to be unknown very recently.
Could not retrieve the value of an additional column with name ‘GLAccountType’ of table ‘ExactOnlineREST.FinancialTransaction.TransactionLinesBulk’.
The GL account with ID ‘48af027a-81bb-4d67-9b79-8b1fcda8aab4’ in division 3,272,347 was established to be unknown very recently.
…
De callstack is:
at Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Boolean isRecoverable, String poolIdentityId, String url, Nullable`1 partyUid, String partitionCode, String tableName)
at Invantive.Basics.InvantiveSystemException..ctor(GlobalState owner, ExecutionOptions executionOptions, String validationCode, String errorMessage, String kindRequest, String stackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Boolean isRecoverable, String poolIdentityId, String partitionCode, String tableName)
at Invantive.Data.Providers.ExactOnline.ExactOnlineGlAccounts.GetGlAccountInformationById(GlobalState owner, ExecutionOptions executionOptions, IDmlProvider backingProvider, Int32 divisionNumber, Guid glAccountId, SqlExecutionStep sqlExecutionStep)
at Invantive.Data.Providers.ExactOnline.ExactOnlineProvider.A(GlobalState, ExecutionOptions executionOptions, String, JToken, AdditionalResultInformation, ObjectDefinition, SqlExecutionStep sqlExecutionStep)
at Invantive.Data.Providers.ExactOnline.ExactOnlineRestProvider.j.a(GlobalState, ExecutionOptions executionOptionsIn, SqlExecutionStep sqlExecutionStepIn, ObjectDefinition, JToken, String, AdditionalResultInformation, NamedArray, JsonDatabaseColumnDefinitionCollection, JsonDatabaseColumnDefinition)
at Invantive.Data.Providers.OData.ODataProvider.FillInPseudoColumnsDuringProcess(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ObjectDefinition objectDefinition, JToken token, NamedArray newRow, JsonDatabaseColumnDefinitionCollection fields, AdditionalResultInformation additionalInfo, HashSet`1 selectFields)
at Invantive.Data.Providers.OData.ODataProvider.F.A(ValueTuple`2 rt, ParallelLoopState parallelLoopState, Int64)
at Invantive.Basics.ParallelUtility.<>c__DisplayClass1_0`1.<ForEachWithAggregatedExceptions>b__0(TSource tSource, ParallelLoopState parallelLoopState, Int64 index)
at System.Threading.Tasks.Parallel.<>c__DisplayClass43_0`2.<PartitionerForEachWorker>b__1(IEnumerator& partitionState, Int64 timeout, Boolean& replicationDelegateYieldedBeforeCompletion)
at System.Threading.Tasks.TaskReplicator.Replica.Execute()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
at System.Threading.Tasks.ThreadPoolTaskScheduler.TryExecuteTaskInline(Task task, Boolean taskWasPreviouslyQueued)
at System.Threading.Tasks.Task.InternalRunSynchronously(TaskScheduler scheduler, Boolean waitForCompletion)
at System.Threading.Tasks.Parallel.PartitionerForEachWorker[TSource,TLocal](Partitioner`1 source, ParallelOptions parallelOptions, Action`1 simpleBody, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, ParallelOptions parallelOptions, Action`3 body)
at Invantive.Basics.ParallelUtility.ForEachWithAggregatedExceptions[TSource](GlobalState owner, ExecutionOptions executionOptions, IEnumerable`1 source, ParallelOptions parallelOptions, Action`3 body, Boolean shuffle, Boolean useCancellationTokenFromExecutionOptions, Boolean keepGoingOnError)
at Invantive.Data.Providers.OData.ODataProvider.ExtractRowsFromJsonData(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ObjectDefinition objectDefinition, QueryObject queryObject, ParameterList parameters, List`1 rows, String basePath, List`1 allFieldTypes, JToken dataToken, JsonDatabaseColumnDefinitionCollection fields, AdditionalResultInformation additionalInfo, String partitionCode, HashSet`1 selectFields, String url)
at Invantive.Data.Providers.OData.ODataProvider.ReadDataFromJsonToken(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, JToken token, ExecutionStatistics executionStatistics, String basePath, List`1 allFieldTypes, List`1 rows, ObjectDefinition objectDefinition, JsonDatabaseColumnDefinitionCollection fields, QueryObject queryObject, ParameterList parameters, Int64& rowsRetrieved, AdditionalResultInformation additionalResultInformation, String url, String partitionCode, HashSet`1 selectFields)
at Invantive.Data.Providers.ExactOnline.ExactOnlineRestProvider.GetAndReadTextFromServiceResponse(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, List`1 rows, String basePath, List`1 allFieldTypes, String url, String partitionCode, ObjectDefinition objectDefinition, JsonDatabaseColumnDefinitionCollection fields, QueryObject queryObject, ParameterList parameters, Int32& pagesRetrieved, Int64& rowsRetrieved, AdditionalResultInformation additionalInfo, String callSafeNameOverrule, Boolean allowRetry, Boolean preventRetryOnAuthenticationFailure, HashSet`1 selectFields, ExecutionStatistics& executionStatistics, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions)
at Invantive.Data.Providers.ExactOnline.ExactOnlineRestProvider.FetchDataOnePartition(GlobalState owner, ExecutionOptions executionOptions, String serviceUrl, String partitionCode, String basePath, List`1 allFieldTypes, ObjectDefinition objectDefinition, JsonDatabaseColumnDefinitionCollection fields, QueryObject queryObject, ParameterList parameters, SqlExecutionStep sqlExecutionStep, String callSafeNameOverrule, HashSet`1 selectFields)+MoveNext()
at System.Linq.Enumerable.SelectManySingleSelectorIterator`2.MoveNext()
at Invantive.Data.GenericProvider.ClientSideFilterNamedArrayRows(GlobalState owner, ExecutionOptions executionOptions, IEnumerable`1 namedArrayRows, DatabaseColumnDefinitionCollection retrievedFields, Int32 requestedFieldCount, Dictionary`2 allToVisibleColumns, Dictionary`2 filters)+MoveNext()
at Invantive.Data.ParallelSelectManyEnumerator`2.Read(GlobalState owner, ExecutionOptions executionOptions, TSource source)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.AsyncStateMachineBox`1.MoveNext(Thread threadPoolThread)
at System.Threading.Tasks.AwaitTaskContinuation.RunOrScheduleAction(IAsyncStateMachineBox box, Boolean allowInlining)
at System.Threading.Tasks.Task.RunContinuations(Object continuationObject)
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetExistingTaskResult(Task`1 task, TResult result)
at Invantive.Data.ThreadUtility.Delay(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, TimeSpan delay, String messageCodeOrigin, String partitionCode, String tableName, Int32 consecutiveSleeps)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.AsyncStateMachineBox`1.MoveNext(Thread threadPoolThread)
at System.Threading.Tasks.AwaitTaskContinuation.RunOrScheduleAction(IAsyncStateMachineBox box, Boolean allowInlining)
at System.Threading.Tasks.Task.RunContinuations(Object continuationObject)
at Invantive.Basics.ThreadBasicUtility.Delay(GlobalState owner, ExecutionOptions executionOptions, TimeSpan delay, CancellationToken cancellationToken, String messageCodeOrigin, String partitionCode, String tableName, Int32 consecutiveSleeps)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.AsyncStateMachineBox`1.MoveNext(Thread threadPoolThread)
at System.Threading.Tasks.AwaitTaskContinuation.RunOrScheduleAction(IAsyncStateMachineBox box, Boolean allowInlining)
at System.Threading.Tasks.Task.RunContinuations(Object continuationObject)
at System.Threading.Tasks.Task.DelayPromise.CompleteTimedOut()
at System.Threading.TimerQueueTimer.Fire(Boolean isThreadPool)
at System.Threading.ThreadPoolWorkQueue.Dispatch()
at System.Threading.PortableThreadPool.WorkerThread.WorkerThreadStart()
Request ID is 0HN2OAOMOV050:00000001.
Tabelnaam is ExactOnlineREST.FinancialTransaction.TransactionLinesBulk.
De onderliggende opvraging is:
https://start.exactonline.nl/api/v1/3272347/financial/GLAccounts?$select=ID,Type,BalanceSide,BalanceType,Compress,IsBlocked,RevalueCurrency,SearchCode,TypeDescription,UseCostcenter,UseCostunit,VATCode,Division&$skiptoken=guid'7ec3a91a-43a3-4c78-b059-6005a589571f'