SQL 2016 SP1 CU1，升级到CU2或CU3失败 [英] SQL 2016 SP1 CU1, upgrade to CU2 or CU3 fails
问题描述
你好可爱有帮助的人！
所以我试图在SQL2016 SP1 CU1安装上运行CU3升级。但每次我运行它都会失败。
So I'm trying to run a CU3 upgrade on a SQL2016 SP1 CU1 installation. however every time I run it I get a failure.
错误详情：
§安装SQL Server公共文件时出错
Windows Installer服务无法安装升级，因为要升级的程序可能丢失，或升级可能更新程序的不同版本。验证您的计算机上是否存在要升级的程序，以及
是否具有正确的升级。
错误代码：1642
日志文件：C：\Program Files \ Microsoft SQL Server \130\Setup Bootstrap\Log \ 20170802_102407 \DCL \ _sql_common_core_Cpu64_1.log
访问http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4435.0&EvtType = sql_common_core.msi％400x162A16FE％400x1642以获得有关故障排除的帮助。
需要采取措施：
使用以下解决错误的信息，然后再次尝试设置过程。
功能失败原因：
错误发生了该功能的依赖性，导致该功能的设置过程失败。
Error details:
§ 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\20170802_102407\DCL\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.4435.0&EvtType=sql_common_core.msi%400x162A16FE%400x1642 to get help on troubleshooting.
Action required:
Use the following information to resolve the error, and then try the setup process again.
Feature failure reason:
An error occurred for a dependency of the feature causing the setup process for the feature to fail.
我正在运行SQL 2016 SP1 CU3补丁（并试用了具有相同结果的SP1 CU2）和安装的版本是带有CU1的SQL 2016 SP1，所以它是正确的版本。
I am running the SQL 2016 SP1 CU3 patch (and tried SP1 CU2 with same result) and the installed version is SQL 2016 SP1 with CU1 so it's the correct version.
我查看了上面提到的日志文件并找到了以下内容
I looked into the mentioned log file and found the following
MSI（s）（C8：F0）[10：27：02：439]：Unknown\Absent：{D8187061-3FF7-4121 -8E90-3FCD07B81118} - D：\ c5dc44b1908424ca85017948160b \ x64\setup \sql_common_core_msi \ sql_common_core.msp
MSI（s）（C8：F0）[ 10：27：02：439]：产品：SQL Server 2016公共文件 - 无法安装更新"{D8187061-3FF7-4121-8E90-3FCD07B81118}"。错误代码1642.日志文件C中提供了更多信息：\程序文件\ Microsoft Microsoft SQL Server \ 130'\\设置
Bootstrap\Log \ 20170802_102407 \DCL \ _sql_common_core_Cpu64_1.log。
MSI（s）（C8：F0）[10：27：02：439]：Windows Installer安装了更新。产品名称：SQL Server 2016 Common Files。产品版本：13.0.1601.5。产品语言：1033。制造商：Microsoft Corporation。更新名称：{D8187061-3FF7-4121-8E90-3FCD07B81118}。
安装成功或错误状态：1642。
MSI（s）（C8：F0）[10：27：02：439]：注意：1： 1708
MSI（s）（C8：F0）[10：27：02：439]：产品：SQL Server 2016公共文件 - 安装失败。
MSI（s）（C8：F0）[10：27：02：439]：Windows Installer安装了该产品。产品名称：SQL Server 2016 Common Files。产品版本：13.0.1601.5。产品语言：1033。制造商：Microsoft Corporation。安装成功或错误状态：1642。
MSI（s）（C8：F0）[10：27：02：439]：尝试删除文件C：\ Windows \Installer \ 7086a.msp
MSI（s）（C8：F0）[10：27：02：439]：MainEngineThread返回1642
MSI（C8：BC）[10：27：02：439]：此安装没有系统还原序列号。
Windows Installer服务无法安装升级，因为可能缺少要升级的程序，或者升级可能会更新程序的其他版本。验证您的计算机上是否存在要升级的程序以及
是否具有正确的升级。
MSI (s) (C8:F0) [10:27:02:439]: Unknown\Absent: {D8187061-3FF7-4121-8E90-3FCD07B81118} - D:\c5dc44b1908424ca85017948160b\x64\setup\sql_common_core_msi\sql_common_core.msp
MSI (s) (C8:F0) [10:27:02:439]: Product: SQL Server 2016 Common Files - Update '{D8187061-3FF7-4121-8E90-3FCD07B81118}' 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\20170802_102407\DCL\sql_common_core_Cpu64_1.log.
MSI (s) (C8:F0) [10:27:02:439]: 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: {D8187061-3FF7-4121-8E90-3FCD07B81118}.
Installation success or error status: 1642.
MSI (s) (C8:F0) [10:27:02:439]: Note: 1: 1708
MSI (s) (C8:F0) [10:27:02:439]: Product: SQL Server 2016 Common Files -- Installation failed.
MSI (s) (C8:F0) [10:27:02:439]: 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) (C8:F0) [10:27:02:439]: Attempting to delete file C:\Windows\Installer\7086a.msp
MSI (s) (C8:F0) [10:27:02:439]: MainEngineThread is returning 1642
MSI (s) (C8:BC) [10:27:02:439]: 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.
在挖掘中我发现了以下文章：
In digging about I found the following article:
https://support.microsoft.com/en-us/help/969052/how-to-restore-the-missing-windows-installer-cache-files-and-resolve-p
https://support.microsoft.com/en-us/help/969052/how-to-restore-the-missing-windows-installer-cache-files-and-resolve-p
从运行起我得到以下
=================== ================================================== ===========
产品名称 ：SQL Server 2016公共文件
============================= ================================================== =
产品编号：{57846DA8-8B5D-4466-B850-E8CDFC94046C}
版本     ：13.1.4001.0
最新安装日期：20170216
目标安装位置：
注册表路径：
HKEY_CLASSES_ROOT\Installer \Products\8AD64875D5B866448B058EDCCF4940C6 \SourceList
包装    ：sql_common_core.msi
安装源：\ x64 \setup \sql_common_core_msi \
LastUsedSource：m; 1; E：\ x64 \setup \sql_common_core_msi \
在LastUsedSource路径上存在sql_common_core.msi，无需任何操作。
安装程序缓存文件：C：\ Windows \ Installer \ 3c5d42.msi
软件包存在于安装程序缓存中，无需任何操作。
如果需要，任何遗失的套餐都会自动更新，假设
LastUsedSource存在。
如果您收到有关C：\ Windows \Installer \3c5d42.msi或E：\ x64 \setup \sql_common_core_msi \ sql_common_core.msi的错误，那么您
   可能需要手动复制文件，如果文件存在则替换问题文件，
