when i run same bot manually its not giving me repeated records i dont why…
But whenever i run it from orchestrator, its writing the repeated records into excel sheet
I tried with , unique reference but its giving me error
Error:
Operation returned an invalid status code 'BadRequest'
at UiPath.Core.Activities.TaskExtensions.ThrowIfNeeded(Task task, Boolean suppresThrowException)
at UiPath.Core.Activities.Orchestrator.BaseOrchestratorClientActivity.ThrowIfNeeded(AsyncCodeActivityContext ctx, Task task, Boolean suppresThrowException)
at UiPath.Core.Activities.Orchestrator.BaseOrchestratorClientActivity`1.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity`1.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
i already scheduled the performer whenever new data will get add into the queue
and i am writing the data into same excel sheet, if there’s no excel sheet on my system then it will write the data using “write range acitivity” and after that it will append the new data into the same excel sheet.
I had added append range into “Process Transaction” block
Bad request states that, server is not able to handle or the required input is not passed to the server. May be the size required or the bulk string you are passing is not validated by the orchestrator I guess
Can you check that bro once