Dynamics Community Forum Thread Details

Input column missing in data flow

Hi everyone,

I'm working on integrating data with Dynamics 365 Business Central (BC) using KingswaySoft, and I'd like to share some insights on updating records.

Scenario:

Let's say you have a source system with a "calculateDiscountOnCreditMemos" field, and you want to update existing records in Dynamics 365 BC with this value.

But the Progress shows this error:

[Dynamics NAV Destination [2]] Error: An error occurred with the following error message: "System.AggregateException: One or more errors occurred. (SSIS Integration Toolkit for Microsoft Dynamics 365, v24.1.1.24301 - DtsDebugHost, v16.0.5467.0)
Stack Trace:
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at System.Threading.Tasks.Task.Wait()
at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Func`4 bodyWithLocal, Func`1 localInit, Action`1 localFinally)
at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IList`1 list, 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.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, Action`3 body)
at tco.knj(List`1 gpc)
at tco.knh(Int32 gpc, PipelineBuffer gpd)
at tco.yow(Int32 gpc, PipelineBuffer gpd)
at KingswaySoft.IntegrationToolkit.DynamicsNAV.NavDestinationComponent.ProcessInput(Int32 inputID, PipelineBuffer buffer)

System.Exception: OData service call returned an error: OData service call returned an error: {"error":{"code":"BadRequest","message":"Could not find a property named 'False' on type 'Microsoft.NAV.paymentTerm'. CorrelationId: bcc964fb-2ce0-42b9-b736-854d7b1cdeed."}}
Stack Trace:
at tco.knu(kjg gpc, String gpd)
at tcr.okt(List`1 gpc)
at tco.kjl.eao(List`1 gpc, ParallelLoopState gpd, Int64 gpe)
at System.Threading.Tasks.Parallel.<>c__DisplayClass31_0`2.<ForEachWorker>b__2(Int32 i, ParallelLoopState state)
at System.Threading.Tasks.Parallel.<>c__DisplayClass17_0`1.<ForWorker>b__1()
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)
at System.Threading.Tasks.Task.<>c__DisplayClass176_0.<ExecuteSelfReplicating>b__0(Object <p0>)".

Quick Links

Leaderboard