question

NishitShah-6729 avatar image
0 Votes"
NishitShah-6729 asked CarrinWu-MSFT edited

Error Installing KB5001092 - SQL Server 2016 Patching Issue

Hi All,

Version - SQL Server 2016 Enterprise Edition
Current Patch Level - 13.0.5830.85
Target Patch Level - 13.0.5888.11

While trying to apply CU17 for SP2, I faced several errors relating MSI/MSP files missing and/or replaced by the MSI fix tool which made them 20 KB size in the Installer folder. I dug my way out of that by carefully replacing the MSI/MSP files for all patches that had been applied thus far on the server for SQL Server 2016.

So once that was done, I was able to move forward; however, the Database Engine Services (and as a result of that - Polybase, R, Replication etc.) are still failing.

When I check the log, it no longer has those MSI/MSP errors. The error log is quite huge, so I am posting portions of it here:

MSI (s) (FC:08) [08:31:02:275]: Opening existing patch 'C:\WINDOWS\Installer\d484d.msp'.
MSI (s) (FC:08) [08:31:02:275]: Opening existing patch 'C:\WINDOWS\Installer\9c3db2c5.msp'.
MSI (s) (FC:08) [08:31:02:275]: File will have security applied from OpCode.
MSI (s) (FC:08) [08:31:02:775]: Original patch ==> D:\DBA_DO_NOT_DELETE\KB5001092\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msp
MSI (s) (FC:08) [08:31:02:775]: Patch we're running from ==> C:\WINDOWS\Installer\2883a4.msp
MSI (s) (FC:08) [08:31:02:775]: SOFTWARE RESTRICTION POLICY: Verifying patch --> 'D:\DBA_DO_NOT_DELETE\KB5001092\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msp' against software restriction policy
MSI (s) (FC:08) [08:31:02:775]: SOFTWARE RESTRICTION POLICY: D:\DBA_DO_NOT_DELETE\KB5001092\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msp has a digital signature
MSI (s) (FC:08) [08:31:03:213]: SOFTWARE RESTRICTION POLICY: D:\DBA_DO_NOT_DELETE\KB5001092\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msp is permitted to run at the 'unrestricted' authorization level.
MSI (s) (FC:08) [08:31:03:213]: SequencePatches starts. Product code: {863E9807-97F0-417A-9957-DE4372A13404}, Product version: 13.0.1601.5, Upgrade code: {6530AEAB-B958-41E7-9EB9-8DC1F3564072}, Product language 1033
MSI (s) (FC:08) [08:31:03:213]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (FC:08) [08:31:03:213]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (FC:08) [08:31:03:213]: Note: 1: 2262 2: Property 3: -2147287038
MSI (s) (FC:08) [08:31:03:213]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (FC:08) [08:31:03:213]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (FC:08) [08:31:03:213]: PATCH SEQUENCER: verifying the applicability of QFE patch D:\DBA_DO_NOT_DELETE\KB5001092\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msp against product code: {863E9807-97F0-417A-9957-DE4372A13404}, product version: 13.0.1601.5, product language 1033 and upgrade code: {6530AEAB-B958-41E7-9EB9-8DC1F3564072}
MSI (s) (FC:08) [08:31:03:213]: PATCH SEQUENCER: QFE patch D:\DBA_DO_NOT_DELETE\KB5001092\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msp is not applicable.
MSI (s) (FC:08) [08:31:03:213]: SequencePatches returns success.
MSI (s) (FC:08) [08:31:03:213]: Final Patch Application Order:
MSI (s) (FC:08) [08:31:03:213]: {30BC4D0C-0A1C-4735-929B-94C3DCAC8A16} -
MSI (s) (FC:08) [08:31:03:213]: Other Patches:
MSI (s) (FC:08) [08:31:03:213]: Unknown\Absent: {FB77581D-DE07-4197-BE4D-4B3F195CEE1F} -
MSI (s) (FC:08) [08:31:03:213]: Superseded: {39634AC2-4DEA-454F-9DDE-118F85256A88} -
MSI (s) (FC:08) [08:31:03:213]: Superseded: {440FEBFC-A321-4707-A241-17F8DC28A4B2} -
MSI (s) (FC:08) [08:31:03:213]: Superseded: {FDF9294E-BD3E-48D8-8E19-5D1C2BC0F287} -
MSI (s) (FC:08) [08:31:03:213]: Unknown\Absent: {0CB615DE-B4C1-4A94-9624-C0AB3F0D61C0} - D:\DBA_DO_NOT_DELETE\KB5001092\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msp
MSI (s) (FC:08) [08:31:03:213]: Machine policy value 'DisablePatch' is 0
MSI (s) (FC:08) [08:31:03:213]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (FC:08) [08:31:03:213]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (FC:08) [08:31:03:213]: Machine policy value 'DisableFlyWeightPatching' is 0

