Bulk Add Queue Items: Operation returned an invalid status code ‘524’
I work on a project, this consists of reading Excels files, the resulting data is the one I load with 2 Bulk Add Queue Items (one for each excel). In that load to the Work Queue I see that error, load 11596 items and out of nowhere I see that error.
Additionally, the Bulk Add Queuing I use has the Process all independently option selected on your Commit Type property, because my queue has the Single Reference option enabled to ensure that no duplicate queuing is entered.
I’m sorry I can’t upload images, but I’m a new user.
Welcome to the forum
We could 524 Code take as a timeout. Maybe segmenting the data using smaller chunks can help.
What recommendation do you give me to segment my data? , as decia cargo 2 data table, one will have 9000 records and the other about 4000.
We can start with a split on-half data and then check in which direction we want to fine-tune
Try with these steps and let us know for further clarification
Restart your studio and UiPath orchestrator
Increase mentioning TIMEOUTMS property in BULK ADD QUEUE ITEMS activity
Mention in milliseconds
Like 60000 which is one minute
Pass first half of the records from datatable
Say if you have 100 records send 50 first Datarow with one bulk add queue item activity and then next fifty
- first use a assign activity like this
dt_1 = Dt.AsEnumerable().Take(50).CopyToDataTable()
And other assign activity like this
dt_2 = Dt.AsEnumerable().Skip(50).CopyToDataTable()
These two dt_1 and dt_2 are two variables of type system.data.datatable
Now use two bulk add queue items activities and pass dt_1 and dt_2 to each of the activities and try
Hope this helps
As per error it is a timeout error so try to increase the timeout.
Bulk add queue items support upto 15000 records I believe…but better to maintain 10k…and your records are already under limit…so shpuld be good…
Timeout increasemight aolve the issue
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.