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
Anil_G
ashokkarale
vrdabberu
Pujitha_Ande
Ajay_Mishra
Yoichi
anjani_priya
postwick
Marisa_Ontiveros1
J0ska