s) (FC:08) [08:31:05:869]: Resolving source.
MSI (s) (FC:08) [08:31:05:869]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (FC:08) [08:31:05:869]: User policy value 'DisableMedia' is 0
MSI (s) (FC:08) [08:31:05:869]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (FC:08) [08:31:05:869]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (FC:08) [08:31:05:869]: SOURCEMGMT: Looking for sourcelist for product {863E9807-97F0-417A-9957-DE4372A13404}
MSI (s) (FC:08) [08:31:05:869]: SOURCEMGMT: Adding {863E9807-97F0-417A-9957-DE4372A13404}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (FC:08) [08:31:05:869]: SOURCEMGMT: Now checking product {863E9807-97F0-417A-9957-DE4372A13404}
MSI (s) (FC:08) [08:31:05:869]: SOURCEMGMT: Media is enabled for product.
MSI (s) (FC:08) [08:31:05:869]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (FC:08) [08:31:05:869]: SOURCEMGMT: Trying source \\DBA_Do_Not_Delete\SQL_SERVER_MIGRATION_2016\software\Sql_server_2016_setup\x64\setup\sql_engine_core_inst_msi.
MSI (s) (FC:08) [08:31:06:635]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (FC:08) [08:31:07:213]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (FC:08) [08:31:07:213]: SOURCEMGMT: Resolved source to: '\\DBA_Do_Not_Delete\SQL_SERVER_MIGRATION_2016\software\Sql_server_2016_setup\x64\setup\sql_engine_core_inst_msi\'
MSI (s) (FC:08) [08:31:07:213]: PROPERTY CHANGE: Adding SourceDir property. Its value is '\\DBA_Do_Not_Delete\SQL_SERVER_MIGRATION_2016\software\Sql_server_2016_setup\x64\setup\sql_engine_core_inst_msi\'.
MSI (s) (FC:08) [08:31:07:213]: PROPERTY CHANGE: Adding SOURCEDIR property. Its value is '\\DBA_Do_Not_Delete\SQL_SERVER_MIGRATION_2016\software\Sql_server_2016_setup\x64\setup\sql_engine_core_inst_msi\'.
MSI (s) (FC:08) [08:31:07:213]: PROPERTY CHANGE: Adding SourcedirProduct property. Its value is '{863E9807-97F0-417A-9957-DE4372A13404}'.
MSI (s) (FC:08) [08:31:07:213]: SOURCEDIR ==> \\DBA_Do_Not_Delete\SQL_SERVER_MIGRATION_2016\software\Sql_server_2016_setup\x64\setup\sql_engine_core_inst_msi\
MSI (s) (FC:08) [08:31:07:213]: SOURCEDIR product ==> {863E9807-97F0-417A-9957-DE4372A13404}
MSI (s) (FC:08) [08:31:07:213]: SECREPAIR: CryptAcquireContext succeeded
MSI (s) (FC:08) [08:31:07:213]: Determining source type
MSI (s) (FC:08) [08:31:07:229]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (FC:08) [08:31:07:229]: Source type from package 'sql_engine_core_inst.msi': 1
MSI (s) (FC:08) [08:31:07:229]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (FC:08) [08:31:07:229]: SECREPAIR: Hash Database: C:\WINDOWS\Installer\SourceHash{863E9807-97F0-417A-9957-DE4372A13404}
MSI (s) (FC:08) [08:31:07:229]: Note: 1: 2318 2:
MSI (s) (FC:08) [08:31:07:682]: Incrementing counter to disable shutdown. Counter after increment: 0

