[SOLVED] KB5015143 & KB5014365 fails with error 0x80070643

Maxstar · Aug 16, 2022

Hi,

You can try that, and see what happens. If it failes, run the attached SFCFixScript to set the Patch Level back to 13.2.5893.48.
Reboot the server, and check if KB4052908 is in the list of updates.

Gratiskeder · Aug 16, 2022

SP2 fails the same way as the others,

Code:

TITLE: SQL Server Setup failure.
------------------------------

SQL Server Setup has encountered the following error:

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

Error code 0x84B10001.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&EvtType=0xDBFE1571%25400x3FB6F251

------------------------------
BUTTONS:

OK
------------------------------

Runned SFCFixScript and rebooted.
Updates is there as installed again,

Maxstar · Aug 16, 2022

Let's see if we can found something in a ProcMon trace while uninstalling SP2.

Step#1 - Capture Process Monitor Trace
1. Download and run Process Monitor. Leave this running while you perform the next steps.
2. Try to uninstall SP2
3. Stop Process Monitor as soon as it fails. You can simply do this by clicking the square (CTRL +E) on the toolbar as shown below.

4. Select the File menu...Save... and save the file to your desktop. This is likely the default location. The name (unless changed) will be LogFile.PML. This is fine.
5. Zip up the LogFile.PML and upload it to WeTransfer - Send Large Files & Share Photos Online - Up to 2GB Free and provide the link.

Gratiskeder · Aug 16, 2022

I've runned it through with trying to uninstall every part of SP2

Maxstar · Aug 16, 2022

At what stage does the error message appear?

SQL Server2016 update
Select Features
Check Files in Use
Ready to improve the update
Removal Progress

Gratiskeder · Aug 16, 2022

Before it even opens the windows with the update.
I've tried to record a video of what is happening when trying to uninstall. It's the same when I try to run the update from file.

Maxstar · Aug 16, 2022

Hmm, let's try something else. Please stop the following services, one at a time and try to uninstall SP2.

Rich (BB code):

SQL Full-text Filter Daemon Launcher (MSSQLSERVER)              MSSQLFDLauncher                                   Manual     Running  
SQL Server (MSSQLSERVER)                                        MSSQLSERVER                                       Auto       Running 
SQL Server Agent (MSSQLSERVER)                                  SQLSERVERAGENT                                    Auto       Running  
SQL Server VSS Writer                                           SQLWriter                                         Auto       Running  
TSM Scheduler MSSQLSERVER                                       TSM Scheduler MSSQLSERVER                         Auto       Running

Gratiskeder · Aug 16, 2022

Same error with every service stopped, and stopped one at a time,

Code:

TITLE: SQL Server Setup failure.
------------------------------

SQL Server Setup has encountered the following error:

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

Error code 0x84B10001.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&EvtType=0xDBFE1571%25400x3FB6F251

------------------------------
BUTTONS:

OK
------------------------------

Maxstar · Aug 16, 2022

Download FindSQLInstalls.vbs from Microsoft and run this script with the following command. (Reference Guide)

Rich (BB code):

cscript FindSQLInstalls.vbs "%userprofile%\Desktop\SQLLog.txt"

Gratiskeder · Aug 16, 2022

Got this

Maxstar · Aug 16, 2022

This file shows a lot of errors with the following suggestions to copy the missing files to the C:\Windows\Installer folder.
You could try to run the FixMissingMSI tool as well.

Rich (BB code):

!!!! sql_engine_core_shared.msi DOES NOT exist on the path in the path 1;H:\x64\setup\sql_engine_core_shared_msi\ !!!!
Action needed, re-establish the path to 1;H:\x64\setup\sql_engine_core_shared_msi\
Copy "1;H:\x64\setup\sql_engine_core_shared_msi\sql_engine_core_shared.msi" C:\Windows\Installer\48868ba6.msi

!!!! sql_engine_core_shared_loc.msi DOES NOT exist on the path in the path 1;H:\1033_ENU_LP\x64\setup\sql_engine_core_shared_loc_msi\ !!!!
Action needed, re-establish the path to 1;H:\1033_ENU_LP\x64\setup\sql_engine_core_shared_loc_msi\
Copy "1;H:\1033_ENU_LP\x64\setup\sql_engine_core_shared_loc_msi\sql_engine_core_shared_loc.msi" C:\Windows\Installer\48868bc1.msi