将以下命令行复制并粘贴到管理命令提示符中：
复制"E：\ x64 \setup \sql_common_core_msi \sql_common_core.msi" C：\ Windows \Installer \3c5d42.msi
================================================================================
PRODUCT NAME : SQL Server 2016 Common Files
================================================================================
Product Code: {57846DA8-8B5D-4466-B850-E8CDFC94046C}
Version : 13.1.4001.0
Most Current Install Date: 20170216
Target Install Location:
Registry Path:
HKEY_CLASSES_ROOT\Installer\Products\8AD64875D5B866448B058EDCCF4940C6\SourceList
Package : sql_common_core.msi
Install Source: \x64\setup\sql_common_core_msi\
LastUsedSource: m;1;E:\x64\setup\sql_common_core_msi\
sql_common_core.msi exists on the LastUsedSource path, no actions needed.
Installer Cache File: C:\Windows\Installer\3c5d42.msi
Package exists in the Installer cache, no actions needed.
Any missing packages will update automatically if needed assuming that
the LastUsedSource exists.
Should you get errors about C:\Windows\Installer\3c5d42.msi or E:\x64\setup\sql_common_core_msi\sql_common_core.msi then you
may need to manually copy the file, if file exists replace the problem file,
Copy and paste the following command line into an administrative command prompt:
Copy "E:\x64\setup\sql_common_core_msi\sql_common_core.msi" C:\Windows\Installer\3c5d42.msi
我相信这一切都很好，我看了并且在C：\ Windows \Installer \3c5d42.msi中有一个文件，它与安装媒体上的文件具有相同的属性。
Which I believe suggests all is well and I've looked and there is a file already at C:\Windows\Installer\3c5d42.msi which has the same properties as the file on the install media.
我在哪里
我还尝试使用SQL 2016 SP1媒体运行修复，但已成功完成，但在尝试重新运行CU3和CU2时再次更新失败。当我现在运行CU3更新时，它显示共享组件的版本号为
CU3，但列出安装状态并且不完整。
I've additionally tried to run a repair with SQL 2016 SP1 media which completed successfully but on trying to re-run the CU3 and CU2 update it again failed. When I do run the CU3 update now it shows the version number for the shared components at that of
CU3 but lists the install status and incomplete.
如果有人有任何想法，我会非常感激，因为我现在不确定该怎么做。
If anyone has any ideas I'd really appreciate it as I'm not really sure what to do next now.
推荐答案
如果您收到有关C：\ Windows \Installer \3c5d42.msi或E：\ x64 \setup \sql_common_core_msi \ sql_common_core.msi的错误，那么您
   可能需要手动复制文件，如果文件存在则替换问题文件，
