sql server 2022 on linux error when running r script

Question

sql server 2022 on linux error when running r script

Dave Parker 0

I have recently installed SQL Server 2022 for Linux on an ubuntu 20.04 Server, and added the Integration Services and Extensibility packages as per instrcutions from the MS sites.

R (4.2.0) and Python (3.10) have been installed, and these have been integrated (supposedly) into SQL Server by running the mssql-conf tool to setup the rbinpath, pythinbinpath, and datadirectories

R & Python work fine on their own

However, if I attempt to run a script from the SQL Server command line - sqlcmd - I get the following error after a while:

Result 0x9864, Level 16, State 14
Unable to communicate with the runtime for 'R' script for request id: FC0F39DA-F637-44F0-9781-21C70E37446A. Please check the requirements of 'R' runtime.
STDERR message(s) from external script:
Error in sqlSatelliteCall() :
  collate_byname<char>::collate_byname failed to construct for en_US.utf8
Calls: sqlSatelliteCall -> .Call
Execution halted
Received the termination signal 1 from parent, terminating BxlServer of pid=24

I've tried a number of resources, and there doesn't seem to be a helpful answer to this! I've checked the settings I can think of, and all seems well, but this looks definitely like R / Python isn't connecting with SQL Server for some reason!

Any help appreciated

Dave Parker

Dave Parker 0 Reputation points

2023-09-15T11:02:38.79+00:00

The installation I've done is fairly straightforward, following all the instructions from Microsoft's website, for installing the mssql-server package on Linux for v2022, as well as the instructions for adding the mssql-server-is (Integration services) and extensibility packages.

There just seems to be a mismatch between getting SQL server to talk to R (version 4.2.0, installed into /usr/lib/R/bin/R) and Python (version 3.10, installed into /usr/lib/python3.10), even after the extensibility settings have been configured.....

I'm at a loss, and I suspect I'll probably have to ditch the Linux install and move it over to Windows, which would be a shame!

1 answer

Your answer

Dave Parker 0 Reputation points

2023-09-15T11:02:38.79+00:00

The installation I've done is fairly straightforward, following all the instructions from Microsoft's website, for installing the mssql-server package on Linux for v2022, as well as the instructions for adding the mssql-server-is (Integration services) and extensibility packages.

There just seems to be a mismatch between getting SQL server to talk to R (version 4.2.0, installed into /usr/lib/R/bin/R) and Python (version 3.10, installed into /usr/lib/python3.10), even after the extensibility settings have been configured.....

I'm at a loss, and I suspect I'll probably have to ditch the Linux install and move it over to Windows, which would be a shame!

Answer 1

LiHongMSFT-4306 31,621

Hi @Dave Parker

Please troubleshoot follow by this doc: Troubleshoot issues with Launchpad service executing Python and R scripts in SQL Server Machine Learning Services.

Best regards,

Cosmog Hong

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Dave Parker 0 Reputation points

2023-09-18T14:48:18.2466667+00:00

I have re-run the mssql-extensibility configuration, to set the rbinpath to be the location of R with /usr/lib/R/bin, and restarted the sqlserver process and launchpad service as well (just to be sure!)

The install of SQL server still will not see the R executable and run it, so I still get the script error (Unable to communicate with the runtime for 'R'"

Is there anyone who's had this experience with SQL server 2022 running on ubuntu 20.04? Strikes me that some instances work, but I fail to see how the connection is being lost!

Share via

sql server 2022 on linux error when running r script

1 answer

Your answer