We have BOT performance tracker (Excel) that needs to be update the status of each transaction (success/failed/exception) by BOT at the end of each transaction.
Multiple performer bot is processing the single queue items and those bots will try to update the file at same time.
Since multiple bots are trying to access the file at same time the bot was unable to update the tracker and the process is not moving further
How to update same file by multiple bots without any issues?
Sorry, I couldn’t understand what exactly do with below points
There is no such locking mechanism.
You can use some sort of locking mechanism on your own. Like
→ Create a notepad file with a status “Completed”. This file can be accessible by other 2 robots.
→ In a while loop (look for this file and status).
→ Once the file is found, break the while loop and proceed with the next activities.
Consider your robots to be humans… I know… SciFi stuff but still.
What happens if 2 persons work on the same document?
Scenario 1: if only one entity (human or robot) can edit a document, then the next one should wait untill it is his/her/its turn. So what Nived linked above: build a locking mechanism / detection, and have a bot wait for its turn to write. For example: a looped try/catch writing the document. If failed, wait 3 seconds, then try again, otherwise exit the loop.
Scenario 2: make your target documents shared, so multiple entities can write and save at the same time. Often excel is used, and excel can be easily set to allow multiple users to edit.
Scenario 2 of course being the easy way out, if your documents support this.
a looped try/catch writing the document. If failed, wait 3 seconds, then try again, otherwise exit the loop ->>>> Can you give me sample xaml file for this activity?
After work, sure… (posting on coffee break ;))
Update:
This is a rough setup:
Mind that this does allow for an infinite loop, so you need to implement some max number of tries in it as well. Else your bot is waiting indefinately if somebody deletes a document or keeps it opnened before the weekend without shuting down.
Thank you very much
Create a single automation that updates the Excel file. This automation will pull from a queue. Other automations put items into that queue telling it which file to update and what data to write.
Yeah but that would be the smart way to do it… We can’t have that 
Hello @Sathish_Kumar_S
Have you checked the possibility of using an excel in the sharepoint which can be accessed parallelly? I think it can solve the issue.
Yoichi
Gautham_Pattabiraman
Anil_G
lrtetala
ashokkarale
Angel_Meseguer_piqueras
FINNNNNNNN
kardelencihangir
ayumi.ouchi
Gabriele_Radici