issue when I'm try to apply a sql server 2016 Cumulative update 17.

Question

Hi,
Since a couple of day, I try to apply a CU 17 on sql server 2016 on Windows Server 2012 R2 Standard (6.3.9600)(fully updated).
After a lot of research on the internet and testing, I found nothing. Perhaps, you could help me.

So I have an issue to patch with CU17 of sql server 2016. I have an error message

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

The full text file of "Summary_DSISV771_20210613_112501.txt"

Overall summary:
Final result: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.
Exit code (Decimal): -2068052374
Start time: 2021-06-13 11:25:03
End time: 2021-06-13 11:26:22
Requested action: Patch

Instance MSSQLSERVER 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): -2068052374
Start time: 2021-06-13 11:25:43
End time: 2021-06-13 11:26:19
Requested action: Patch

Machine Properties:
Machine name: DSISV771
Machine processor count: 4
OS version: Microsoft Windows Server 2012 R2 Standard (6.3.9600)
OS service pack:
OS region: Belgique
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured
SQL Server 2016 MSSQLSERVER MSSQL13.MSSQLSERVER Database Engine Services 1033 Standard Edition 13.2.5850.14 No Yes
SQL Server 2016 MSSQLSERVER MSAS13.MSSQLSERVER Analysis Services 1033 Standard Edition 13.2.5850.14 No Yes
SQL Server 2016 MSSQLSERVER MSRS13.MSSQLSERVER Reporting Services - Native 1033 Standard Edition 13.2.5850.14 No Yes
SQL Server 2016 Integration Services 1033 Standard Edition 13.2.5850.14 No Yes

Package properties:
Description: Microsoft SQL Server 2016
ProductName: SQL Server 2016
Type: RTM
Version: 13
SPLevel: 2
KBArticle: KB5001092
KBArticleHyperlink: http://support.microsoft.com/?kbid=5001092
PatchType: QFE
AssociatedHotfixBuild: 0
Platform: x64
PatchLevel: 13.2.5888.11
ProductVersion: 13.2.5026.0
GDRReservedRange: 13.0.1700.0:13.0.1899.0;13.0.4200.0:13.0.4299.0;13.0.5200.0:13.0.5399.0
Installation location: E:\3af20431b861b0c974aef9\x64\setup\

Updated product edition:
Instance Edition
MSSQLSERVER Standard

User Input Settings:
ACTION: Patch
ALLINSTANCES: false
CLUSTERPASSIVE: false
CONFIGURATIONFILE:
ENU: false
HELP: false
IACCEPTROPENLICENSETERMS: false
IACCEPTSQLSERVERLICENSETERMS: true
INDICATEPROGRESS: false
INSTANCEID: <empty>
INSTANCENAME: <empty>
MRCACHEDIRECTORY:
QUIET: false
QUIETSIMPLE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
UIMODE: Normal
X86: false

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20210613_112501\SystemConfigurationCheck_Report.htm

So as indicated I was in the file "sql_common_core_Cpu64_1.log"
And I found this

MSI (s) (5C:F8) [11:29:55:665]: Unknown\Absent: {65894312-BF51-4989-886D-1E560F4185B0} - E:\d7cf73a3a46609e23ccecec3137b17f0\x64\setup\sql_common_core_msi\sql_common_core.msp
MSI (s) (5C:F8) [11:29:55:665]: Product: SQL Server 2016 Common Files - Update '{65894312-BF51-4989-886D-1E560F4185B0}' could not be installed. Error code 1642. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20210613_112905\MSSQLSERVER\sql_common_core_Cpu64_1.log.

I searched this guid in registery, I didn't find any reference to it.?

The full file :

