Deleting a Transaction Item In Progress

[LarsFeilberg (Lorry)]

Hello Community - Is there any way to Delete a Transaction Item which is In Progress?

I find it very tedious having to wait 24 hour before deleting it. Especially, if the Queue has Unique Reference. Furthermore, a small feature such as being able to remove (not just delete) a Transaction Items completely from a Queue would be awesome!
Cheers.

[LarsFeilberg (Lorry)]

Also - having the possibility to merge queues would be beneficial.

[Stephu]

Did you found a solution?

[LarsFeilberg (Lorry)]

Yes, you can delete a Transaction Item that is in Progress by using the Set Transaction State activity.

However, you can unfortunately not completely delete a Transaction Item in a queue …

[Shawn_Ngoh]

What do you mean you cannot completely delete a transaction item? What happens when you set in progress queue item to New and then delete that queue item?

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @LarsFeilberg and @Stephu,

Not exactly sure if you are looking for this. There is a workaround, which we use both on development and production queues. It works like a charm. There is no official function with orchestrator or in the studio connected to the orchestrator to delete in progress items.

We use the attended robot as developers to quickly delete in progress items. In production, we run this by providing the required queue name to an unattended robot.

Here is the workout solution :

Why is there STILL no way to delete an In Progress Queue Item?!

We (@otico and I) are recent converts from BluePrism. In BP an in progress queue item can easily be first stopped / aborted and then it can be deleted by the user. The database / queue will retain these queue items. This saved us a lot of time when debugging both during development and production. However, in UiPath we faced the same issue as metioned by @postwick @nilschr and others. @bcorrea this is possible, it is just not built-in within UiPath orchestrator GUI. We looked at this thread …

Hope this helps!

[NIVED_NAMBIAR (NIVED N)]

@jeevith
I think the Postpone Transaction Activity help in this case,
Postpone Transaction helps to postpone the queue item then by which we can delete the queue items using Delete Queue items activity.

Correct me if i am wrong

Tagging @Shawn_Ngoh @LarsFeilberg

Regards,
Nived N

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @NIVED_NAMBIAR,

We looked at this thread and we want to help with a workaround. Our approach is -

1. Get Queue Items : Get all your queue items with status “InProgress” - Inumerable output
2. For each QueueItem (Inumerable) - Set Transaction Status to “Failed” with a given Reason in properties tab
3. Get Queue Items : Get all your queue items with status “Failed” - Inumerable output
4. For each QueueItem (Inumerable) - Delete Queue Item

It does not matter if we use Postpone or any other status which allows us to delete the item within the context of the proposed workflow because, we know we want to get only in-progress items and that we want to delete the item by either setting the item to failed, postponed or new status in Step 1 and 4 respectively.

---

An improvement to the proposed approach would be a using a time filter to ensure that the queue items being retrieved are for a given time window which have in-progress as status.

Example : Lets say a process runs at 6 AM and has multiple items in-progress and we run the process again at 12 Pm and has 2 more failure and in progress items. It on the developer to correctly use the time filter when getting queue items with in-progress status.

---

As I mention in the linked post that we should be aware of the business process itself. Do not use this approach when a robot is running. My experience with this method has been nothing but positive. When we have multiple thousand of transaction every day it is very crucial to keep the queue clean and tidy.

I hope UiPath will make this feature officially available to all orchestrator instances somewhere down the line.

[NIVED_NAMBIAR (NIVED N)]

Thanks @jeevith for sharing

[andrew.pate]

This page Managing Queues in Studio indicates changing the deadline on an item is way to set its status to New. So by setting the deadline in the past and the postpone in the future with the Postpone Transaction Item activity, transactions can be set back to ‘New’.

If you then do a second pass, and get all these queueItems again, that you set to ‘New’ status you can now use the Delete Queue Items activity to delete them.

However Get Queue Items activity has a 100 item limit (rollover Pagination >> Top) so if your deleting lots you may need to add some pagination.QueueCleaner.zip (6.8 KB)

[K1N5H1R0 (Joaquin Quiros)]

Unfortunately there is no way within Orchestrator to delete an ‘In Progress’ queue item, but via code you can do this:

1. Get all the ‘In Progress’ queue items
2. Set the status all of those to ‘Failed’
3. Get all the ‘Failed’ queue items
4. Delete all the ‘Failed’ queue items

[AmithGowda (Amith Hanumegowda)]

While UiPath has not implemented a way to delete Queue items stuck in InProgress queue items easily, they have an option to set threshold to Abandon the In Progress queue items. So, one can set the hours to as minimum of just 1 Hour. This will auto set the status to abandoned after an hour and help remove any InProgress transactions, instead of waiting for 24 hours (which is still a default).