Datatable has a value but throwing null reference

[Sudharsan_Ka]

Hello,

I have a task to use nested loop

In the second loop it is throwing the null reference exception but the datatable which i have used have rows and i have seen the row count and the particular row value in the message box

RemoteException wrapping System.NullReferenceException: Object reference not set to an instance of an object.
at UiPath.Core.Activities.ForEach`1.StartLoop(NativeActivityContext context)
at UiPath.Core.Activities.InterruptibleLoopBase.Execute(NativeActivityContext context)
at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

@yoichi @ppr

Regards
Sudharsan

[Yoichi]

HI,

Can you share your workflow or expression?
The Row.Item might be null.

Regards,

[ppr (Peter Preuss)]

@Sudharsan_Ka

seen the row count and the particular row value in the message box

we recommend to debug and using the different debug panels instead of message boxes…
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

when debugging (e.g. stepwise) then you cn trace where the variable becomes null. Maybe some adjustments on the variable scope is needed

[Sudharsan_Ka]

@Yoichi

The Row.Item might be null.

No, It has and Showing the values

[Yoichi]

Hi,

Which activity or expression throws exception? Can you share it?

Regards,

[mosa_sleeman (Mousa Suleiman)]

Please share your workflow details in order to help

[Sudharsan_Ka]

For each row in datatable @Yoichi @ppr

The weird thing is on the above steps it shows the values and while stepped into the for it is showing null

The scope of the variable is assigned to the parent sequence

Regards
Sudharsan

[ppr (Peter Preuss)]

check and play with the variable scope especially when involved within a for each…

[Sudharsan_Ka]

Now i have created a new variable for that filter , it is throwing this error @ppr

21.10.5+Branch.support-v21.10.Sha.369f46199a0fa6287d86ab2534b6896019db01bc

Source: For Each Row in Data Table

Message: Collection was modified; enumeration operation might not execute.

Exception Type: System.InvalidOperationException

RemoteException wrapping System.InvalidOperationException: Collection was modified; enumeration operation might not execute.
at System.Data.RBTree1.RBTreeEnumerator.MoveNext() at UiPath.Core.Activities.ForEach1.InternalExecute(NativeActivityContext context, IEnumerable values)
at UiPath.Core.Activities.ForEach`1.GetStateAndExecute(NativeActivityContext context, ActivityInstance completedInstance)
at System.Activities.Runtime.ActivityCompletionCallbackWrapper.Invoke(NativeActivityContext context, ActivityInstance completedInstance)
at System.Activities.Runtime.CompletionCallbackWrapper.CompletionWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

[ppr (Peter Preuss)]

@Sudharsan_Ka

Collection was modified; enumeration operation might not execute.

do not touch the looped collection e.g. removing, adding items

[Sudharsan_Ka]

@ppr

looped collection

Means??
I haven’t changed anything

[ppr (Peter Preuss)]

which things / actions are you doing within the failling for each row?

[Sudharsan_Ka]

Inside the for each i’m having another for each and inside that based on the condition the row.itemArray will be added in the datatable

[ppr (Peter Preuss)]

@Sudharsan_Ka

will be added in

@ppr

do not touch the looped collection e.g. removing, adding items

looks like modifying the same datatable which is involved within the for each

[Sudharsan_Ka]

[Sudharsan_Ka]

I’m using three different datatable

[Sudharsan_Ka]

And I’m using the Clear datatable inside the For each and that’s the problem.

Thank you @ppr @Yoichi @mosa_sleeman