Hello,
This is a bit of a strange issue as it only affects the process sometimes, but when it does it affects it for quite a while which means that no work can be completed for the whole day.
I have a process which uses an Excel file for configuration settings. This allows the staff who the process completes the work for to update the Excel file regularly to change the settings of the robot without having to contact us. The sheet they update most often is a Rota sheet, which determines which staff are working that day and therefore who the robot should assign work to. On most days, the process can complete with no issues.
On some days though, the process fails at the beginning as it cannot find a column in the collection, despite this column clearly existing on the worksheet. There does not seem to be any reason or circumstance that connects the instances where this fails.
The process takes around 45 minutes to run, and so sometimes the process fails due to the system it interacts with running slow or crashing overnight. The process runs overnight, with the first run beginning at 00:30, and repeating every half an hour until 6am. Once the process has run successfully, the subsequent runs are skipped. When this error occurs, every run that night is affected, but by the time we get to the office in the morning, the issue cannot be reproduced.
It is always the same column that produces the error.
Has anyone ever experienced anything similar and has any ideas/solutions?
