Error in automation

Hi,

I am working with this automation Main.xaml (48.0 KB) while working with data tables.

And facing the below error. Can anyone help me out?

output.txt (2.7 KB).

Thanks

Well, it would be easy to read your error if you copy paste your error in the post.

1 Like

03/13/2021 12:06:08 => [Debug] Debug started for file: Main
03/13/2021 12:08:38 => [Error] If - Check any row exist or not | Mapping Via Booking Amount : Column ‘Train_ID_Booking_Amount + [client_transaction_id] + booking_amount’ does not belong to table DataTable.
03/13/2021 12:08:38 => [Error] Recon: Column ‘Train_ID_Booking_Amount + [client_transaction_id] + booking_amount’ does not belong to table DataTable.
03/13/2021 12:08:38 => [Error] Sequence: Column ‘Train_ID_Booking_Amount + [client_transaction_id] + booking_amount’ does not belong to table DataTable.
03/13/2021 12:08:38 => [Error] If - Check any row exist or not | Mapping Via Booking Amount : Column ‘Train_ID_Booking_Amount + [client_transaction_id] + booking_amount’ does not belong to table DataTable.
03/13/2021 12:08:38 => [Error] RemoteException wrapping System.ArgumentException: Column ‘Train_ID_Booking_Amount + [client_transaction_id] + booking_amount’ does not belong to table DataTable.
at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at lambda_method(Closure , DataRow )
at System.Linq.Enumerable.Any[TSource](IEnumerable1 source, Func2 predicate)
at lambda_method(Closure , DataRow )
at System.Linq.Enumerable.WhereEnumerableIterator1.MoveNext() at System.Linq.Enumerable.Count[TSource](IEnumerable1 source)
at lambda_method(Closure , ActivityContext )
at Microsoft.VisualBasic.Activities.VisualBasicValue1.Execute(CodeActivityContext context) at System.Activities.CodeActivity1.InternalExecuteInResolutionContext(CodeActivityContext context)
at System.Activities.Runtime.ActivityExecutor.ExecuteInResolutionContext[T](ActivityInstance parentInstance, Activity1 expressionActivity) at System.Activities.InArgument1.TryPopulateValue(LocationEnvironment targetEnvironment, ActivityInstance activityInstance, ActivityExecutor executor)
at System.Activities.RuntimeArgument.TryPopulateValue(LocationEnvironment targetEnvironment, ActivityInstance targetActivityInstance, ActivityExecutor executor, Object argumentValueOverride, Location resultLocation, Boolean skipFastPath)
at System.Activities.ActivityInstance.InternalTryPopulateArgumentValueOrScheduleExpression(RuntimeArgument argument, Int32 nextArgumentIndex, ActivityExecutor executor, IDictionary2 argumentValueOverrides, Location resultLocation, Boolean isDynamicUpdate) at System.Activities.ActivityInstance.ResolveArguments(ActivityExecutor executor, IDictionary2 argumentValueOverrides, Location resultLocation, Int32 startIndex)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

Error is in this part :

If condition:

DailyBookingDT.AsEnumerable.Where(Function(d) Not(TrainBookingDT.AsEnumerable.Any(Function(t) t(“Train_ID_Booking_Amount + [client_transaction_id] + booking_amount”).ToString.Replace(“.”,“”).Trim.Equals(d(“TRAN_ID_BOOKING_AMOUNT + [CLIENT TRANSACTION ID] + BOOKING_AMOUNT”).ToString.Replace(“.”,“”).Trim)))).Count > 0

[Error] If - Check any row exist or not | Mapping Via Booking Amount : Column ‘Train_ID_Booking_Amount + [client_transaction_id] + booking_amount’ does not belong to table DataTable.

I have checked that The column ‘Train_ID_Booking_Amount + [client_transaction_id] + booking_amount’ is in the data table

Put ‘Train_ID_Booking_Amount + [client_transaction_id] + booking_amount’ this value in a message box and print before the if condition.
check the message box output and compare with excel. That will show you the difference.

Thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.