Error of SQL Server 2016 sp_execute_external_script with R integration

▲
5
▼

I am evaluating SQL Server 2016 in-database integration with R on Windows 10. I have followed the steps installed all components and scripts. Now I have following questions:

Where does sp_execute_external_script reside? I can’t find it. When I run script, for example:

execute sp_execute_external_script @language = N'R' , @script = N' OutputDataSet <- InputDataSet;' , @input_data_1 = N' SELECT TOP 100 [BusinessEntityID] FROM [AdventureWorks2014].[Person].[Person];';

I got 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 1, Line 1 An external script error occurred: Unable to launch the runtime. ErrorCode 0x80070490: 1168(Element not found.).”

Based on the above suggestion, I rerun the script, but it does not solve the problem.

Any suggestions are greatly appreciated.

sql
sql-server
r
sql-server-2016
asked on Stack Overflow Nov 18, 2015 by Frank • edited Nov 18, 2015 by Lukasz Szozda

4 Answers

▲
6
▼

RegisterRExt post installation configuration needs to specify the correct instance name as per this MSDN article .

You can run the following commands to fix your issue:

"%programfiles%\RRO\RRO-3.2.2-for-RRE-7.5.0\R-3.2.2\library\RevoScaleR\rxLibs\x64\RegisterRExt" /uninstall

"%programfiles%\RRO\RRO-3.2.2-for-RRE-7.5.0\R-3.2.2\library\RevoScaleR\rxLibs\x64\RegisterRExt" /install /instance:InstanceName

answered on Stack Overflow Nov 20, 2015 by Arun Gurunathan • edited Nov 20, 2015 by Arun Gurunathan
▲
1
▼

sp_execute_external_script is in the Extended Stored Procedures node in the 'master' database of the installed instance of SQL Server 2016

answered on Stack Overflow Jul 24, 2016 by user2063329
▲
0
▼

Can you please confirm you ran both R provider installation & Post-installation steps below?

Install R Packages and Providers for SQL Server R Services

Post-Installation Server Configuration (SQL Server R Services)

If you are still facing errors, can you share log from RegisterRExt.log from this location:

"%programfiles%\RRO\RRO-3.2.2-for-RRE-7.5.0\R-3.2.2\library\RevoScaleR\rxLibs\x64\RegisterRExt.log"

answered on Stack Overflow Nov 18, 2015 by Arun Gurunathan
▲
0
▼

For SQL Server 2016 official RTM release I've found that a similar error (but with "incorrect parameter" instead of "Element not found") was caused because I moved the working directory in the R config file to have directory without spaces, but you need also to create inside it other working directories, from SQL201601 to SQL201620, as it was in the original confi directory.

Regards Massimo

answered on Stack Overflow Jun 17, 2016 by massimogentilini

User contributions licensed under CC BY-SA 3.0