SQL Patches KB5035434 installation failure - Failed to retrieve data for this request

Question

When install SQL Server 2019 RTM GDR patches (KB5035434), I've got below error, anyone could help, thanks!

Overall summary:

Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.

Exit code (Decimal): -2146233088

Exit facility code: 19

Exit error code: 5376

Exit message: Failed to retrieve data for this request.

Start time: 2024-04-22 11:58:50

End time: 2024-04-22 12:02:30

Requested action: Patch

Exception help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.2110.4&EvtType=0xE8A0C283%400xAC7B1A58%401233%4053&EvtType=0xE8A0C283%400xAC7B1A58%401233%4053

Machine Properties:

Machine name: CNPIS-UAT-DB2

Machine processor count: 4

OS version: Microsoft Windows Server 2016 Standard (10.0.14393)

OS service pack:

OS region: United States

OS language: English (United States)

OS architecture: x64

Process architecture: 64 Bit

OS clustered: Yes

Product features discovered:

Product Instance Instance ID Feature Language Edition Version Clustered Configured

SQL Server 2019 CNPIS_UAT MSSQL15.CNPIS_UAT Database Engine Services 1033 Developer Edition 15.0.2104.1 No Yes

SQL Server 2019 Client Tools Connectivity 1033 15.0.2000.5 No Yes

SQL Server 2019 Client Tools Backwards Compatibility 1033 15.0.2000.5 No Yes

Package properties:

Description: Microsoft SQL Server 2019

ProductName: SQL Server 2019

Type: RTM

Version: 15

SPLevel: 0

KBArticle: KB5035434

KBArticleHyperlink: https://support.microsoft.com/?kbid=5035434

PatchType: GDR

AssociatedHotfixBuild: 4360

Platform: x64

PatchLevel: 15.0.2110.4

ProductVersion: 15.0.2000.5

GDRReservedRange: 15.0.2005.0:15.0.2010.0

Installation location: D:\9589d68d600b4997a036804c9126\x64\setup\

User Input Settings:

ACTION: Patch

ALLINSTANCES: false

CLUSTERPASSIVE: false

CONFIGURATIONFILE:

ENU: true

HELP: false

IACCEPTPYTHONLICENSETERMS: false

IACCEPTROPENLICENSETERMS: false

IACKNOWLEDGEENTCALLIMITS: false

INDICATEPROGRESS: false

INSTANCEID:

INSTANCENAME:

MRCACHEDIRECTORY:

QUIET: false

QUIETSIMPLE: false

SUPPRESSPAIDEDITIONNOTICE: false

SUPPRESSPRIVACYSTATEMENTNOTICE: false

UIMODE: Normal

X86: false

Rules with failures or warnings:

Rules report file: The rule result report file is not available.

Exception summary:

The following is an exception stack listing the exceptions in outermost to innermost order

Inner exceptions are being indented

Exception type: Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException

Message:

Failed to retrieve data for this request.

HResult : 0x80131500

Data:

HelpLink.ProdName = Microsoft SQL Server

HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink

HelpLink.LinkId = 20476

HelpLink.EvtType = 0xE8A0C283@0xAC7B1A58@1233@53

DisableWatson = true

Stack:

at Microsoft.SqlServer.Discovery.SqlDiscoveryDatastoreInterface.LoadData(IEnumerable`1 machineNames, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)

at Microsoft.SqlServer.Discovery.SqlDiscoveryProvider.DiscoverMachines(ServiceContainer context, Boolean runRemoteDetection, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)

at Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction.ExecuteAction(String actionId)

at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClass2_0.b__0()

at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)

Inner exception type: Microsoft.SqlServer.Configuration.Sco.SqlRegistryException

Message:

The network path was not found.

HResult : 0x84d10035

FacilityCode : 1233 (4d1)

ErrorCode : 53 (0035)

Data:

WatsonData = Microsoft.SqlServer.Configuration.Sco.SqlRegistryException@Win32Error

Stack:

at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.CreateBaseKey(ServiceContainer ctx, String machineName, IntPtr hKey, String keyName, RegistryAccess access, RegistryView view)

at Microsoft.SqlServer.Configuration.Sco.DiscoveryUtils.Util.GetLocalMachineRootKey(ServiceContainer ctx, String machineName, RegistryView registryView)

at Microsoft.SqlServer.Configuration.Sco.DiscoveryUtils.Util.GetLocalMachineSubKey(ServiceContainer ctx, String machineName, RegistryView regView, String regPath, RegistryAccess registryAccess)

at Microsoft.SqlServer.Discovery.RegistryKeyExistsPropertyValueProvider.GetPropertyValue(Object[] context)

at Microsoft.SqlServer.Discovery.DiscoveryEnumObject.GetPropertyValueFromProvider(IPropertyValueProvider propertyValueProvider, String machineName, Object[] context)

at Microsoft.SqlServer.Discovery.ObjectInstanceSettings.IsObjectFound(String machineName, String idFilter)

at Microsoft.SqlServer.Discovery.Product.FilterObjectSet(ArrayList objects, String idFilter)

at Microsoft.SqlServer.Discovery.Product.GetData(EnumResult erParent)

at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()

at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)

at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)

at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)

Answer

It seems that you are on the so-called GDR train. That is, you have the release version of SQL 2019 and only security fixes. This is not a very good idea.

I would recommend that you download and install the most recent Cumulative Update, which is CU 26, and which includes the security fix in the latest GDR.

You may first have to uninstall the GDRs for SQL 2019 you have installed.

SQL Patches KB5035434 installation failure - Failed to retrieve data for this request

1 answer