Skip to main content

Notifications

Announcements

No record found.

Dynamics Business Central migration forum
Suggested answer

Input column missing in data flow

Posted on by

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>)".
 
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 9,472 Most Valuable Professional on at
    Input column missing in data flow
    Hi
    This error occurs when you use the incorrect name for a property. Property names are case sensitive.
    Best
    GR

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans