Bulk Add queue items: Operation has timed out

Help Activities
, ,
1

Hi,

I have come across the issue with queue activity Bulk add queue item
**Bulk Add Queue Items-Add the data table to queue: The operation has timed out. **

Please help with this issue.
@Palaniyappan Thanks

2

Hi ,
The default wait time for bulk add queue items is 300 seconds if it is taking more time try increasing this number in the properties panel.
image

Thank You

3

Hi @sangeethaneelavannan1 please use the bulk queue item activity in retry scope

image
image552×650 13.5 KB

4

Hi @sangeethaneelavannan1,

First ensure that your datable is not more than 5000 rows. In my experiments with datatable more than 5000 rows with 9 or more columns, the Bulk Add Queue Items will have difficulties.

We always use “AllorNothing” when using Bulk Add Queue Items activity to ensure that the dispatcher has finished its work. Else, we know no items were added to queue, safe failure.

But why?
The Bulk Add Queue Items unlike Add Queue Item returns a json response consisting the posted data. So studio / robot using Bulk Add Queue Items with large datatables will not be capable to parse the returning json response from the Orchestrator.

@Tapan_Behera1 Retry will not help if the error is due to the above reason.

@balraj.krishnappa Timeout will only delay the error if the case is as described above.

What is the remedy then?
Our rule has been simple. If row count for the datatable is more than 4000 (as a buffer) then we use the Add Queue Item activity. For datatables lower than 4000 rows Bulk Add Queue Items works really well.

Read more here on the approach : Should queue items be uploaded manually or using a dispatcher for large volume of data to be fetched from a single CSV file - #5 by jeevith

5

TIL,

Thank You @jeevith for this information

6

I tried that but it is not working

7

Hi @jeevith ,

Thanks for your explanation.

I have only five rows in my data table.Then, what could be the reason for this issue?

8

Hi @sangeethaneelavannan1,

Now that we know it is not the quantity. The logical next steps are

  1. Check the Queue name is correctly set (you can check this by going to the Data Manger panel / Resources panel for previous studio versions)
    image

  2. If you are using Automation Cloud check if you are connected and licenced

    image
    image671×548 13.8 KB

  3. Check which folder you are currently in. Queues are containers within Modern Folders. If your Queue is not in the current scope of Studio folder then studio/robot cannot communicate with your Queue.
    You check this by

    image
    image768×1313 47.6 KB

If possible share a dummy column and rows data (your datatable) here and show the properties section of your Add Bulk Queue Item activity.

9

@sangeethaneelavannan1

Can you just try to add a single set of row to queue using Add queue item Activity? and make sure the issue is not with the connection with orchestrator

10

Hi @jeevith,

I have checked all the steps which you have mentioned. I

Screenshot 2022-10-15 093109
Screenshot 2022-10-15 0931091920×1028 249 KB

have attached the activity screenshot and sample xlsx
Screenshot 2022-10-15 093146
Screenshot 2022-10-15 0931461608×738 157 KB

P.S:I am using the latest version of studio 2022.20.1

11

Hi again @sangeethaneelavannan1,

Check if all your variables have the correct string values as well. Excel inputs support empty characters
Queuename, FolderName

One way to avoid it is by using the .Trim method in your activities

Add a variable in the out section of the Add Bulk Queue Items activity use Ctrl+k so that it automatically creates the correct variable type.

12

Hi @jeevith,

I have checked every possibility and changed the approach by adding add queue item activity, which is working fine. But I am also getting the same error with the get credential activity.
I have reconnected my robot with the orchestrator again. Still, I am getting the same.

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.