Add maximum retry count to 1 without deleting the existing queue

News Tutorials
,
1

Hi All,

I hope this will help you to add a maximum retry count to 1 without deleting the existing queue.

Steps :

  1. If possible, create a new queue with the desired settings and transfer the queue items to the new queue. There is not an inbuilt way of transferring queue items, but it can easily be done with automation.
  2. If transferring queue items is not an option, then the retry mechanism can be turned off with a DB query.
  3. Back up your DB - very important!
  4. Open SQL Server Management Studio

Run the following Query:
Update [%Uipath Database Name%].dbo.QueueDefinitions
set MaxNumberOfRetries = 0 WHERE Name = ‘%Queue Name%’

For example the database name is UiPath and the queue one want’s to modify is named “TestQueue”. The command to be used is:

Update [UiPath].dbo.QueueDefinitions
set MaxNumberOfRetries = 0 WHERE Name = ‘your queue name’

Note:
Changing the Auto Retry option from No to Yes or vice versa in produced in 2021.10 orchestrator version
MaxNumberOfRetries = 0(Deafult)

3 Likes