Correct, I am using R 4.5.2. Anyway I have found a work around. I export the R function that is causing the issue, and fix the bug and then load the changed function. It is painful but so far it works.
How to fix this error with rxInstallPackages
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 42%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Stephen Hayes
0
Reputation points
I have installed the Machine Learning services on Microsoft SQL Server 2022 (RTM-GDR) (KB5068407) - 16.0.1160.1 (X64) Oct 3 2025 18:06:58 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 26200: ) (Hypervisor)
and when I runs this command
rxInstallPackages(pkgs = pkgs, verbose = TRUE, scope = "shared", computeContext = sqlcc)
I get this error "Error in is.null(version) || is.na(version) : 'length = 5' in coercion to 'logical(1)'"
Is there any work around for it?
Thanks
Stephen
SQL Server Database Engine
{count} votes
-
Erland Sommarskog 129.4K Reputation points MVP Volunteer Moderator2025-12-16T22:26:20.56+00:00 A starting point would be to install the most recent Cumulative Update of SQL Server 2022. I don't know if that resolves the issue, but it might. Particularly, if this is on a named instance.
-
Stephen Hayes 0 Reputation points
2025-12-17T15:07:02.45+00:00 no joy, I upgraded to SQL 2025 and it is still broken with the same error. I reckon the package is not updated correctly - I did a bit more digging and the error is coming from here :
RevoScaleR:::rxCheckPackageManagementVersion(sqlConnString)This function is calling
RevoScaleR:::rxGetPackageManagementVersion(connectionString)And in this function the problem is in this condition
if (is.null(version) || is.na(version) || length(version) == 0) { ... }Does anyone know how to log a bug for this package to be fixed for R 4.5.2?
-
Erland Sommarskog 129.4K Reputation points MVP Volunteer Moderator
2025-12-17T22:04:40.1+00:00 You will have to excuse me. I have have a little bit with using Python from SQL Server, but R is a very white spot for me. Do I understand it correctly, that you have installed R successfully in SQL Server, but then you try to run something to add a package, and you run into this snag? From where do you run this rxInstallPackages thing?
I ask, in case I would try to repro it.
-
Stephen Hayes 0 Reputation points
2025-12-18T15:20:03.4366667+00:00 Yes I have installed, R machine learning services on to Developer Edition of SQL 2025, I am using a package called RevoScaleR, most of its functions work but some don't seem to have been updated to R 4.5.2,
To repo, you need to connect to SQL server using RevoScaleR, and set the compute context to be the SQL server. Then you should in theory be able to run the rxInstallPackages() command -
Erland Sommarskog 129.4K Reputation points MVP Volunteer Moderator
2025-12-18T21:34:03.67+00:00 I googled around a bit, and I found https://learn.microsoft.com/en-us/previous-versions/microsoft-r/r-reference/revoscaler/revoscaler which has this disturbing note on top:
So it may be that bad that RevoScaleR is no longer maintained, and therefore cannot be used with later versions or R.
-
Stephen Hayes 0 Reputation points
2025-12-19T09:39:21.9166667+00:00 And yet these are the instructions to install R with SQL https://learn.microsoft.com/en-us/sql/machine-learning/install/sql-machine-learning-services-windows-install-sql-2022?view=sql-server-ver17#setup-r-support
It seems to me that RevoScaleR was recompiled for R 4 but it was not tested to see if all the functions worked with R 4
-
Erland Sommarskog 129.4K Reputation points MVP Volunteer Moderator
2025-12-19T21:29:10.18+00:00 Hm, but the instructions talks about R 4.2, and you are using R 4.5.2, if I understood you correctly?
Sign in to comment
Answer recommended by moderator
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 46%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Stephen Hayes 0 Reputation points2025-12-19T22:38:07.98+00:00 -
Erland Sommarskog 129.4K Reputation points MVP Volunteer Moderator
2025-12-19T22:44:50.6133333+00:00 I converted your comment to an Answer and recommended it, because frankly, I think this is as far as we come.
The same page talks about version 3.10 for Python. I seem to recall having tried later Python versions without success. I get the impression that Microsoft has left this wayside.
Sign in to comment -