MSI (s) (FC:08) [08:31:12:792]: Note: 1: 2318 2: E:\Program Files\Microsoft SQL Server\MSSQL13.SQLS2016\MSSQL\Binn\Microsoft.ApplicationInsights.dll
MSI (s) (FC:08) [08:31:12:792]: File will have security applied from OpCode.
MSI (s) (FC:08) [08:31:12:871]: Executing op: RegisterSharedComponentProvider(,,File=ENG_RE_BackupToUrl_exe_64,Component={9A618F11-11BF-4F7E-AC76-BFAB64C6A624},ComponentVersion=13.0.1601.5,ProductCode={863E9807-97F0-417A-9957-DE4372A13404},ProductVersion=13.0.1601,PatchSize=0,PatchAttributes=0,PatchSequence=0,SharedComponent=0,IsFullFile=0)
MSI (s) (FC:08) [08:31:12:871]: Executing op: FileCopy(SourceName=wdrk-bwe.exe|BackupToUrl.exe,SourceCabKey=ENG_RE_BackupToUrl_exe_64,DestName=BackupToUrl.exe,Attributes=512,FileSize=40648,PerTick=65536,,VerifyMedia=1,,,,,CheckCRC=0,Version=13.0.1601.5,Language=0,InstallMode=63176704,,,,,,,)
MSI (s) (FC:08) [08:31:12:871]: File: E:\Program Files\Microsoft SQL Server\MSSQL13.SQLS2016\MSSQL\Binn\BackupToUrl.exe; Overwrite; Won't patch; REINSTALLMODE specifies all files to be overwritten
MSI (s) (FC:08) [08:31:12:871]: Source for file 'wdrk-bwe.exe' is uncompressed, at '\\DBA_Do_Not_Delete\SQL_SERVER_MIGRATION_2016\software\Sql_server_2016_setup\x64\setup\sql_engine_core_inst_msi\PFiles\SqlServr\MSSQL.X\MSSQL\Binn\'.
MSI (s) (FC:08) [08:31:12:871]: Re-applying security from existing file.
MSI (s) (FC:08) [08:31:12:871]: Verifying accessibility of file: BackupToUrl.exe
MSI (s) (FC:08) [08:31:12:871]: Note: 1: 2318 2:
MSI (s) (FC:08) [08:31:12:871]: Note: 1: 2318 2:
MSI (s) (FC:08) [08:31:12:917]: Note: 1: 2318 2: E:\Program Files\Microsoft SQL Server\MSSQL13.SQLS2016\MSSQL\Binn\BackupToUrl.exe
MSI (s) (FC:08) [08:31:12:917]: File will have security applied from OpCode.
MSI (s) (FC:08) [08:31:12:933]: Executing op: SetSourceFolder(Folder=C:\WINDOWS\Installer\$PatchCache$\Managed\7089E3680F79A7149975ED34271A4340\13.0.1601)
MSI (s) (FC:08) [08:31:12:933]: Executing op: RegisterSharedComponentProvider(,,File=ENG_RE_fssres_dll_64,Component={EC18916A-9339-11E0-9BE8-CA1E4924019B},ComponentVersion=2015.130.1601.5,ProductCode={863E9807-97F0-417A-9957-DE4372A13404},ProductVersion=13.0.1601,PatchSize=0,PatchAttributes=0,PatchSequence=0,SharedComponent=0,IsFullFile=0)
MSI (s) (FC:08) [08:31:12:933]: Executing op: FileCopy(SourceName=ENG_RE_fssres_dll_64,SourceCabKey=ENG_RE_fssres_dll_64,DestName=fssres.dll,Attributes=512,FileSize=81600,PerTick=65536,,VerifyMedia=0,,,,,CheckCRC=0,Version=2015.130.1601.5,Language=1033,InstallMode=63176704,,,,,,,)
MSI (s) (FC:08) [08:31:12:933]: File: E:\Program Files\Microsoft SQL Server\MSSQL13.SQLS2016\MSSQL\Binn\fssres.dll; Overwrite; Won't patch; REINSTALLMODE specifies all files to be overwritten
MSI (s) (FC:08) [08:31:12:933]: Source for file 'ENG_RE_fssres_dll_64' is uncompressed, at 'C:\WINDOWS\Installer\$PatchCache$\Managed\7089E3680F79A7149975ED34271A4340\13.0.1601\'.
MSI (s) (FC:08) [08:31:12:933]: Re-applying security from existing file.
MSI (s) (FC:08) [08:31:12:949]: Verifying accessibility of file: fssres.dll
MSI (s) (FC:08) [08:31:12:949]: Note: 1: 2318 2:
MSI (s) (FC:08) [08:31:12:949]: Note: 1: 2318 2:
MSI (s) (FC:08) [08:31:12:949]: Note: 1: 2318 2: E:\Program Files\Microsoft SQL Server\MSSQL13.SQLS2016\MSSQL\Binn\fssres.dll
MSI (s) (FC:08) [08:31:12:949]: File will have security applied from OpCode.
MSI (s) (FC:08) [08:31:12:949]: Executing op: SetTargetFolder(Folder=C:\WINDOWS\Gac)
MSI (s) (FC:08) [08:31:12:949]: Executing op: SetSourceFolder(Folder=1\Windows\Gac)
MSI (s) (FC:08) [08:31:12:949]: Executing op: RegisterSharedComponentProvider(,,File=ENG_RE_Microsoft_SqlServer_Types_GAC_64,Component={86D142D1-7703-430D-AD84-FE49949A11B2},ComponentVersion=2015.130.1601.5,ProductCode={863E9807-97F0-417A-9957-DE4372A13404},ProductVersion=13.0.1601,PatchSize=0,PatchAttributes=0,PatchSequence=0,SharedComponent=1,IsFullFile=0)
MSI (s) (FC:08) [08:31:12:949]: Executing op: AssemblyCopy(SourceName=tgu6l_lw.dll|Microsoft.SqlServer.Types.dll,SourceCabKey=ENG_RE_Microsoft_SqlServer_Types_GAC_64,DestName=Microsoft.SqlServer.Types.dll,Attributes=512,FileSize=391872,PerTick=65536,,VerifyMedia=1,,,,,ComponentId={86D142D1-7703-430D-AD84-FE49949A11B2},IsManifest=1,,,AssemblyMode=1,)
DEBUG: Error 2902: Operation ixfAssemblyCopy called out of sequence.
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2902. The arguments are: ixfAssemblyCopy, ,
MSI (s) (FC:08) [08:31:12:964]: Product: SQL Server 2016 Database Engine Services -- The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2902. The arguments are: ixfAssemblyCopy, ,

