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:
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)
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:
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(“‘’”,“'”) ).
Any update on this?
This should be fixed in the next release, thank you.
I too m facing the same issue on our orchestrator. anybody has any solution for this ?? Also im trying to create a support ticket on this but not able to. can anybody help ??
I had same issue and resolved it by changing Orchestrator Queue “Unique reference” to No.
Thanks for solution problem solved
I had a same issue with add Queue item which creating a Duplicate reference and which the above solution from @Mohan_R my issue got resolved.
I don’t know the details of your processes but most of the time the solution is to handle duplicate reference error rather than changing queue configuration.
Usually a reference is an id of some case and queue is unique to prevent of processing same element multiple times. Violating that, may not only be a waste of processing time but may cause an unwanted and unexpected problems.
Re posting my doubt on adding Queue Items,
I am getting this below error, when i do not want any unique reference (I left the parameter - did not add anything), How to fix this. Is it mandatory to give unique reference, but i dont think so, otherwise it would have give compile time error.
likely created by IncludeExceptionDetailInFaults=true,
whose value is:
UiPath.Core.Activities.OrchestratorHttpException: Error creating Transaction. Reference is required for Unique Reference Queues. Error code: 1850
If I add any unique reference, I am facing issues,
Scenarios: If i want to add two Queue Items then, it is adding first one only, but not the second one. i hope this is due to unique reference. for this scenario do we need to change the reference each time in order work this ???
Hi All, I got to know why the issue was happening in the first issue i had raised. While creating Queue in Orchestrator, I selected unique reference as yes. so when ever i am not passing the unique reference it is giving error.
For the second question, we need to create a unique reference each time, so that we can use later case. Here unique reference can be anything, i.e. could be mix of two paramater of one queue transaction or any thing. but we need to make sure that it will never duplicate in future.
I hope this will help some one if anyone facing some issue like this.