"Object reference not set to an instance of an object"

Help
1

Hello there! I am trying to follow up the advanced lessons and there’s a part asking me to do a For each Row inside a Transactions.slsx, the guide ask to try and run it, i assume that it does work but whenever I try it its giving me that error ( tittle)

2

Hi @Leonardo_Diaz

can you attach a screenshot of the specific activities responsible for the error?

Regards,
Reda

3

error
error1345×675 64.3 KB

This is whats been show up as an error and as for activities what i am doing is:

Creating a sequence
Read range ( Selecting the correct file and sheet , as showed in the guide there’s no range)

For each row (the dt_transactions its a System.datatable.datatable)

the guide its asking me to also create a Add queue item but its first time i tried it so i dunno if what i am typing in it its correct or not the guide just said to add a name to it

4

Do you have dt_transactions as the output of the Read Range Activity?

5

No, its empty i just tried to use the dt_transactions there and it throws me this

error2
error21091×555 42 KB

6

Ok, I suppose the output property in the read range was empty, meaning that the read range activity wasn’t filling any dataTable inside your workflow.

So after solving this now we have the dataTable read from the excel and the problem now is in the collection property in the input of the Add Queue Item activity, can you expand the collection and attach a screenshot of it, because there is a column that should be in the input but it is not provided.

7

As for the Collection i d

error2
error21347×663 63.1 KB
o have information inside of it but yet, nothing here is whats inside of

8

my answer splitted up sorry

" As for the Collection i do have information inside of it but yet nothing, here is whats inside of"

9

So as the error states, it’s either you don’t have the column OnUsCheck in your dataTable or it is misspelled in the excel, can you check this out please.

1 Like
10

I had an extra space in the second string but now its throwing me this:

error2
error21349×663 65.2 KB

11

I assume it has to do with the Queue name but as i said before i never used this so i have no idea what to type on it, just a string? or it has to be a Var? as a string? i really dont know

12

  1. You need to Create an account in orchestrator : platform.uipath.com

  2. Connect your machine to a robot in it following these steps : There is no key in orchestrator - #5 by reda

    3 .Create a Queue in the queue tab using the name TransactionQueue