We have a scenario where an agent on multiple nodes is accessing same database table to process the case. How do we make sure one case is picked by only one agent for processing. How do we do exception handling in this case?
If you are able to use a standard agent and queue up the items to be processed, the auto queue management functionality can be used to lock the queue items so only one agent can process the case at a time.
I'm not sure the best way to do it with an advanced agent. You would need to have a way to mark which ones have picked up and lock them. Maybe another developer can respond if they have addressed similar scenarios in their environment.