none
MS SQL Server 2016 Can't Install SP2 CU Updates: Error -2068052374 RRS feed

  • Question

  • Hello,

    I'm working with a SCVMM 2016 server that has SQL 2016 installed on the same system.  Everything at the OS and SCVMM level patches no problem and is fully up to date.  However, I can't apply the SQL SP 2 CU update.  Either CU2 or CU6.  Any thoughts would be appreicated. Below are the logs and what all I have tried.

    Thanks,
    Brad

    When I try updating:
    An error occurred for a dependency of the feature causing the setup process for the feature to fail.

    Error installing SQL Server Common Files
    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.
    Error code: 1642
    Log file: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20190420_133826\MSSQLSERVER\sql_common_core_Cpu64_1.log
    Visit http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.5292.0&EvtType=sql_common_core.msi%400x162A16FE%400x1642 to get help on troubleshooting.

    In the log file:
    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:                    2019-04-20 13:38:31
      End time:                      2019-04-20 13:40:58
      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:                    2019-04-20 13:40:16
      End time:                      2019-04-20 13:40:51
      Requested action:              Patch

    Machine Properties:
      Machine name:                  VMM01
      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:                  No

    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered  Configured
      SQL Server 2016      MSSQLSERVER          MSSQL13.VMM01                  Database Engine Services                 1033                 Standard Edition     13.2.5149.0     No         Yes       
      SQL Server 2016                                                          SSMS                                     1033                                      13.0.15000.23   No         Yes       
      SQL Server 2016                                                          Client Tools Connectivity                1033                                      13.0.14500.10   No         Yes       
      SQL Server 2016                                                          Client Tools Backwards Compatibility     1033                                      13.0.14500.10   No         Yes       
      SQL Server 2016                                                          Client Tools SDK                         1033                                      13.0.14500.10   No         Yes       

    Package properties:
      Description:                   Microsoft SQL Server 2016
      ProductName:                   SQL Server 2016
      Type:                          RTM
      Version:                       13
      SPLevel:                       2
      KBArticle:                     KB4488536
      KBArticleHyperlink:            http://support.microsoft.com/?kbid=4488536
      PatchType:                     QFE
      AssociatedHotfixBuild:         0
      Platform:                      x64
      PatchLevel:                    13.2.5292.0
      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:         F:\abd9fbad1f3b07b00aec0137\x64\setup\

    Updated product edition:
      Instance             Edition             
      MSSQLSERVER          Standard            

    User Input Settings:
      ACTION:                        Patch
      ALLINSTANCES:                  false
      CLUSTERPASSIVE:                false
      CONFIGURATIONFILE:             
      ENU:                           true
      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\20190420_133826\SystemConfigurationCheck_Report.htm

    What I have tried:
    • Rebooting
    • Installing from the WSUS server
    • Installing from the standalone package (SQLServer2016-KB4488536-x64.exe).
    • I tried the repair process outline in this MS article that poined to this MS article. Everything passed with no problems during the repair.
    Tuesday, April 23, 2019 2:10 PM

Answers

  • Hi,

    >>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

    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 CU6 for SQL Server 2016 SP2.

    Best Regards,
    Puzzle
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    • Edited by Puzzle_Chen Thursday, April 25, 2019 2:50 AM
    • Marked as answer by Brad_Jackson Monday, April 29, 2019 1:14 PM
    Thursday, April 25, 2019 2:47 AM