将以下命令行复制并粘贴到管理命令提示符中：
复制"E：\ x64 \setup \sql_common_core_msi \sql_common_core.msi" C：\ Windows \Installer \3c5d42.msi
这意味着您几乎没有丢失.MSI或.MSP文件。在继续安装之前，您需要解决它们。没有修复无法帮助您解决丢失的MSP或MSI文件。
Which means you have few missing .MSI or .MSP files. Before proceeding to install you need to resolve them. No repair can't help you to resolve the missing MSP or MSI files.
这应该是您早期的SQL安装 - > 复制"E：\ x64 \setup \sql_common_core_msi \sql_common_core.msi"
This should be your earlier SQL Installation --> Copy "E:\x64\setup\sql_common_core_msi\sql_common_core.msi"
根据您示例中的信息 - 我没有看到MSP / MSI文件丢失问题。
As per the piece of info from your example - I don't see missing MSP/MSI file issue.
SQL Server需要安装程序缓存上的早期MSI或MSP文件，以便将来进行SQL升级。
SQL Server needs those earlier MSI or MSP files on Installer cache for future SQL Upgrades.
实际失踪的MSP / MSI如下所示 - 您可以发布您的填充输出
THE ACTUAL MISSING MSP/MSI LOOKS LIKE BELOW AS example - can you please post your fill output
================================================ ================================
产品名称 ：Microsoft SQL Server系统CLR类型
=================================== =============================================
b $ b 产品编号：{C3F6F200-6D7B-4879-B9EE-700C0CE1FCDA}
版本     ：10.51.2500.0
最新安装日期：20160307
$
目标安装位置：
注册表路径：
HKEY_CLASSES_ROOT\Installer \Products\002F6F3CB7D697849BEE07C0C01ECFAD\SourceList
包装    ：SQLSysClrTypes.msi
安装来源：\ 1033_ENU_LP \ redist\VisualStudioShell \SQLSysClrTypes \
LastUsedSource：n; 1; E：\ SQL Server 2012 Enterprise\1033_ENU_LP\redist\VisualStudioShell\SQLSysClrTypes \
!! ！ SQLSysClrTypes.msi不存在于路径E中的路径上：\ SQL Server 2012 Enterprise\1033_ENU_LP\redist\VisualStudioShell\SQLSysClrTypes \ !!!!
需要采取措施，重新建立E：\ SQL Server 2012 Enterprise\1033_ENU_LP\redist\VisualStudioShell \ SQLSysClrTypes \
安装程序缓存文件：C：\ Windows \Installer \\\1428669d.msi
软件包存在于安装程序缓存中，无需任何操作。
如果需要，任何遗失的套餐都会自动更新，假设为
LastUsedSource存在。
如果您收到有关C：\ Windows \Installer \\\1428669d.msi或E：\ SQL Server 2012 Enterprise\1033_ENU_LP\redist\VisualStudioShell\SQLSysClrTypes\SQLSysClrTypes.msi的错误，那么您是否
可能需要手动复制文件，如果文件存在则替换问题文件，
将以下命令行复制并粘贴到管理命令提示符中：
复制"E：\ SQL Server 2012 Enterprise \ 1033_ENU_LP \ Royaltyist \ VisualStudioShell \ SQLSysClrTypes \ SQLSysClrTypes.msi" C：\ Windows \Installer \\\1428669d.msi
Microsoft SQL Server系统CLR类型已安装补丁
================================================================================
PRODUCT NAME : Microsoft SQL Server System CLR Types
================================================================================
Product Code: {C3F6F200-6D7B-4879-B9EE-700C0CE1FCDA}
Version : 10.51.2500.0
Most Current Install Date: 20160307
Target Install Location:
Registry Path:
HKEY_CLASSES_ROOT\Installer\Products\002F6F3CB7D697849BEE07C0C01ECFAD\SourceList
Package : SQLSysClrTypes.msi
Install Source: \1033_ENU_LP\redist\VisualStudioShell\SQLSysClrTypes\
LastUsedSource: n;1;E:\SQL Server 2012 Enterprise\1033_ENU_LP\redist\VisualStudioShell\SQLSysClrTypes\
!!!! SQLSysClrTypes.msi DOES NOT exist on the path in the path E:\SQL Server 2012 Enterprise\1033_ENU_LP\redist\VisualStudioShell\SQLSysClrTypes\ !!!!
Action needed, re-establish the path to E:\SQL Server 2012 Enterprise\1033_ENU_LP\redist\VisualStudioShell\SQLSysClrTypes\
Installer Cache File: C:\Windows\Installer\1428669d.msi
Package exists in the Installer cache, no actions needed.
Any missing packages will update automatically if needed assuming that
the LastUsedSource exists.
Should you get errors about C:\Windows\Installer\1428669d.msi or E:\SQL Server 2012 Enterprise\1033_ENU_LP\redist\VisualStudioShell\SQLSysClrTypes\SQLSysClrTypes.msi then you
may need to manually copy the file, if file exists replace the problem file,
Copy and paste the following command line into an administrative command prompt:
Copy "E:\SQL Server 2012 Enterprise\1033_ENU_LP\redist\VisualStudioShell\SQLSysClrTypes\SQLSysClrTypes.msi" C:\Windows\Installer\1428669d.msi
Microsoft SQL Server System CLR Types Patches Installed
======================================== =============
=====================================================
谢谢，
这篇关于SQL 2016 SP1 CU1，升级到CU2或CU3失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
