Hello,
We encoutering a problem when connecting to remote workspace.
In R Interactive Console the following error appears:
Connecting to R Workspace failed.
Reason: HTTP error while creating session on the machine 'hostname_masked'. Exception: The remote server returned an error: (400) Bad Request.
Interactive Window is disconnected from R session.
The Host Broker Log is:
[2019-02-25 14:40:16Z] <Microsoft.R.Host.Broker.Security.TlsConfiguration> (I):
Certificate issued by CN=cert_masked
[2019-02-25 14:40:16Z] <Microsoft.R.Host.Broker.Security.TlsConfiguration> (I):
Certificate issued to CN=cert_masked
[2019-02-25 14:40:16Z] <Microsoft.R.Host.Broker.Interpreters.InterpreterManager> (T):
Auto-detecting R ...
[2019-02-25 14:40:16Z] <Microsoft.R.Host.Broker.Interpreters.InterpreterManager> (W):
No compatible R interpreters found
[2019-02-25 14:40:16Z] <Microsoft.R.Host.Broker.Interpreters.InterpreterManager> (I):
1 interpreters configured:
[1] : MSSQL R Services at "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQL01\R_SERVICES"
[2019-02-25 14:40:16Z] <Microsoft.AspNetCore.Hosting.Internal.WebHost> (D):
Hosting starting
[2019-02-25 14:40:16Z] <Microsoft.AspNetCore.Hosting.Internal.WebHost> (D):
Hosting started
[2019-02-25 14:40:21Z] <Microsoft.AspNetCore.Server.Kestrel> (D):
Connection id "0HLKR4R4VKBEK" started.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Hosting.Internal.WebHost> (I):
Request starting HTTP/1.1 PUT https://hostname_masked:5444/sessions/REPL_0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g_ application/json; charset=utf-8 68
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Builder.RouterMiddleware> (D):
Request did not match any routes.
[2019-02-25 14:40:22Z] <Odachi.AspNetCore.Authentication.Basic.BasicMiddleware> (I):
Basic was not authenticated. Failure message: No authorization header.
[2019-02-25 14:40:22Z] <Odachi.AspNetCore.Authentication.Basic.BasicMiddleware> (I):
AuthenticationScheme: Basic was challenged.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Server.Kestrel> (D):
Connection id "0HLKR4R4VKBEK" completed keep alive response.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Hosting.Internal.WebHost> (I):
Request finished in 92.0354ms 401
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Hosting.Internal.WebHost> (I):
Request starting HTTP/1.1 PUT https://hostname_masked:5444/sessions/REPL_0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g_ application/json; charset=utf-8 68
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Builder.RouterMiddleware> (D):
Request did not match any routes.
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Services.IAuthenticationService> (T):
Attempting log on for user: user_masked
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Services.IAuthenticationService> (T):
Log on succeeded for user: user_masked
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Services.IAuthenticationService> (T):
User user_masked profile directory: C:\Users\user_masked
[2019-02-25 14:40:22Z] <Odachi.AspNetCore.Authentication.Basic.BasicMiddleware> (I):
HttpContext.User merged via AutomaticAuthentication from authenticationScheme: Basic.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Routing.Tree.TreeRouter> (D):
Request successfully matched the route with name '(null)' and template 'sessions/{id}'.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ActionSelector> (D):
Action 'Microsoft.R.Host.Broker.Sessions.SessionsController.Delete (Microsoft.R.Host.Broker)' with id '9176404d-60d5-4856-a2db-082221c04269' did not match the constraint 'Microsoft.AspNetCore.Mvc.Internal.HttpMethodActionConstraint'
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker> (D):
Executing action Microsoft.R.Host.Broker.Sessions.SessionsController.PutAsync (Microsoft.R.Host.Broker)
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Authorization.DefaultAuthorizationService> (I):
Authorization was successful for user: user_masked.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.ModelBinding.Binders.BodyModelBinder> (D):
Selected input formatter 'Microsoft.AspNetCore.Mvc.Formatters.JsonInputFormatter' for content type 'application/json; charset=utf-8'.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker> (I):
Executing action method Microsoft.R.Host.Broker.Sessions.SessionsController.PutAsync (Microsoft.R.Host.Broker) with arguments (REPL_0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g_, Microsoft.R.Host.Protocol.SessionCreateRequest) - ModelState is Valid
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (I):
Starting R session for connection REPL_0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g_ of user user_masked with command line: --rhost-suppress-ui --rhost-interactive --rhost-r-dir "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQL01\R_SERVICES\bin\x64" --rhost-name "REPL_0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g_" --rhost-log-verbosity 1
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
Creating user environment variables for user user_masked with profile directory C:\Users\user_masked
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
USERNAME = user_masked
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
HOMEDRIVE = C:
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
HOMEPATH = \Users\user_masked
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
USERPROFILE = C:\Users\user_masked
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
APPDATA = C:\Users\user_masked\AppData\Roaming
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
LOCALAPPDATA = C:\Users\user_masked\AppData\Local
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
TEMP = C:\Users\user_masked\AppData\Local\Temp
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
TMP = C:\Users\user_masked\AppData\Local\Temp
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
R_HOME = C:\PROGRA1\MICROS3\MSSQL11.MSS\R_SERV3
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
PATH = C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQL01\R_SERVICES\bin\x64;C:\Program Files\Teradata\Client\16.10\bin;C:\Program Files (x86)\Teradata\Client\16.10\bin;C:\Program Files\Microsoft MPI\Bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn;C:\Program Files\Microsoft SQL Server\130\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn;C:\Program Files\Microsoft SQL Server\130\DTS\Binn;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio;C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Microsoft\WindowsApps
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (I):
R session started for connection REPL_0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g_ of user user_masked
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker> (D):
Executed action method Microsoft.R.Host.Broker.Sessions.SessionsController.PutAsync (Microsoft.R.Host.Broker), returned result Microsoft.AspNetCore.Mvc.ObjectResult.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ObjectResultExecutor> (D):
Selected output formatter 'Microsoft.AspNetCore.Mvc.Formatters.JsonOutputFormatter' and content type 'application/json' to write the response.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ObjectResultExecutor> (I):
Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker> (I):
Executed action Microsoft.R.Host.Broker.Sessions.SessionsController.PutAsync (Microsoft.R.Host.Broker) in 622.8362ms
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Server.Kestrel> (D):
Connection id "0HLKR4R4VKBEK" completed keep alive response.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Hosting.Internal.WebHost> (I):
Request finished in 822.0458ms 200 application/json; charset=utf-8
Thanks and Regards
Hello,
We encoutering a problem when connecting to remote workspace.
In R Interactive Console the following error appears:
Connecting to R Workspace failed.
Reason: HTTP error while creating session on the machine 'hostname_masked'. Exception: The remote server returned an error: (400) Bad Request.
Interactive Window is disconnected from R session.
The Host Broker Log is:
[2019-02-25 14:40:16Z] <Microsoft.R.Host.Broker.Security.TlsConfiguration> (I):
Certificate issued by CN=cert_masked
[2019-02-25 14:40:16Z] <Microsoft.R.Host.Broker.Security.TlsConfiguration> (I):
Certificate issued to CN=cert_masked
[2019-02-25 14:40:16Z] <Microsoft.R.Host.Broker.Interpreters.InterpreterManager> (T):
Auto-detecting R ...
[2019-02-25 14:40:16Z] <Microsoft.R.Host.Broker.Interpreters.InterpreterManager> (W):
No compatible R interpreters found
[2019-02-25 14:40:16Z] <Microsoft.R.Host.Broker.Interpreters.InterpreterManager> (I):
1 interpreters configured:
[1] : MSSQL R Services at "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQL01\R_SERVICES"
[2019-02-25 14:40:16Z] <Microsoft.AspNetCore.Hosting.Internal.WebHost> (D):
Hosting starting
[2019-02-25 14:40:16Z] <Microsoft.AspNetCore.Hosting.Internal.WebHost> (D):
Hosting started
[2019-02-25 14:40:21Z] <Microsoft.AspNetCore.Server.Kestrel> (D):
Connection id "0HLKR4R4VKBEK" started.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Hosting.Internal.WebHost> (I):
Request starting HTTP/1.1 PUT https://hostname_masked:5444/sessions/REPL_0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g_ application/json; charset=utf-8 68
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Builder.RouterMiddleware> (D):
Request did not match any routes.
[2019-02-25 14:40:22Z] <Odachi.AspNetCore.Authentication.Basic.BasicMiddleware> (I):
Basic was not authenticated. Failure message: No authorization header.
[2019-02-25 14:40:22Z] <Odachi.AspNetCore.Authentication.Basic.BasicMiddleware> (I):
AuthenticationScheme: Basic was challenged.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Server.Kestrel> (D):
Connection id "0HLKR4R4VKBEK" completed keep alive response.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Hosting.Internal.WebHost> (I):
Request finished in 92.0354ms 401
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Hosting.Internal.WebHost> (I):
Request starting HTTP/1.1 PUT https://hostname_masked:5444/sessions/REPL_0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g_ application/json; charset=utf-8 68
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Builder.RouterMiddleware> (D):
Request did not match any routes.
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Services.IAuthenticationService> (T):
Attempting log on for user: user_masked
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Services.IAuthenticationService> (T):
Log on succeeded for user: user_masked
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Services.IAuthenticationService> (T):
User user_masked profile directory: C:\Users\user_masked
[2019-02-25 14:40:22Z] <Odachi.AspNetCore.Authentication.Basic.BasicMiddleware> (I):
HttpContext.User merged via AutomaticAuthentication from authenticationScheme: Basic.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Routing.Tree.TreeRouter> (D):
Request successfully matched the route with name '(null)' and template 'sessions/{id}'.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ActionSelector> (D):
Action 'Microsoft.R.Host.Broker.Sessions.SessionsController.Delete (Microsoft.R.Host.Broker)' with id '9176404d-60d5-4856-a2db-082221c04269' did not match the constraint 'Microsoft.AspNetCore.Mvc.Internal.HttpMethodActionConstraint'
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker> (D):
Executing action Microsoft.R.Host.Broker.Sessions.SessionsController.PutAsync (Microsoft.R.Host.Broker)
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Authorization.DefaultAuthorizationService> (I):
Authorization was successful for user: user_masked.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.ModelBinding.Binders.BodyModelBinder> (D):
Selected input formatter 'Microsoft.AspNetCore.Mvc.Formatters.JsonInputFormatter' for content type 'application/json; charset=utf-8'.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker> (I):
Executing action method Microsoft.R.Host.Broker.Sessions.SessionsController.PutAsync (Microsoft.R.Host.Broker) with arguments (REPL_0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g_, Microsoft.R.Host.Protocol.SessionCreateRequest) - ModelState is Valid
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (I):
Starting R session for connection REPL_0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g_ of user user_masked with command line: --rhost-suppress-ui --rhost-interactive --rhost-r-dir "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQL01\R_SERVICES\bin\x64" --rhost-name "REPL_0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g_" --rhost-log-verbosity 1
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
Creating user environment variables for user user_masked with profile directory C:\Users\user_masked
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
USERNAME = user_masked
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
HOMEDRIVE = C:
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
HOMEPATH = \Users\user_masked
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
USERPROFILE = C:\Users\user_masked
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
APPDATA = C:\Users\user_masked\AppData\Roaming
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
LOCALAPPDATA = C:\Users\user_masked\AppData\Local
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
TEMP = C:\Users\user_masked\AppData\Local\Temp
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
TMP = C:\Users\user_masked\AppData\Local\Temp
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
R_HOME = C:\PROGRA
1\MICROS3\MSSQL11.MSS\R_SERV3[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (T):
PATH = C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQL01\R_SERVICES\bin\x64;C:\Program Files\Teradata\Client\16.10\bin;C:\Program Files (x86)\Teradata\Client\16.10\bin;C:\Program Files\Microsoft MPI\Bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn;C:\Program Files\Microsoft SQL Server\130\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn;C:\Program Files\Microsoft SQL Server\130\DTS\Binn;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio;C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Microsoft\WindowsApps
[2019-02-25 14:40:22Z] <Microsoft.R.Host.Broker.Sessions.Session> (I):
R session started for connection REPL_0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g_ of user user_masked
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker> (D):
Executed action method Microsoft.R.Host.Broker.Sessions.SessionsController.PutAsync (Microsoft.R.Host.Broker), returned result Microsoft.AspNetCore.Mvc.ObjectResult.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ObjectResultExecutor> (D):
Selected output formatter 'Microsoft.AspNetCore.Mvc.Formatters.JsonOutputFormatter' and content type 'application/json' to write the response.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ObjectResultExecutor> (I):
Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker> (I):
Executed action Microsoft.R.Host.Broker.Sessions.SessionsController.PutAsync (Microsoft.R.Host.Broker) in 622.8362ms
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Server.Kestrel> (D):
Connection id "0HLKR4R4VKBEK" completed keep alive response.
[2019-02-25 14:40:22Z] <Microsoft.AspNetCore.Hosting.Internal.WebHost> (I):
Request finished in 822.0458ms 200 application/json; charset=utf-8
Thanks and Regards