=== Verbose logging started: 13-06-21 11:29:55 Build type: SHIP UNICODE 5.00.9600.00 Calling process: E:\d7cf73a3a46609e23ccecec3137b17f0\x64\ScenarioEngine.exe ===
MSI (c) (FC:74) [11:29:55:603]: Resetting cached policy values
MSI (c) (FC:74) [11:29:55:603]: Machine policy value 'Debug' is 0
MSI (c) (FC:74) [11:29:55:603]: ******* RunEngine:
******* Product: {57846DA8-8B5D-4466-B850-E8CDFC94046C}
******* Action:
******* CommandLine: **********
MSI (c) (FC:74) [11:29:55:603]: Client-side and UI is none or basic: Running entire install on the server.>
MSI (c) (FC:74) [11:29:55:603]: Grabbed execution mutex.
MSI (c) (FC:74) [11:29:55:603]: Cloaking enabled.
MSI (c) (FC:74) [11:29:55:603]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (FC:74) [11:29:55:603]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (5C:C4) [11:29:55:603]: Running installation inside multi-package transaction {57846DA8-8B5D-4466-B850-E8CDFC94046C}
MSI (s) (5C:C4) [11:29:55:603]: Grabbed execution mutex.
MSI (s) (5C:F8) [11:29:55:603]: Resetting cached policy values
MSI (s) (5C:F8) [11:29:55:603]: Machine policy value 'Debug' is 0
MSI (s) (5C:F8) [11:29:55:603]: ******* RunEngine:
******* Product: {57846DA8-8B5D-4466-B850-E8CDFC94046C}
******* Action:
******* CommandLine: **********
MSI (s) (5C:F8) [11:29:55:603]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (5C:F8) [11:29:55:603]: Note: 1: 2203 2: C:\Windows\Installer\inprogressinstallinfo.ipi 3: -2147287038
MSI (s) (5C:F8) [11:29:55:603]: SRSetRestorePoint skipped for this transaction.
MSI (s) (5C:F8) [11:29:55:603]: MSCOREE not loaded loading copy from system32
MSI (s) (5C:F8) [11:29:55:603]: End dialog not enabled
MSI (s) (5C:F8) [11:29:55:603]: Original package ==> C:\Windows\Installer\acd20.msi
MSI (s) (5C:F8) [11:29:55:603]: Package we're running from ==> C:\Windows\Installer\acd20.msi
MSI (s) (5C:F8) [11:29:55:603]: APPCOMPAT: Uninstall Flags override found.
MSI (s) (5C:F8) [11:29:55:603]: APPCOMPAT: Uninstall VersionNT override found.
MSI (s) (5C:F8) [11:29:55:603]: APPCOMPAT: Uninstall ServicePackLevel override found.
MSI (s) (5C:F8) [11:29:55:603]: APPCOMPAT: looking for appcompat database entry with ProductCode '{57846DA8-8B5D-4466-B850-E8CDFC94046C}'.
MSI (s) (5C:F8) [11:29:55:603]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (5C:F8) [11:29:55:634]: File will have security applied from OpCode.
MSI (s) (5C:F8) [11:29:55:650]: Original patch ==> E:\d7cf73a3a46609e23ccecec3137b17f0\x64\setup\sql_common_core_msi\sql_common_core.msp
MSI (s) (5C:F8) [11:29:55:650]: Patch we're running from ==> C:\Windows\Installer\21ff0.msp
MSI (s) (5C:F8) [11:29:55:650]: SOFTWARE RESTRICTION POLICY: Verifying patch --> 'E:\d7cf73a3a46609e23ccecec3137b17f0\x64\setup\sql_common_core_msi\sql_common_core.msp' against software restriction policy
MSI (s) (5C:F8) [11:29:55:650]: SOFTWARE RESTRICTION POLICY: E:\d7cf73a3a46609e23ccecec3137b17f0\x64\setup\sql_common_core_msi\sql_common_core.msp has a digital signature
MSI (s) (5C:F8) [11:29:55:665]: SOFTWARE RESTRICTION POLICY: E:\d7cf73a3a46609e23ccecec3137b17f0\x64\setup\sql_common_core_msi\sql_common_core.msp is permitted to run at the 'unrestricted' authorization level.
MSI (s) (5C:F8) [11:29:55:665]: SequencePatches starts. Product code: {57846DA8-8B5D-4466-B850-E8CDFC94046C}, Product version: 13.0.1601.5, Upgrade code: {F2F6463E-EE2A-4C0B-B399-F550C887354A}, Product language 1033
MSI (s) (5C:F8) [11:29:55:665]: PATCH SEQUENCER: verifying the applicability of QFE patch E:\d7cf73a3a46609e23ccecec3137b17f0\x64\setup\sql_common_core_msi\sql_common_core.msp against product code: {57846DA8-8B5D-4466-B850-E8CDFC94046C}, product version: 13.0.1601.5, product language 1033 and upgrade code: {F2F6463E-EE2A-4C0B-B399-F550C887354A}
MSI (s) (5C:F8) [11:29:55:665]: PATCH SEQUENCER: QFE patch E:\d7cf73a3a46609e23ccecec3137b17f0\x64\setup\sql_common_core_msi\sql_common_core.msp is not applicable.
MSI (s) (5C:F8) [11:29:55:665]: SequencePatches returns success.
MSI (s) (5C:F8) [11:29:55:665]: Final Patch Application Order:
MSI (s) (5C:F8) [11:29:55:665]: Other Patches:
MSI (s) (5C:F8) [11:29:55:665]: Unknown\Absent: {65894312-BF51-4989-886D-1E560F4185B0} - E:\d7cf73a3a46609e23ccecec3137b17f0\x64\setup\sql_common_core_msi\sql_common_core.msp
MSI (s) (5C:F8) [11:29:55:665]: Product: SQL Server 2016 Common Files - Update '{65894312-BF51-4989-886D-1E560F4185B0}' could not be installed. Error code 1642. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20210613_112905\MSSQLSERVER\sql_common_core_Cpu64_1.log.

