Bulk Add Queue Items: bulkA Queue Items Parameters must not be null Error code: 0

I’m facing an issue relate to bulk add Queue items.
I created the “QueueA” on Queue on Orchestrator, and my datatable has a row.
But I can’t push it on Queue.

You can check if your data table variable is in the correct scope.

Apparently, it’s empty, so probably is an issue regarding the population of the data table

I checked the DataTable as Count it. And It has one row.

Hi. I assume your DataTable has the required column of “Reference”. If this is the case then check if any of the other column names contains a “.”(dot)
I haven’t looked into the reason, but apparently the keys in specificcontent can’t contain a dot.

7 Likes

Reference is not required. It is optional. If it exists it will be used to populate the Reference field of the Queue Item.

Right click Bulk Add Queue Items and then Toggle Breakpoint. Then click the Debug button.

When it pauses at the breakpoint, go to the panel on the left and find the dt_QueueA datatable. Expand it and find Rows and see what the count is. Also, what are the column names?

1 Like

Thanks @oscone, this has resolved my similar problem. I’ve set my queue to receive unique ref. After I change the column name which contains dot, the activity works fine.

1 Like

Thanks @postwick . I stand corrected, the reference-column is off-cause not required. Most of my queues have unique reference, so my main problem is allways the reference-column. But that is just my bad habit :slight_smile:

Adding comment here as I was able to resolve the issue.

By adding column name in the first row of the excel from where the datatable was received resolved my issue.

if you have the Error “bulkAddQueueItems Parameters must not be null”.
you can try this.

  1. Validate your DT, that doesn’t exist values empty or Null.
  2. Next step is try upload items to Queue but with few columns or values.
  3. Validate Formats on the activity.
  4. Param Reference is not required.

image

Great job :+1:

Hi, I am having a similar issue when I attempt to Bulk Add Queue Items. My DataTable is populated and my queue is being accessed. However, when I run the process, Bulk Add Queue Items, throws the error;

Bulk Add Queue Items: bulkAddQueueItemsParameters must not be null Error code: 0

I’ve tried replacing any empty cells in my Excel with “” and I’ve tried to do a Regex for the same thing, but no luck. I’ve also updated all packages.

Would anyone know how to fix this?

I can go back to adding each row of my dt to the queue individually. However, I would prefer if I could get it to work this way.

Thanks :slight_smile:

Hi @Quang_Th_nh_Nguy_n

  1. Make sure your data table column name doesn’t have any special characters other than space and _.
    2.Then Make sure your Orchesrtator folder name has passed in the properties.
    3.Make sure Queue Name in Orchestrator and in code doesn’t have any extra spaces before & after the queue name.

Happy Automation :+1: