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


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?
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Try to follow this my article and let me know if you could install it.
marrowyungSenior Technical architecture (Data)Author Commented:

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 ?
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'    

Open in new window

Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

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 ?
Vitor MontalvãoMSSQL Senior EngineerCommented:
Check this article. I think it will solve your issue.
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.
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?
marrowyungSenior Technical architecture (Data)Author Commented:
"Did you try to reinstall R Services?"

no. but you mean that link :

show us how to reinstall it ? I run uninstall and install exactly the same way the link tell me .
Vitor MontalvãoMSSQL Senior EngineerCommented:
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',
OutputDataSet <- InputDataSet;
@input_data_1 =N'SELECT 1 AS hello'
WITH RESULT SETS (([hello] int not null));

I did all of these but the script above is an error.
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
ok, reinstall anyway.

give you score first and I will try it later.
marrowyungSenior Technical architecture (Data)Author Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.