MSI (s) (FC:08) [08:31:12:964]: Note: 1: 2265 2: 3: -2147287035

Property(S): SOURCEDIR = \\DBA_Do_Not_Delete\SQL_SERVER_MIGRATION_2016\software\Sql_server_2016_setup\x64\setup\sql_engine_core_inst_msi\
Property(S): SourcedirProduct = {863E9807-97F0-417A-9957-DE4372A13404}
Property(S): InstallNgenTicks = 80000
MSI (s) (FC:08) [08:31:13:058]: Product: SQL Server 2016 Database Engine Services - Update 'Hotfix 5830 for SQL Server Database Services Core Instance (64-bit) (KB4564903)' could not be removed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20210529_082823\SQLS2016\sql_engine_core_inst_Cpu64_1.log.

=== Logging stopped: 5/29/2021 8:31:13 ===
MSI (s) (FC:08) [08:31:13:058]: Windows Installer removed an update. Product Name: SQL Server 2016 Database Engine Services. Product Version: 13.0.1601.5. Product Language: 1033. Manufacturer: Microsoft Corporation. Update Name: Hotfix 5830 for SQL Server Database Services Core Instance (64-bit) (KB4564903). Removal success or error status: 1603.

MSI (s) (FC:08) [08:31:13:058]: Product: SQL Server 2016 Database Engine Services - Update '{0CB615DE-B4C1-4A94-9624-C0AB3F0D61C0}' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20210529_082823\SQLS2016\sql_engine_core_inst_Cpu64_1.log.

