Deployment Issue from UiPath Studio to Orchestrator 2017.1

orchestrator
uipath

#1

We have recently configured UiPath Orchestrator 2017.1 and linked with UiPath Runtime (UiRobot.exe) via a Robot Key version 2017.1 and got the message that it is successfully configured. When I publish the file on Orchestrator. It fails with following error message

UiPath

Based on my findings from Google. It says above issue is a proxy issue buit for your information we are using .pac file and we tried adding the proxy on UiPath Robot settings file, UiPath Studio Configuration file and Web.config on Orchestrator Server but error message remains the same.

When I checked on Event Viewer on UiPath Orchestrator Server (Windows Server 2012 R2), following is the error message triggered after every minute.

System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string.
_ at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)_** **_ at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)_** **_ at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)_** **_ at System.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, String endMethod, Boolean isInternal)_** **_ at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)_** **_ at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult)_** **_ at System.Threading.Tasks.TaskFactory1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action1 endAction, Task1 promise, Boolean requiresSynchronization)_** **_--- End of stack trace from previous location where exception was thrown ---_** **_ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)_** **_ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)_** **_ at System.Data.Entity.Core.Objects.ObjectContext.<ExecuteInTransactionAsync>d__3d1.MoveNext()_
— End of stack trace from previous location where exception was thrown —
_ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)_
_ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)_
_ at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.d__91.MoveNext()_** **_--- End of stack trace from previous location where exception was thrown ---_** **_ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)_** **_ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)_** **_ at System.Data.Entity.Core.Objects.ObjectContext.<ExecuteStoreCommandInternalAsync>d__60.MoveNext()_** **_--- End of stack trace from previous location where exception was thrown ---_** **_ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)_** **_ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)_** **_ at UiPath.EntityFramework.Repositories.QueueProcessingRecordsRepository.<ExecuteSqlReportCommand>d__5.MoveNext()_** **_--- End of stack trace from previous location where exception was thrown ---_** **_ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)_** **_ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)_** **_ at UiPath.EntityFramework.Repositories.QueueProcessingRecordsRepository.<CalculateMinuteReports>d__1.MoveNext()_** **_--- End of stack trace from previous location where exception was thrown ---_** **_ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)_** **_ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)_** **_ at Abp.Threading.InternalAsyncHelper.<AwaitTaskWithPostActionAndFinally>d__1.MoveNext()_** **_--- End of stack trace from previous location where exception was thrown ---_** **_ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)_** **_ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)_** **_ at UiPath.Core.Services.Queues.QueueProcessingRecordsManager.<CalculateAllReports>d__2.MoveNext()_** **_--- End of stack trace from previous location where exception was thrown ---_** **_ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)_** **_ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)_** **_ at Nito.AsyncEx.AsyncContext.<>c__DisplayClass3.<Run>b__1(Task t)_** **_ at System.Threading.Tasks.Task.Execute()_** **_--- End of stack trace from previous location where exception was thrown ---_** **_ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)_** **_ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)_** **_ at Nito.AsyncEx.AsyncContext.Run(Func1 action)_
_ at UiPath.Core.BackgroundJobs.System.BaseSystemJob.RunSafeAsyncOperation(Task t, String operationName)_
ClientConnectionId:bad7dab6-0d5f-42e3-b813-fbfacf4fc056
Error Number:241,State:1,Class:16

UiPath Studio

  • Version. 2017.1.6535
  • .Net: 4.6.2
  • OS: Window 10

UiPath Orchestrator.

  • Version: 2017.1
  • OS. Window Server 2012 R2. and other standard database and software and plugins mentioned.

Appreciate your help, We have raised a ticket as well.


#2

Hi Amit!
Have you tried this:

Also, is it the same error when you try to publish any project or just a specific one?


#3

Hi Cosmin,
Thanks for your quick reply.

We have already tried this but the error message remains the same. As I said earlier in my email we are using .pac file to add the proxy which we had already added and restarted the service but unfortunately the error message remains the same.

Thanks and Regards,
Amit Bhatt


#4

its important to know if only the publish fails. if you run a job from orchestrator (you can upload a job manually on orchestrator) the robot will execute it?
what kind of proxy do you use, can you give us more details? what is that .pac file used for?


#5

Hi All,
This issue is resolved. We were trying to connect with HTTP Protocol hence it was blocking us to connect otherwise reset everything is fine.

We did not do any changes as such apart from HTTPS Bindings and adding Domain Certificate.