!!!! sql_engine_core_inst_loc.msi DOES NOT exist on the path in the path 1;H:\1033_ENU_LP\x64\setup\sql_engine_core_inst_loc_msi\ !!!!
Action needed, re-establish the path to 1;H:\1033_ENU_LP\x64\setup\sql_engine_core_inst_loc_msi\
Copy "1;H:\1033_ENU_LP\x64\setup\sql_engine_core_inst_loc_msi\sql_engine_core_inst_loc.msi" C:\Windows\Installer\48868bca.msi

!!!! sqlsupport.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\sql2008support\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\sql2008support\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\sql2008support\sqlsupport.msi" C:\Windows\Installer\48868b7e.msi

!!!! SqlWriter.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\x64\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\x64\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\x64\SqlWriter.msi" C:\Windows\Installer\48868b64.msi

!!!! sql_fulltext.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\sql_fulltext.msi" C:\Windows\Installer\48868bb8.msi

!!!! sqlbrowser.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\sqlbrowser.msi" C:\Windows\Installer\48868b6d.msi

!!!! sql_dmf.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\sql_dmf.msi" C:\Windows\Installer\48868b2b.msi

!!!! sql_tools_extensions.msi DOES NOT exist on the path in the path H:\x64\setup\ !!!!
Action needed, re-establish the path to H:\x64\setup\
Copy "H:\x64\setup\sql_tools_extensions.msi" C:\Windows\Installer\13eb4730.msi

!!!! SQLSUPPORT.MSI DOES NOT exist on the path in the path F:\67059f7b17b65789e0e077da3cd4caf5\1033_ENU_LP\x64\setup\sqlsupport_msi\ !!!!
Action needed, re-establish the path to F:\67059f7b17b65789e0e077da3cd4caf5\1033_ENU_LP\x64\setup\sqlsupport_msi\
Copy "F:\67059f7b17b65789e0e077da3cd4caf5\1033_ENU_LP\x64\setup\sqlsupport_msi\SQLSUPPORT.MSI" C:\Windows\Installer\b400aeb8.msi

!!!! IBM Spectrum Protect for Databases - MS SQL.msi DOES NOT exist on the path in the path C:\Windows\ccmcache\5ba\ !!!!
Action needed, re-establish the path to C:\Windows\ccmcache\5ba\
Copy "C:\Windows\ccmcache\5ba\IBM Spectrum Protect for Databases - MS SQL.msi" C:\Windows\Installer\4ec076f5.msi

!!!! sql_common_core.msi DOES NOT exist on the path in the path 1;H:\x64\setup\sql_common_core_msi\ !!!!
Action needed, re-establish the path to 1;H:\x64\setup\sql_common_core_msi\
Copy "1;H:\x64\setup\sql_common_core_msi\sql_common_core.msi" C:\Windows\Installer\48868b86.msi

!!!! sqlsqm.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\sqlsqm.msi" C:\Windows\Installer\48868b76.msi

!!!! IBM Spectrum Protect for Databases - MS SQL - Management Console.msi DOES NOT exist on the path in the path C:\Windows\ccmcache\5b9\ !!!!
Action needed, re-establish the path to C:\Windows\ccmcache\5b9\
Copy "C:\Windows\ccmcache\5b9\IBM Spectrum Protect for Databases - MS SQL - Management Console.msi" C:\Windows\Installer\4ec076b6.msi

!!!! DACFramework.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\x86\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\x86\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\x86\DACFramework.msi" C:\Windows\Installer\487aa9f0.msi

!!!! smo_extensions_loc.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\smo_extensions_loc.msi" C:\Windows\Installer\48868b55.msi

!!!! sql_batchparser.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\sql_batchparser.msi" C:\Windows\Installer\48868b1d.msi

!!!! smo_extensions.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\smo_extensions.msi" C:\Windows\Installer\48868b40.msi

!!!! sql_engine_core_inst.msi DOES NOT exist on the path in the path 1;H:\x64\setup\sql_engine_core_inst_msi\ !!!!
Action needed, re-establish the path to 1;H:\x64\setup\sql_engine_core_inst_msi\
Copy "1;H:\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi" C:\Windows\Installer\48868baf.msi

!!!! sql_diag.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\sql_diag.msi" C:\Windows\Installer\48868b24.msi

!!!! sql_xevent.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\x64\setup\sql_xevent.msi" C:\Windows\Installer\48868b39.msi

!!!! sql_dmf_loc.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\sql_dmf_loc.msi" C:\Windows\Installer\48868b32.msi

