Hi UiPath family,
We are facing one issue, While process running bot is creating temp file(Before it was Input file) after processing some transaction the Input file becoming temp file and bot has to update the business exception but due to temp file bot not updating the status and went into infinite loop with same transaction item.
Please suggest me how to handle this situation to overcome this issue.
Can you show what kind of temp file bot is creating and your input file also explain a little more about the process. if possible add screenshot of the failure.
Hi @AJ_Ask ,
Thank you for quick response,
The input file is excel file initially later it will become temp file. bot not able to write status into that input file due to the input file become as temp file.
If you are using excel file and keeps open till every transaction is processed, this could happen.
One of the approach would be instead of opening file and reading row by row for every transaction, use Read range activity and get data into DataTable.
To update the result, use Write Cell Workbook activity to update just the status cell.
This way you won’t have to keep the excel file open.
Thanks,
Ashok 
You can use the Use Excel File & Read range to read the data in data table. Work on it.
Again use separate Excel scope to update the file using write range or write cell.
Hope this helps