Deployment Issue from UiPath Studio to Orchestrator 2017.1

[amitbhatt55 (Amit Bhatt)]

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

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.

[ovi (Viorela Preda)]

Hi Amit!
Have you tried this:

Proxy blocking Orchestrator

Hello, On the robot machine, open Internet Explorer → go to Internet Options → Connections → LAN settings. Add the proxy server and port (i think that you already done this). You should be able to open Orchestrator server from the robot machine. Afterwards go to UiPath installation folder and search for UiRobot.exe.config. Open it and go to the bottom of the settings file and add/change following under <configuration> tag <configuration> <system.net> <defaultProxy> <proxy …

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

[amitbhatt55 (Amit Bhatt)]

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

[Gabriel_Tatu]

@amitbhatt55

_ at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, B

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?

[amitbhatt55 (Amit Bhatt)]

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.