For each row - object reference not set to an instance of an object

Learning Hub Academy Feedback
1

Hello there,
can anyone help, please? I am doing an exercise for UiPath Advanced Level 3.
Mainly creating a dispatcher to read an excel file and upload the transaction queue.
Please note that I already created a new queue in the orchestrator with the same name.
Error message is : For each row: object reference not set to an instance of an object.

image
image1692×805 116 KB

2

apparently you data table don’t get any value, in range propertie,set “” to get the entire sheet, and try again, and make sure you are reading the correct sheet
@Hadeel_Al-Dowsh

3

@fernando_zuluaga thank you for your reply; however, it’s still not working.

image
image1899×895 162 KB

4

let me watch the properties in read range activity please

5

the error is inside the for each, so something is empty inside of a property of the items…

6

Hey, I guess I figured it out as I was missing something in the properties thanks for your note. but I got now this message:

image
image1647×617 52.9 KB

7

now, let us watch the add queue item properties, maybe you are missing some thing as well

8

image
image1338×601 99.1 KB

9

in QueueName propertie in_Config(herearethenameofyourqueuefromconfigfile).ToString

10

timeouts are what they mean… or you have some firewall blocking or a network very slow, try putting more time in add queue item timeout.

11

Sorry I don’t know what do you mean. I was told to write the name matching the queue name set in the orchestrator!

12

Tried that still didn’t worry, sorry!

13

so you must be having some firewall blocking and we cannot help :frowning: you are sure all is fine with your orchestrator? can you access it using a web browser?

14

Yes, all is fine. Not sure what’s going on, but I will keep trying :slight_smile:
thank you for your help anyways