SQL Server 2016 sp_execute_external_script error with R integration

Question

I am evaluating SQL Server 2016 integration with R in Windows 10. I have completed the steps set for all components and scripts. Now I have the following questions:

Where is sp_execute_external_script located? I can not find him. When I run the 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 an error:

"Msg 39021, level 16, state 1, line 1 Unable to run runtime for 'R' script. Check the configuration of the R runtime environment. Msg 39019, Level 16, state 1, line 1 An external script error occurred: the runtime failed to start ErrorCode 0x80070490: 1168 (Element not found.).

Based on the above suggestion, I will restart the script, but this does not solve the problem.

Any suggestions are welcome.

Answer 1

The post postfix configuration for registering RegisterRExt must specify the correct instance name in accordance with this

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

Answer 2

Can you confirm that you completed both the installation of the R provider and the post installation steps below?

Install R Packages and Providers for SQL Server R Services

Post-Installation Server Configuration (SQL Server R Services)

If you still encounter errors, you can exchange the log with RegisterRExt.log from this location:

"% ProgramFiles% \ RRO \ RRO-3.2.2-for-RRE-7.5.0 \ R-3.2.2 \ libraries \ RevoScaleR \ rxLibs \ 64 \ RegisterRExt.log"

Answer 3

For the official RTM version for SQL Server 2016, I found that a similar error (but with an "incorrect parameter" instead of "Item not found") was caused by the fact that I moved the working directory to the R configuration file to have the directory without spaces, but you you also need to create other working directories inside it, from SQL201601 to SQL201620, as it was in the original confi directory.

Relations Massimo

Answer 4

sp_execute_external_script is located in the node extended stored procedures in the master database of the installed instance of SQL Server 2016