We want to implement a specific module that allows us to relaunch the items that end in Failed Application at the end of each process we execute.
For this we are exploring the way to launch an Update Query on the UiPath database, more specifically on the QueueItems table.
We have tried to change the status of the ReviewStatus field of the item from None (code in BBDD = 0) to Retried (code in BBDD = 3) but this option overwrites the status instead of transforming it.
Our desire is to be able to obtain the trace of the item and see the retries that have been applied to it:
Does anyone know how to solve this situation?Anyone who has implemented a module with the same functionality and who can contribute on how to develop a solution that allows us to automatically implement this process?
First of all, thank you very much for your interest in the question I raise.
I will try to explain myself again:
When we execute a process, we always retry all the items that end in Failed Application. Today this is an operation that we perform manually. For this we access Orchestrator and apply a series of filters on the view of the queues and View Transactions that allow us to select these items (Failed Application) and reload them in the queue.
When we do this manually, the item generates a trace with the different states in which its execution has ended. It can be seen on the screen:
I see the scenario now. Well, auto-retry on the Queue setting should take care of the ones that Failed with an Application exception. When you use Set Transaction Status to set the Failed-Aplication status on a queue item with auto-retry setup and when it still still has retries left, it will create a new queue item for you.
I would imagine it does not work like that for Business exceptions by design - those are supposed to be checked by someone before retrying.
Thus, if it is the question of retrying a Business-failed queue item, I would consider this a feature request (I think). I am not sure it can be currently done, probably because the automatic mechanism to link the queue items that are getting retried is not active for the Business-failed items.
I also searched our Orchestrator API and it doesn’t seem to have an end point for that. It is possible to change the review status, but not the retry.