sql-server-2017microsoft-r

Getting "STDERR message(s)..." message when running sp_execute_external_script SP in SQL Server 2017 using R


I recently installed SQL Server 2017 on my machine and configured both Python & R services.

When running below code I am getting "STDERR" message along with the actual output.

Can someone please help me understand why I'm getting that error and how to fix it? Thanks in advance.

exec sp_execute_external_script
     @language=N'R'
   , @script=N'print(R.version)'
go

STDERR Error message(s)...


Solution

  • I assume you are running SQL server 2017 CU13, (or later CU), as what you see is a bug introduced in CU13. What you see should not be a problem, it is a warning, and t is due to an incompatibility with the R package CompatibilityAPI.

    The anwwer is also in this thread: https://social.technet.microsoft.com/Forums/en-US/6ab7a0ca-836f-4d18-ac49-3239d610413d/getting-quotstderr-messages-from-external-scriptquot-message-showing?forum=MicrosoftR