Bulk Add Queue items Activity - Timeout issue

Help Something Else
1

I am using a Bulk queue item add activity with a timeout of 3 minutes. The bot is supposed to add 8000+ rows of items but keeps faulting after adding few. This happens within 3 minutes and the bot throws an exception before the timeout is completed.
Is the issue related to amount of data in the datatable which is being added or the timeout? And how do I fix this?

Error message: Operation returned an invalid status code ‘524’

2

Hi @siddhi.r.wandre ,

Could you please share the exception thrown by the bot?

3

Sounds like both. It’s timing out because of the number of records. Have you tried increasing the timeout?

4

Hi @siddhi.r.wandre

Can you try the below by using chunk the datatable

image
image900×1122 52.7 KB

Sequence.xaml (13.8 KB)

Hope it helps!!

5

Hi @siddhi.r.wandre

Cheers!!

6

Operation returned an invalid status code ‘524’

7

Because of the Large number of rows adding to the queues, this timeout happening, to rectify this you have to split the data and then add the data to the queues.

Here is the workflow to split the data and adding into queue, check this for your reference,

image
image900×1122 52.7 KB

Sequence.xaml (13.8 KB)

Hope you understand!! @siddhi.r.wandre

8

I did something with outlook timeouts with large numbers of mails:

  • timeout too short → error
  • timeout too long → wasting time if there actually is something wrong.

So I calculated the timeout (based on some done measurements) in direct relation to the number of items. Might be useful.

In your use-case I’d do both: dynamic timeout based on # of records, as well as breaking up the bulk load in smaller batches of for example 50-100 records and iterate through that.