FIX: Repair fails for Machine Learning components on server with no Internet access

Gælder for: SQL Server 2017 Developer on WindowsSQL Server 2017 Enterprise Core on WindowsSQL Server 2017 Enterprise on Windows

Symptoms


When you run a repair from SQL Server 2017 installation media on a server which does not have Internet access, the repair operation fails for the Machine Learning components (for example, R, Python). However, repair succeeds for all other components including Machine Learning (In-Database).

The ‘rsetup.log’ confirms that the failure is due to a failed attempt to download the SRO/SRS and/or SPO/SPS components:  
  Date\Time INFO Command invoked: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\SQL2017\x64\RSetup.exe /download /component SRO /version 3.3.3.24 /language 1033 /logfile C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20190621_140530\RSetup.log
  Date\Time INFO RSetup.exe version: 9.2.0.25
  Date\Time INFO Reading registry value HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\Bootstrap\Setup\R_SERV_CACHE
  Date\Time INFO Registry value:
  Date\Time INFO Reading registry value HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\Bootstrap\BootstrapDir
  Date\Time INFO Registry value: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\
  Date\Time INFO Searching for cache dir: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\\R_SERV_CACHE
  Date\Time INFO Using default cache directory: C:\Users\administrator.SQLREPRO\AppData\Local\Temp\
  Date\Time INFO Starting download: https://go.microsoft.com/fwlink/?LinkId=851496&clcid=1033
  Date\Time WARN Error making request: Unable to connect to the remote server
  Date\Time ERROR Download failed: https://go.microsoft.com/fwlink/?LinkId=851496&clcid=1033 [Object reference not set to an instance of an object.]
  Date\Time INFO Exiting with code 851496
  
  Date\Time INFO Command invoked: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\SQL2017\x64\RSetup.exe /download /component SPO /version 9.2.0.24 /language 1033 /logfile C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20190621_140530\RSetup.log
  Date\Time INFO RSetup.exe version: 9.2.0.25
  Date\Time INFO Reading registry value HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\Bootstrap\Setup\R_SERV_CACHE
  Date\Time INFO Registry value:
  Date\Time INFO Reading registry value HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\Bootstrap\BootstrapDir
  Date\Time INFO Registry value: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\
  Date\Time INFO Searching for cache dir: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\\R_SERV_CACHE
  Date\Time INFO Using default cache directory: C:\Users\administrator.SQLREPRO\AppData\Local\Temp\
  Date\Time INFO Starting download: https://go.microsoft.com/fwlink/?LinkId=851502&clcid=1033
  Date\Time WARN Error making request: Unable to connect to the remote server
  Date\Time ERROR Download failed: https://go.microsoft.com/fwlink/?LinkId=851502&clcid=1033 [Object reference not set to an instance of an object.]
  Date\Time INFO Exiting with code 851502

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. 

Resolution


This issue is fixed in the following cumulative update for SQL Server:

About cumulative updates for SQL Server:

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

Workaround


To work around this issue, you can use one of the following methods:
  • The workaround is to run setup.exe via command-line and include the '/MRCACHEDIRECTORY' switch to specify the location of the cab files.
  • To place the manually downloaded SRO\SRS and/or SPO\SPS files under the default cache directory before you run Repair.

References


Learn about the terminology that Microsoft uses to describe software updates.