I have a process that runs every day to check to see if a report has been generated in a portal. I am using today’s date to select from a list of reports. The reports can show up any weekday randomly.
Sometimes the process fails (could not bring application to foreground). Robot is installed as a service and cannot figure out why this one and others occasionally fail with this error.
If the process fails it misses today’s date and can and does miss a report.
What are some recommended ways to retry the process before the date has passed and also IF it fails to get it to check the previous date or dates that were missed? This without running unnecessarily reports that have been downloaded.
This is an example of a list of reports where we will grab one that matches today’s date. The actual table is much longer. Sometimes there are more than one report on the same day.
