Currently i’m developing a process that extracts data from an Excel sheet for further manipulation.
I created a small sequence that has a Connect, Execute Query, and Disconnect stage.
When executing this sequence multiple times in quick succession, I get the error “Job stopped with an unexpected exit code: 0x000000FF” (Type: SystemException)
This does not happen every time. Waiting a longer period of time can allow the sequence to run normally, but this is not always the case ( i.e even after waiting 20 seconds the robot will still fail on the ‘Connect’ action).
The string is as such: “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=”+Filepath+";Extended Properties="“Excel 12.0 Xml;HDR=YES”";"
With Oledb set as ProviderName.
I am thinking of building a Try-Catch with a delay of 30 seconds should it fail, but this seems like a band-aid solution.
For additional reference, this process was previously built using Blue Prism, and running OLEDB consecutive times there seemed to work fine, with the same parameters (the process is being rebuilt for UiPath).
Any help or suggestions on how to tackle this issue would be much appreciated!
Thanks in advance,