>

MSI (s) (5C:F8) [11:29:55:665]: Windows Installer installed an update. Product Name: SQL Server 2016 Common Files. Product Version: 13.0.1601.5. Product Language: 1033. Manufacturer: Microsoft Corporation. Update Name: {65894312-BF51-4989-886D-1E560F4185B0}. Installation success or error status: 1642.

>

MSI (s) (5C:F8) [11:29:55:665]: Note: 1: 1708
MSI (s) (5C:F8) [11:29:55:665]: Product: SQL Server 2016 Common Files -- Installation failed.

>

MSI (s) (5C:F8) [11:29:55:665]: Windows Installer installed the product. Product Name: SQL Server 2016 Common Files. Product Version: 13.0.1601.5. Product Language: 1033. Manufacturer: Microsoft Corporation. Installation success or error status: 1642.

>

MSI (s) (5C:F8) [11:29:55:665]: Attempting to delete file C:\Windows\Installer\21ff0.msp
MSI (s) (5C:F8) [11:29:55:665]: MainEngineThread is returning 1642
MSI (s) (5C:C4) [11:29:55:665]: No System Restore sequence number for this installation.
The upgrade cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade.
C:\Windows\Installer\acd20.msi
MSI (s) (5C:C4) [11:29:55:681]: User policy value 'DisableRollback' is 0
MSI (s) (5C:C4) [11:29:55:681]: Machine policy value 'DisableRollback' is 0
MSI (s) (5C:C4) [11:29:55:681]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (5C:C4) [11:29:55:681]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (5C:C4) [11:29:55:681]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (5C:C4) [11:29:55:681]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (FC:74) [11:29:55:681]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (FC:74) [11:29:55:681]: MainEngineThread is returning 1642
=== Verbose logging stopped: 13-06-21 11:29:55 ===

The only thing that was done between the two previous cu, an old version of ssms was uninstalled(16). I tried to re-install it but it doesn't change anything.

Does anyone have any suggestions to solve my issue withtout a re-installation?

Thanks in advance

Answer 1

Hi @zoltix ,

> Windows Installer installed an update. Product Name: SQL Server 2016 Common Files. Product Version: 13.0.1601.5. Product Language: 1033. Manufacturer: Microsoft Corporation. Update Name: {65894312-BF51-4989-886D-1E560F4185B0}. Installation success or error status: 1642.

According to the message, you are upgrading from SQL Server 2016 RTM not SQL Server 2016 SP2. But from the summary log you posted, you have installed SQL Server 2016 SP2. Is that right?

Could you try to uninstall the patch from control panel and also uninstall SP2? Then reinstall SP2 and apply the CU17 for SQL Server 2016 SP2.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
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.

Answer 2

that's mean, I need to uninstall all cu from sp2 and sp2.
that's right ?