Queue Reference question?

[RPA708]

I’ve checked the Reference box in creating a queue, created a unique reference in Add Queue Items with Looping through my database data table id’s with a For Each and assigning CurrentRow(“id”).ToString.
It is then assigning all my data table id’s to my queue transactions.
I’ve gone ahead and then assigned both of the lists to List of Strings.
Im then comparing the Lists for an uncommon id and getting a value. Number 13.
My question is how do i assign the id’s to the reference and after the initial id’s have been created when I make additional id’s to my “database id’s” only adding the different value?
Or is there an easier way to do this…?
Thanks in advance

[svillalobos (Sebastian Villalobos)]

Hi,

I think question may be answered on this post. Otherwise, let us know.

How to use Queue Unique Reference?

I’m trying to load a queue with some items, and I am trying to store the reference as the ID number of the transaction so that I can use that reference in the future, to know if the Queue already has that item. How do I store the ID Number as the reference. I am totally confused overall about the Queue reference, so any explanations would be appreciated. A nice picture, explaining in detail how the queue reference works would be awesome. I already have my Queue set up for Unique references in O…

In the orchestrator queue you can flag that only unique reference are allowed to be added.

[Jobin_Joy]

Hi @RPA708

Welcome to UiPath Forum.

Adding references to transaction item is enforced to be unique at the queue level. This feature is enabled when creating the queue and applies to all transactions except deleted or retried ones.

Main reason reason behind adding reference is, if a duplicate reference is encountered while adding items to a queue, the job fails with a Faulted status and displays the Execution error: UiPath.Core.Activities.OrchestratorHttpException: Error creating Transaction. Duplicate Reference. error message in the Job Details window.

Coming back to your question, to assign ids/or unique keys as a reference you can to generate it just before executing the ‘Add Queue Item’ activity and if you are adding additional ids(reference), the queue item will be added if it’s not duplicate.

Hope this will be useful. Thank you.

[RPA708]

After some digging I found a solution on this post:
Continue on error

Thank you gentlemen for your assistance.

[svillalobos (Sebastian Villalobos)]

Glad you were able to find the answer to your question.

Welcome to the UiPath Community

[Jobin_Joy]

Hi @RPA708

Glad to hear that your issue has been resolved. Thank you.

[RPA708]

Cheers, Thank you!