Unfortunately, the error below keep coming out when running automation involving huge amount of repetition of certain process.
Read data (one time only) from excel
Do automation based on input data from excel
I’ve already add kill process for the excel.exe and replaced the new excel file with the same content from the old excel file. The error keep coming out…Anyone know what going on or if you have any suggestion to solve this error??
unfortunately i cant share the workflow as it against company policy. But basically I only use read range for excel and do automation using for each loop of the excel data.
Thats all, nothing much but below is the version of the activity package I’ve used.
Could you try introducing a small delay (1s) between reading the data and processing it? Just as a test if it would stop the error from occurring.
Also, there are two read range activities - one for the Excel Application Scope and one that can work without it. Could you specify which one causes the error (and maybe try with the other one)?
Lastly, could you check your project on a light version of your source Excel file (new file with little data) just to see if it is not causing the issue in itself.
Hi, I already tried both ways to read the excel file (with Excel Application Scope and without). This error happens when around 150th automation run. However, with small data there is no issue but when it reaching around 100+ of data, the error will appear.
Then I decided to NOT use any excel related activity, the input data (excel file) I’ve converted to text file and use for each loop for every line. The error still occurred when it reached 100+.
Is using try-catch the only possible way to solve this issue? I hope the exception handling can resume the for each loop when exception happen.
Is there any chance you can create a new project that reproduces the issue but doesn’t contain any sensitive information you would not be able to share? It would help a lot if I could run the project on my machine to see if it also reproduces for me.