Read Range Issue - Remote Job Stopped Working

[kamlesh1 (Kamlesh)]

Hi Team,

We are facing an issue in read range activity of workbook.
Issue description : Sometimes read range is giving remote job stopped working error and in this scenario bot is not getting stopped it is getting stuck. We are expecting the normal behavior of the bot during system failure bot should stop execution but it is not getting stopped.

Kindly find the attached screenshot and let us know how to handle this issue?
Thanks in advance!

Regards,
Kamlesh

[Gokul001 (Gokul Balaji)]

Hi @kamlesh1

Try to restart the Uipath robot from services

Hope this helps

Regards
Gokul

[kamlesh1 (Kamlesh)]

Hi Gokul,

Your approach would be done manually. But, I am asking is there any approach that we can use in the code to handle this system failure.

Regards,
Kamlesh

[rohith.prabhu]

Hello @kamlesh1 ,

If the excel file you are reading has huge data then it is observed that Read Range will give this error.

An alternative approach to resolve this issue would be to use Excel as datasource and query the results from datasource. Find more about the Same here below :

How to use Excel as datasource and execute SQL Query?

Hi Team, I am trying to connect Excel as datasource, but not able to connect. I did some research and found following post. But still it is not helpful getting same error as mentioned. I have attached the excel file. I am looking for correct connection string for xlsx or xls and SQL query. Source.xlsx (8.6 KB) Kindly assist.

Step by step guide :

How to use excel sheet data as a database in UiPath - RPA Learners

Regards,
Rohith