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

Symptoms

When you run a repair from SQL Server 2016 or 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 updates 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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×