MSI (s) (FC:08) [08:31:13:058]: Windows Installer installed an update. Product Name: SQL Server 2016 Database Engine Services. Product Version: 13.0.1601.5. Product Language: 1033. Manufacturer: Microsoft Corporation. Update Name: {0CB615DE-B4C1-4A94-9624-C0AB3F0D61C0}. Installation success or error status: 1603.

MSI (s) (FC:08) [08:31:13:058]: Note: 1: 1729
MSI (s) (FC:08) [08:31:13:058]: Product: SQL Server 2016 Database Engine Services -- Configuration failed.

MSI (s) (FC:08) [08:31:13:058]: Windows Installer reconfigured the product. Product Name: SQL Server 2016 Database Engine Services. Product Version: 13.0.1601.5. Product Language: 1033. Manufacturer: Microsoft Corporation. Reconfiguration success or error status: 1603.

MSI (s) (FC:08) [08:31:13:058]: Attempting to delete file C:\WINDOWS\Installer\2883a4.msp
MSI (s) (FC:08) [08:31:13:074]: Deferring clean up of packages/files, if any exist
MSI (s) (FC:08) [08:31:13:074]: Attempting to delete file C:\WINDOWS\Installer\2883a4.msp
MSI (s) (FC:08) [08:31:13:074]: Unable to delete the file outside of the engine. LastError = 2
MSI (s) (FC:08) [08:31:13:074]: MainEngineThread is returning 1603
MSI (s) (FC:D8) [08:31:13:074]: RESTART MANAGER: Session closed.
MSI (s) (FC:D8) [08:31:13:074]: No System Restore sequence number for this installation.
MSI (s) (FC:D8) [08:31:13:074]: User policy value 'DisableRollback' is 0
MSI (s) (FC:D8) [08:31:13:074]: Machine policy value 'DisableRollback' is 0
MSI (s) (FC:D8) [08:31:13:074]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (FC:D8) [08:31:13:074]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (FC:D8) [08:31:13:074]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (FC:D8) [08:31:13:074]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (FC:D8) [08:31:13:089]: Destroying RemoteAPI object.
MSI (s) (FC:28) [08:31:13:089]: Custom Action Manager thread ending.
MSI (c) (DC:CC) [08:31:13:089]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (DC:CC) [08:31:13:089]: MainEngineThread is returning 1603
MSI (c) (DC:00) [08:31:13:089]: RESTART MANAGER: Session closed.
=== Verbose logging stopped: 5/29/2021 8:31:13 ===

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @NishitShah-6729, we have not get a reply from you. Did the answer could help you? If yes, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @NishitShah-6729,

Welcome to Microsoft Q&A!

Here has a similar issue with yours, see below:


1.From full install SQL Server I copied sqlrun_sql.msi file to "WINDOWS\Installer". And then I changed the name of this file, according to log.
2.From SP2 update source I copied sqlrun_sql.msp to "WINDOWS\Installer". And then I changed the name of this file, according to log.

I suppose my error follows from wrong *.msi file in "WINDOWS\Installer" (from another version of update).


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.