Add queue item Exception: UiPath.Core.Activities.OrchestratorHttpException: Some values used for input might be in an incorrect format

queue
p_known

#1

Hello,

Our “robot” is processing a xls file (~35k rows/a day) and is filling up Orchestrator queue with some data from that file.
It is unable to insert string that contains single quotation character. Add queue item element crashes with an error:

Blockquote
Exception: UiPath.Core.Activities.OrchestratorHttpException: Some values used for input might be in an incorrect format. Please note that not all properties are compatible with older Orchestrator versions at UiPath.Core.Activities.BaseQueueActivity.ValidateResponse(NativeActivityContext context, HttpResponseMessage httpResponse, String responseContent) at UiPath.Core.Activities.AddQueueItem.ValidateResponse(NativeActivityContext context, HttpResponseMessage httpResponse, String content) at UiPath.Core.Activities.BaseQueueActivity.EndExecute(NativeActivityContext context, IAsyncResult result) at UiPath.Core.Activities.AsyncNativeActivity.BookmarkResumptionCallback(NativeActivityContext context, Bookmark bookmark, Object value) at System.Activities.Runtime.BookmarkCallbackWrapper.Invoke(NativeActivityContext context, Bookmark bookmark, Object value) at System.Activities.Runtime.BookmarkWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
Blockquote

Q1: Is inserting to Orchestrator queue SQL Injection free ? Because if one is using sql query with add param and not passing ItemInformation element directly than such error shouldn’t happen.

Q2. Is there any workaround for that? Is it possible to insert a string with a single quote into orchestrator queue like i.e. “John O’Brian”?

Q3: What is a best approach to handle recovery of add queue item? Is it possible to get information of the last element inserted into Orchestartor queue?
Get transaction item always gets elements as FIFO but I couldn’t find any details in documentation to confirm it is guaranteed and how to get item as LIFO. Can anyone please provide any detailed information about that?

Q4: It is possible to create custom activities. Is there any documentation, article ,code or anything about how to make a custom activity using context of configured orchestrator? I’d like to create my own activity to get info of last inserted queue element without consuming it.

I have found multiple question about that error and all without any answer:
13984
6931
9486


#2

Ad Q2.: It is not possible to put single comma into orchestrator queue. As I was told UIPATH team is working on that bug.
As a workaround im replacing a comma with double single comma (string.Replace("’","’’") ) before add queue item and replace it back after get transaction item ( string.Replace("’’","’") ).


#3

@qateam
Any update on this?


#4

This should be fixed in the next release, thank you.