How to upload one Lakh records to Orchestrator Queues using UiPath Studio?

How to upload one Lakh records to Orchestrator Queues using UiPath Studio?

Hi @BReddy_m

You can try with Bulk Add Queue activity

Check out the Docs and Video link

Regards
Gokul

Hello @BReddy_m

You need to use BulkAddQueueItem activity to add items to queue.

Thanks

If we have more than one lakh records in datatable, will it impact the performance while using “Bulk Add Queue Items” Activity.?

As per my understanding of course there should be a delay to load all 1lakh items. Because mostly in the backend of that activity also it will be loading like a loop.

Thanks

Yes, We can use “Bulk Add Queue Items” Activity, But it will degrade the perfomance while uploading more than One Lakh records in to Queue, How can we improve the performance in this case?

Please note that a maximum of 15000 lines are accepted by the UiPath Orchestrator. If this limit is reached, an error will be thrown.

So, count how many lines you have in one of your queue items.
Then divide 15000 by the count of your queue item lines. → This will be the limit of your added queue items while using Bulk Add Queue Items activity.

Rule of thumb, lower down a little bit the number of added queue items to make sure you are not crossing the 15000 lines.

Let us know if this helped.