!!!! sql_tools_extensions_loc.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\ !!!!
Action needed, re-establish the path to H:\1033_ENU_LP\x64\setup\
Copy "H:\1033_ENU_LP\x64\setup\sql_tools_extensions_loc.msi" C:\Windows\Installer\13eb4739.msi

!!!! sql_common_core_loc.msi DOES NOT exist on the path in the path 1;H:\1033_ENU_LP\x64\setup\sql_common_core_loc_msi\ !!!!
Action needed, re-establish the path to 1;H:\1033_ENU_LP\x64\setup\sql_common_core_loc_msi\
Copy "1;H:\1033_ENU_LP\x64\setup\sql_common_core_loc_msi\sql_common_core_loc.msi" C:\Windows\Installer\48868b8f.msi

!!!! sql_xevent_loc.msi DOES NOT exist on the path in the path C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\ !!!!
Action needed, re-establish the path to C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\
Copy "C:\Users\wwiadmin\Desktop\SQL 2016 Standard with SP1\1033_ENU_LP\x64\setup\sql_xevent_loc.msi" C:\Windows\Installer\48868b4e.msi

Gratiskeder · Aug 16, 2022

Now I'm not familiar with FixMissingMSI, but I can't seem to find any 'mismatched' or 'missing'. Is there some specific way I should search with the tool.
As i understand, it mentions a H: drive, but there is no H: drive attached on the server.

Maxstar · Aug 16, 2022

This is one of the complete error messages, so it seems that the registry entry refers to the H drive? This is the first time I'm using the FixMissingMSI tool as well, but you need to refer the tool to the original media location and re-cache the missing files.

Rich (BB code):

================================================================================
PRODUCT NAME   : SQL Server 2016 Database Engine Shared
================================================================================
  Product Code: {686A81C0-C8E4-46F6-952F-B19A28E8C430}
  Version     : 13.2.5026.0
  Most Current Install Date: 20191029
  Target Install Location:
  Registry Path:
   HKEY_CLASSES_ROOT\Installer\Products\0C18A6864E8C6F6459F21BA9828E4C03\SourceList
     Package    : sql_engine_core_shared.msi
  Install Source: \x64\setup\sql_engine_core_shared_msi\
  LastUsedSource: m;101;H:\x64\setup\sql_engine_core_shared_msi\
 
 !!!! sql_engine_core_shared.msi DOES NOT exist on the path in the path 1;H:\x64\setup\sql_engine_core_shared_msi\ !!!!
 
 Action needed, re-establish the path to 1;H:\x64\setup\sql_engine_core_shared_msi\

Gratiskeder · Aug 16, 2022

There is no H: drive present on the server. I don't know what to do from here then

Maxstar · Aug 16, 2022

Maybe H: was a mounted ISO when the server was installed? You could try to perform a repair install on the cloned server: Repair a Failed SQL Server Installation - SQL Server

When you repair an instance of SQL Server:

All missing or corrupt files are replaced.
All missing or corrupt registry keys are replaced.
All missing or invalid configuration values are set to default values.

Gratiskeder · Aug 17, 2022

Hi, I've have send this case on to our patch for them to look into, so there's no need for us to investigate more.
Thanks a lot for all your time and help.

Maxstar · Aug 17, 2022

Hi,

You're welcome. This is a difficult problem, therefore I'am very curious as to what the solution will be. So feel free to share the solution with us when it is solved.

Gratiskeder · Aug 18, 2022

I'll keep an eye on it and let you know if I get anything

Maxstar · Aug 18, 2022

Thank you, that is much appreciated....

p.s.
This reference guide might be useful when you need to replace files manually: Restore the missing Windows Installer cache files - SQL Server

[SOLVED] KB5015143 & KB5014365 fails with error 0x80070643

Moderator, Windows Update Expert, Security Analyst

Attachments

Well-known member

Attachments

Moderator, Windows Update Expert, Security Analyst

Well-known member

Attachments

Moderator, Windows Update Expert, Security Analyst

Well-known member

Attachments

Moderator, Windows Update Expert, Security Analyst

Well-known member

Moderator, Windows Update Expert, Security Analyst

Well-known member

Attachments

Moderator, Windows Update Expert, Security Analyst

Well-known member

Moderator, Windows Update Expert, Security Analyst

Well-known member

Moderator, Windows Update Expert, Security Analyst

Well-known member

Moderator, Windows Update Expert, Security Analyst

Well-known member

Moderator, Windows Update Expert, Security Analyst