All replies

  • Hi Brad_Jackson,

    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.
    Error code: 1642
    Log file: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20190420_133826\MSSQLSERVER\sql_common_core_Cpu64_1.log
    Could you check the log file to see if it contains more message? And here is a similar thread. See if it can help.
    SQL SERVER – The Patch Installer has Failed to Update the Shared Features


    Best Regards,
    Puzzle
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, April 24, 2019 2:13 AM
  • 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.

    check there is updated patches on server.


    https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx

    Wednesday, April 24, 2019 6:26 AM
  • Hi Puzzle,

    Thank you for your reply. I had looked at that link before. When I run net helpms 1642 it just tells me that something is missing or the wrong version. In the link you provided, how did you determine that is was VSS? I don't see anything like that in any of my log files unless it is SQL Serve 2016 Common Files, but I've already mounted the base SQL 2016 ISO and run a repair.

    The only thing I can think of is that my SQL server is staying it's version 13.2, but everything online says 13.0.

    Thanks for your help.

    Conents of Log file: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20190420_133826\MSSQLSERVER\sql_common_core_Cpu64_1.log

    === Verbose logging started: 4/20/2019  13:40:45  Build type: SHIP UNICODE 5.00.10011.00  Calling process: F:\abd9fbad1f3b07b00aec0137\x64\ScenarioEngine.exe ===
    MSI (c) (84:4C) [13:40:45:233]: Resetting cached policy values
    MSI (c) (84:4C) [13:40:45:233]: Machine policy value 'Debug' is 0
    MSI (c) (84:4C) [13:40:45:233]: ******* RunEngine:
               ******* Product: {57846DA8-8B5D-4466-B850-E8CDFC94046C}
               ******* Action: 
               ******* CommandLine: **********
    MSI (c) (84:4C) [13:40:45:233]: Client-side and UI is none or basic: Running entire install on the server.
    MSI (c) (84:4C) [13:40:45:233]: Grabbed execution mutex.
    MSI (c) (84:4C) [13:40:45:233]: Cloaking enabled.
    MSI (c) (84:4C) [13:40:45:233]: Attempting to enable all disabled privileges before calling Install on Server
    MSI (c) (84:4C) [13:40:45:233]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (3C:BC) [13:40:45:233]: Running installation inside multi-package transaction {57846DA8-8B5D-4466-B850-E8CDFC94046C}
    MSI (s) (3C:BC) [13:40:45:233]: Grabbed execution mutex.
    MSI (s) (3C:7C) [13:40:45:233]: Resetting cached policy values
    MSI (s) (3C:7C) [13:40:45:233]: Machine policy value 'Debug' is 0
    MSI (s) (3C:7C) [13:40:45:233]: ******* RunEngine:
               ******* Product: {57846DA8-8B5D-4466-B850-E8CDFC94046C}
               ******* Action: 
               ******* CommandLine: **********
    MSI (s) (3C:7C) [13:40:45:233]: Machine policy value 'DisableUserInstalls' is 0
    MSI (s) (3C:7C) [13:40:45:249]: Note: 1: 2203 2: C:\Windows\Installer\inprogressinstallinfo.ipi 3: -2147287038 
    MSI (s) (3C:7C) [13:40:45:249]: SRSetRestorePoint skipped for this transaction.
    MSI (s) (3C:7C) [13:40:45:249]: End dialog not enabled
    MSI (s) (3C:7C) [13:40:45:249]: Original package ==> C:\Windows\Installer\f5f346.msi
    MSI (s) (3C:7C) [13:40:45:249]: Package we're running from ==> C:\Windows\Installer\f5f346.msi
    MSI (s) (3C:7C) [13:40:45:249]: APPCOMPAT: Uninstall Flags override found.
    MSI (s) (3C:7C) [13:40:45:249]: APPCOMPAT: Uninstall VersionNT override found.
    MSI (s) (3C:7C) [13:40:45:249]: APPCOMPAT: Uninstall ServicePackLevel override found.
    MSI (s) (3C:7C) [13:40:45:249]: APPCOMPAT: looking for appcompat database entry with ProductCode '{57846DA8-8B5D-4466-B850-E8CDFC94046C}'.
    MSI (s) (3C:7C) [13:40:45:249]: APPCOMPAT: no matching ProductCode found in database.
    MSI (s) (3C:7C) [13:40:45:249]: File will have security applied from OpCode.
    MSI (s) (3C:7C) [13:40:45:249]: Original patch ==> F:\abd9fbad1f3b07b00aec0137\x64\setup\sql_common_core_msi\sql_common_core.msp
    MSI (s) (3C:7C) [13:40:45:249]: Patch we're running from ==> C:\Windows\Installer\ca157.msp
    MSI (s) (3C:7C) [13:40:45:249]: SOFTWARE RESTRICTION POLICY: Verifying patch --> 'F:\abd9fbad1f3b07b00aec0137\x64\setup\sql_common_core_msi\sql_common_core.msp' against software restriction policy
    MSI (s) (3C:7C) [13:40:45:249]: SOFTWARE RESTRICTION POLICY: F:\abd9fbad1f3b07b00aec0137\x64\setup\sql_common_core_msi\sql_common_core.msp has a digital signature
    MSI (s) (3C:7C) [13:40:45:296]: SOFTWARE RESTRICTION POLICY: F:\abd9fbad1f3b07b00aec0137\x64\setup\sql_common_core_msi\sql_common_core.msp is permitted to run at the 'unrestricted' authorization level.
    MSI (s) (3C:7C) [13:40:45:296]: 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) (3C:7C) [13:40:45:296]: PATCH SEQUENCER: verifying the applicability of QFE patch F:\abd9fbad1f3b07b00aec0137\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) (3C:7C) [13:40:45:296]: PATCH SEQUENCER: QFE patch F:\abd9fbad1f3b07b00aec0137\x64\setup\sql_common_core_msi\sql_common_core.msp is not applicable.
    MSI (s) (3C:7C) [13:40:45:296]: SequencePatches returns success.
    MSI (s) (3C:7C) [13:40:45:296]: Final Patch Application Order:
    MSI (s) (3C:7C) [13:40:45:296]: Other Patches:
    MSI (s) (3C:7C) [13:40:45:296]: Unknown\Absent: {90A70B89-83E5-430F-8E48-2FC0E8D600CE} - F:\abd9fbad1f3b07b00aec0137\x64\setup\sql_common_core_msi\sql_common_core.msp
    MSI (s) (3C:7C) [13:40:45:296]: Product: SQL Server 2016 Common Files - Update '{90A70B89-83E5-430F-8E48-2FC0E8D600CE}' 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\20190420_133826\MSSQLSERVER\sql_common_core_Cpu64_1.log.
    
    MSI (s) (3C:7C) [13:40:45:296]: 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: {90A70B89-83E5-430F-8E48-2FC0E8D600CE}. Installation success or error status: 1642.
    
    MSI (s) (3C:7C) [13:40:45:296]: Note: 1: 1708 
    MSI (s) (3C:7C) [13:40:45:296]: Product: SQL Server 2016 Common Files -- Installation failed.
    
    MSI (s) (3C:7C) [13:40:45:296]: 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) (3C:7C) [13:40:45:296]: Attempting to delete file C:\Windows\Installer\ca157.msp
    MSI (s) (3C:7C) [13:40:45:296]: MainEngineThread is returning 1642
    MSI (s) (3C:BC) [13:40:45:296]: 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\f5f346.msi
    MSI (s) (3C:BC) [13:40:45:296]: User policy value 'DisableRollback' is 0
    MSI (s) (3C:BC) [13:40:45:296]: Machine policy value 'DisableRollback' is 0
    MSI (s) (3C:BC) [13:40:45:296]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (3C:BC) [13:40:45:296]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 
    MSI (s) (3C:BC) [13:40:45:296]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 
    MSI (s) (3C:BC) [13:40:45:296]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (84:4C) [13:40:45:296]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (84:4C) [13:40:45:296]: MainEngineThread is returning 1642
    === Verbose logging stopped: 4/20/2019  13:40:45 ===
    
    


    Wednesday, April 24, 2019 3:31 PM
  • Hi Av111,

    This is a Windows deployment and not a Linux deployment, but thank you for trying to help.

    Thanks,
    Brad

    Wednesday, April 24, 2019 3:32 PM
  • check msi file are missing..try different setup or use different machine.

    https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx

    Wednesday, April 24, 2019 5:22 PM
  • Hi,

    >>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

    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 CU6 for SQL Server 2016 SP2.

    Best Regards,
    Puzzle
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    • Edited by Puzzle_Chen Thursday, April 25, 2019 2:50 AM
    • Marked as answer by Brad_Jackson Monday, April 29, 2019 1:14 PM
    Thursday, April 25, 2019 2:47 AM
  • Puzzle,

    Yes, that is how I understand it as well.  I have SP2 installed according to my "Installed Updates" in Control Panel along with a bunch of hotfixes.

    Browser for SQL Server 2016:
    Hotfix 5292
    SP2

    Microsoft SQL Server 2016:
    Hotfix 5292
    Hotfix 5201
    Hotfix 5216
    Hotfix 5153
    Hotfix 5149
    SP2

    Microsoft VSS Writer for SQL Server:
    Hotfix 5292
    SP2

    I'll arrange for an outage this weekend, maybe early tomorrow morning, and pull all of the hot fixes off first and then SP2.

    Thanks,
    Brad

    Thursday, April 25, 2019 4:59 PM
  • I will wait for your update:-)

    If you resolve your issue, please close the thread by marking the useful reply as answer.

    In addition, if you have another questions, please feel free to ask.

    Thanks for your contribution.

    Best Regards,
    Puzzle
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Friday, April 26, 2019 2:37 AM
  • Puzzle,

    I owe you one, and then some.  Steps I took to resole it based on your recommendation.

    1) Uninstalled all hot fixes from control panel.  This took a little bit because they wouldn't uninstall in the order that they were installed in.  I had to keep trying different ones until they all uninstalled.
    2) Once down to only SP2 being listed, I attempted to run the SP2 update. This failed and listed an MSI that it couldn't find.  This was better progress as I hadn't had any specific clues yet.
    3) I then removed SP2 itself.  This completed successfully.
    4) I then installed SP2 without any problems.
    5) I then installed SP2 CU 6 without any problems!!!
    6) I had to then restart VMM to have it reconnect to SQL.

    In the end, what you listed was exactly what needed to happen.  Uninstall all hotfixes and SP2. Reinstall SP2. Install the CU update!

    Thank you again for your help.

    Brad

    Monday, April 29, 2019 1:14 PM