SQL Server Machine Learning Services - Unable to launch the runtime. ErrorCode 0x80070032: 50(The request is not supported.)

0

Trying to configure MLS on SQL Server 2017, but when running a very basic external script like so:

EXEC sp_execute_external_script  @language =N'R',
@script=N'OutputDataSet <- InputDataSet;',
@input_data_1 =N'SELECT 1 AS hello'
WITH RESULT SETS (([hello] int not null));
GO

I get this error:

Msg 39021, Level 16, State 1, Line 1 Unable to launch runtime for 'R' script. Please check the configuration of the 'R' runtime. Msg 39019, Level 16, State 2, Line 1 An external script error occurred: Unable to launch the runtime. ErrorCode 0x80070032: 50(The request is not supported.).

And if I look at the log EXTLAUNCHERRORLOG I see:

2020-12-29 17:53:49.554 SetCpuRateCap failed with error code 0x80070032.

I can't find a reference to this error anywhere, and am very perplexted. Tried all kinds of things (checking permissions, turning the resource governor off, updating to latest CU, reinstalling MLS, etc). We have a similar server that is running on same Azure platform (same size, W2012R2, same memory/cpu config), configured about the same time and it seems to not have this issue. This happens with both R and Python services.

Any help would be appreciated.

sql-server
sql-server-2017
microsoft-r
microsoft-machine-learning-server
asked on Stack Overflow Dec 29, 2020 by user3258158

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0