Insert data in queue with Bulk add Queue items error

[Deep_HML (Mariame)]

Hello ,

I have an issue when trying to upload datatable to queue with Bulk Add Queue items activity , the error msg is “Operation returned an invalid status code ‘BadRequest’”
I guess the problem is with datatable size it contains +26k rows i had the idea to use for each but i didn’t know how to do it , maybe there is another solution any help please ?

Regards

[supriya117 (Supriya Allada)]

Hi @Deep_HML

Check if the datatable column names contain any (.). If the column name contain any dot(.), it will give the same error. Else try add queue item activity in the for each row in datatable activity with different column names.

Regards,
@supriya117

[Anil_G (Anil Gorthi)]

@Deep_HML

To confirm…did you try with only onw row of data? …first try with it…it might be that the columns names are not exactly matching or so…check those…

And yes the limit is 15k or so…

We can break the table into rows of 10k and add in 3 loops

So use for loop with Enumerable.Range(0,Cint(Math.Ceiling(dt.RowCount/10000))).ToArray and change type argument to integer

And inside loop to get each chunk use dt.AsEnumerable.Skip(currentitem*10000).Take(10000).CopyToDataTable

And use the chunkdt to load the queue

Hope this helps

Cheers

[supermanPunch (Arpan)]

Hi @Deep_HML ,

Maybe also take a look at the below post :

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

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. …

[arjunshenoy]

Hi @Deep_HML

Possible cause of this error could be due to the size of the data table you are trying to upload. If you try to upload each row as a queue item, it will take 7.2 hours even if you assume one row takes one second.

If you are sure that the datatable structure and colums are correct, you can split the table into batches & try uploading each batch. Try this query:

dt.AsEnumerable().Batch(1000))

Hope this helps,
Best Regards.

[Deep_HML (Mariame)]

Hello,
I double checked the columns are all normal and its worked before when data size was less than 15k

[Deep_HML (Mariame)]

Hello Anil,

I tried to do the for each but ‘Ceil’ is not declared i don’t know if it a fonction i need to upload or somth ??

Best Regards.

[Deep_HML (Mariame)]

Hello @arjunsjenoy,

Yes am sure of the datatable , so i need to do this query inside of a loop ?

Best Regards.

[arjunshenoy]

@Deep_HML

Yes, inside the for each loop, upload each batch created.

Best Regards.

[Deep_HML (Mariame)]

I did try but it seemed wrong the msg said that batch doesnt exists

[Anil_G (Anil Gorthi)]

@Deep_HML

Use math.ceiling in place of ceil

** Replace above as well **

Cheers

[arjunshenoy]

@Deep_HML

Change the activity TypeArgument to System.Data.Datatable, place a bulk queue upload activity inside the loop & pass item.ToArray()

Hope this helps,
Best Regards.