HI @T0Bi ,
I think it is stuck at the ‘For Each Row in DT Unique Groups’ because I have created a loop start and loop end variable to calculate the time it takes for the loop to run.
Right after the loop, I have the write line activity that should give me the time it took for the loop to iterate through all the rows (There might be thousands of rows in the loop. Which is why I feel the robot thinks it is stuck).
After the Write Line activity, there is a write range activity followed by a read range activity.
Then the read range is fed into a for each loop again to scrape web data for each row.
When running the robot in debug mode, I can see the execution start.
Then as per the sequence, I should see the time for the loop to iterate from the write line activity. After which the excel file should be written and opened, followed by the browser launching and looping through each row from the new excel file and scraping the web data.
However, what I am seeing in the logs is the execution start. No output from the write line activity on the time time taken. But the excel file gets written and opened. The browser launches and starts scraping the data for each row in the new excel file.
After some time, the excel file gets opened again and a new browser is launched and data starts getting scraped from the 1st row again. That is why I think the robot thinks that it is still stuck in the loop but for some reason, the next steps start getting executed. Then once the robot finishes the loop, the next steps are executed again from the beginning.
I am having some trouble with web scraping part where the selectors aren’t working properly so the execution automatically stops when an error is encountered.
Even when the execution has stopped, I don’t see the output from the write line.
I hope this gives you an idea of why I think the robot is stuck.