the upgrade of SQL server 2016 R in-database service failed.

hi,

any one tried to upgrade the R ( in database) of SQL 2016 ? I have a SQL server 2016 AOG group with 3 x nodes SQL nodes one by one and only one has R (In database) service can't upgrade, any idea?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The error is about something missed during the installation. I guess you'll need to reinstall it to see what you've missed.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Try to follow this my article and let me know if you could install it.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
hi,

R standalone , the R server, can be install with SQL server and fully functional ?

and I found I oinly need to run upgrade again and it seems fine, anyway to verify R service version ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You can try to run the following in a SSMS query window:
EXECUTE sp_execute_external_script    
	@language = N'R'    
    ,@script=N'print(version)'

Open in new window

0
 
marrowyungSenior Technical architecture (Data)Author Commented:
it returns this:

Msg 39021, Level 16, State 1, Line 11
Unable to launch runtime for 'R' script. Please check the configuration of the 'R' runtime.
Msg 39019, Level 16, State 1, Line 11
An external script error occurred: 
Unable to launch the runtime. ErrorCode 0x80070490: 1168(Element not found.).

Open in new window


so this means R is not enabled ?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Check this article. I think it will solve your issue.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
I don't think it helps.

R service error !
and on screen error message said this .exe stop working, I can debug or what.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
It's very hard to troubleshoot at this distance and without having access to your system.
Did you try to reinstall R Services?
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
"Did you try to reinstall R Services?"

no. but you mean that link : https://blogs.msdn.microsoft.com/arvindsh/2016/02/19/unable-to-launch-runtime-for-r-script-check-this-first/

show us how to reinstall it ? I run uninstall and install exactly the same way the link tell me .
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
this is just mean install R and enable configuration, then run this:

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 did all of these but the script above is an error.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
ok, reinstall anyway.

give you score first and I will try it later.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
tks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.