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!
Try to restart the Uipath
robot from services
Hope this helps
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.
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 :
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)
Step by step guide :