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] (I):
Certificate issued by CN=cert_masked
[2019-02-25 14:40:16Z] (I):
Certificate issued to CN=cert_masked
[2019-02-25 14:40:16Z] (T):
Auto-detecting R ...
[2019-02-25 14:40:16Z] (W):
No compatible R interpreters found
[2019-02-25 14:40:16Z] (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] (D):
Hosting starting
[2019-02-25 14:40:16Z] (D):
Hosting started
[2019-02-25 14:40:21Z] (D):
Connection id "0HLKR4R4VKBEK" started.
[2019-02-25 14:40:22Z] (D):
Request did not match any routes.
[2019-02-25 14:40:22Z] (T):
Attempting log on for user: user_masked
[2019-02-25 14:40:22Z] (T):
Log on succeeded for user: user_masked
[2019-02-25 14:40:22Z] (T):
User user_masked profile directory: C:\Users\user_masked
[2019-02-25 14:40:22Z] (I):
HttpContext.User merged via AutomaticAuthentication from authenticationScheme: Basic.
[2019-02-25 14:40:22Z] (D):
Request successfully matched the route with name '(null)' and template 'sessions/{id}'.
[2019-02-25 14:40:22Z] (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] (I):
R session started for connection REPL0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g of user user_masked
[2019-02-25 14:40:22Z] (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] (D):
Selected output formatter 'Microsoft.AspNetCore.Mvc.Formatters.JsonOutputFormatter' and content type 'application/json' to write the response.
[2019-02-25 14:40:22Z] (I):
Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext.
[2019-02-25 14:40:22Z] (I):
Executed action Microsoft.R.Host.Broker.Sessions.SessionsController.PutAsync (Microsoft.R.Host.Broker) in 622.8362ms
[2019-02-25 14:40:22Z] (D):
Connection id "0HLKR4R4VKBEK" completed keep alive response.
[2019-02-25 14:40:22Z] (I):
Request finished in 822.0458ms 200 application/json; charset=utf-8
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] (I):
Certificate issued by CN=cert_masked
[2019-02-25 14:40:16Z] (I):
Certificate issued to CN=cert_masked
[2019-02-25 14:40:16Z] (T):
Auto-detecting R ...
[2019-02-25 14:40:16Z] (W):
No compatible R interpreters found
[2019-02-25 14:40:16Z] (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] (D):
Hosting starting
[2019-02-25 14:40:16Z] (D):
Hosting started
[2019-02-25 14:40:21Z] (D):
Connection id "0HLKR4R4VKBEK" started.
[2019-02-25 14:40:22Z] (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] (D):
Request did not match any routes.
[2019-02-25 14:40:22Z] (I):
Basic was not authenticated. Failure message: No authorization header.
[2019-02-25 14:40:22Z] (I):
AuthenticationScheme: Basic was challenged.
[2019-02-25 14:40:22Z] (D):
Connection id "0HLKR4R4VKBEK" completed keep alive response.
[2019-02-25 14:40:22Z] (I):
Request finished in 92.0354ms 401
[2019-02-25 14:40:22Z] (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] (D):
Request did not match any routes.
[2019-02-25 14:40:22Z] (T):
Attempting log on for user: user_masked
[2019-02-25 14:40:22Z] (T):
Log on succeeded for user: user_masked
[2019-02-25 14:40:22Z] (T):
User user_masked profile directory: C:\Users\user_masked
[2019-02-25 14:40:22Z] (I):
HttpContext.User merged via AutomaticAuthentication from authenticationScheme: Basic.
[2019-02-25 14:40:22Z] (D):
Request successfully matched the route with name '(null)' and template 'sessions/{id}'.
[2019-02-25 14:40:22Z] (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] (D):
Executing action Microsoft.R.Host.Broker.Sessions.SessionsController.PutAsync (Microsoft.R.Host.Broker)
[2019-02-25 14:40:22Z] (I):
Authorization was successful for user: user_masked.
[2019-02-25 14:40:22Z] (D):
Selected input formatter 'Microsoft.AspNetCore.Mvc.Formatters.JsonInputFormatter' for content type 'application/json; charset=utf-8'.
[2019-02-25 14:40:22Z] (I):
Executing action method Microsoft.R.Host.Broker.Sessions.SessionsController.PutAsync (Microsoft.R.Host.Broker) with arguments (REPL0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g, Microsoft.R.Host.Protocol.SessionCreateRequest) - ModelState is Valid
[2019-02-25 14:40:22Z] (I):
Starting R session for connection REPL0yY7BFO2csybkxutLp.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 "REPL0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g" --rhost-log-verbosity 1
[2019-02-25 14:40:22Z] (T):
Creating user environment variables for user user_masked with profile directory C:\Users\user_masked
[2019-02-25 14:40:22Z] (T):
USERNAME = user_masked
[2019-02-25 14:40:22Z] (T):
HOMEDRIVE = C:
[2019-02-25 14:40:22Z] (T):
HOMEPATH = \Users\user_masked
[2019-02-25 14:40:22Z] (T):
USERPROFILE = C:\Users\user_masked
[2019-02-25 14:40:22Z] (T):
APPDATA = C:\Users\user_masked\AppData\Roaming
[2019-02-25 14:40:22Z] (T):
LOCALAPPDATA = C:\Users\user_masked\AppData\Local
[2019-02-25 14:40:22Z] (T):
TEMP = C:\Users\user_masked\AppData\Local\Temp
[2019-02-25 14:40:22Z] (T):
TMP = C:\Users\user_masked\AppData\Local\Temp
[2019-02-25 14:40:22Z] (T):
R_HOME = C:\PROGRA~1\MICROS~3\MSSQL1~1.MSS\R_SERV~3
[2019-02-25 14:40:22Z] (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] (I):
R session started for connection REPL0yY7BFO2csybkxutLp.UaOtVj9g1Mz.ix.7PKcQyn.g of user user_masked
[2019-02-25 14:40:22Z] (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] (D):
Selected output formatter 'Microsoft.AspNetCore.Mvc.Formatters.JsonOutputFormatter' and content type 'application/json' to write the response.
[2019-02-25 14:40:22Z] (I):
Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext.
[2019-02-25 14:40:22Z] (I):
Executed action Microsoft.R.Host.Broker.Sessions.SessionsController.PutAsync (Microsoft.R.Host.Broker) in 622.8362ms
[2019-02-25 14:40:22Z] (D):
Connection id "0HLKR4R4VKBEK" completed keep alive response.
[2019-02-25 14:40:22Z] (I):
Request finished in 822.0458ms 200 application/json; charset=utf-8
Thanks and Regards