积极答复者
Can't Upgrade SQL Server 2005 SP3 to SP4, error code 1642

问题
-
I download SP4 from support.microsoft.com, and run it on some servers. 2 of servers upgrade success (sp1 upgrade to sp4, and sp2 upgrade to sp4), and others upgrade failed (sp3 upgrade to sp4.) pls give me some advise.
the version is: SQL Server 2005 enterprise version x64, on windows server 2003 enterprise x64 sp2
here is the log:
SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log:
=== Verbose logging started: 2011-1-11 3:15:45 Build type: SHIP UNICODE 3.01.4000.3959 Calling process: d:\81cde445501f6af1ba76\hotfix.exe ===
MSI (c) (CC:F0) [03:15:45:890]: Resetting cached policy values
MSI (c) (CC:F0) [03:15:45:890]: Machine policy value 'Debug' is 0
MSI (c) (CC:F0) [03:15:45:890]: ******* RunEngine:
******* Product: {9434830F-81E9-408B-9B71-84462764D6FB}
******* Action:
******* CommandLine: **********
MSI (c) (CC:F0) [03:15:45:890]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (CC:F0) [03:15:45:890]: Grabbed execution mutex.
MSI (c) (CC:F0) [03:15:45:890]: Cloaking enabled.
MSI (c) (CC:F0) [03:15:45:890]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (CC:F0) [03:15:45:890]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (04:F0) [03:15:45:890]: Grabbed execution mutex.
MSI (s) (04:F0) [03:15:45:890]: Resetting cached policy values
MSI (s) (04:F0) [03:15:45:890]: Machine policy value 'Debug' is 0
MSI (s) (04:F0) [03:15:45:890]: ******* RunEngine:
******* Product: {9434830F-81E9-408B-9B71-84462764D6FB}
******* Action:
******* CommandLine: **********
MSI (s) (04:F0) [03:15:45:890]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (04:F0) [03:15:45:890]: Adding MSIINSTANCEGUID to command line.
MSI (s) (04:F0) [03:15:45:952]: End dialog not enabled
MSI (s) (04:F0) [03:15:45:952]: Original package ==> C:\WINDOWS\Installer\41c2baa.msi
MSI (s) (04:F0) [03:15:45:952]: Package we're running from ==> C:\WINDOWS\Installer\41c2baa.msi
MSI (s) (04:F0) [03:15:46:030]: APPCOMPAT: looking for appcompat database entry with ProductCode '{9434830F-81E9-408B-9B71-84462764D6FB}'.
MSI (s) (04:F0) [03:15:46:030]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (04:F0) [03:15:46:030]: Detected that this product uses a multiple instance transform.
MSI (s) (04:F0) [03:15:46:030]: MSCOREE already loaded, using loaded copy
MSI (s) (04:F0) [03:15:46:030]: Applying multiple instance transform ':SqlRun01.mst'...
MSI (s) (04:F0) [03:15:46:030]: Looking for storage transform: SqlRun01.mst
MSI (s) (04:F0) [03:15:46:030]: Validating transform 'SqlRun01.mst' with validation bits 0x809
MSI (s) (04:F0) [03:15:46:030]: Transform 'SqlRun01.mst' is valid.
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2205 2: 3: Patch
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary.
MSI (s) (04:F0) [03:15:46:030]: TRANSFORM: Applying regular transform to database.
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _Validation 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Upgrade 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: RegLocator 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: AppSearch 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: CompLocator 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Binary 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: CustomAction 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Directory 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Registry 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Condition 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: CreateFolder 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Icon 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: InstallUISequence 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: AdminUISequence 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: AdvtUISequence 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlAction 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlActionsModule 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlDriveType 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ReserveCost 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: TypeLib 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Feature 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: MsiAssembly 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ServiceControl 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ModuleDependency 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ModuleSignature 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ModuleExclusion 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ModuleComponents 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlBuiltInAccounts 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ServiceInstall 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlPropertyValues 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlUserSecurity 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlRegistry 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlServiceControl 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlHiveCopy 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlRegSecurity 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlGroup 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlGroupMember 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlConfig 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlUpgradeScript 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlHotfixScript 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlScript 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ActionText 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlSku 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlStart 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlServiceAccount 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlEquivalent 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlWizardSequence 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Dialog 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlMofcomp 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlWMISecurity 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlInstanceComponents 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlAssembly 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlPerfCounters 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlCollation 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlExecutable 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlFileSR 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlUnmanagedComponent 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlUpgradeComponent 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlProducts 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlTopLevelFeatureProducts 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlFileRename 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlLocalServers 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlServiceState 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlServiceProperty 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlServiceConfig 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlDomainGroup 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: FeatureComponents 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Control 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ControlEvent 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ControlCondition 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ListView 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: CheckBox 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: EventMapping 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: RadioButton 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: TextStyle 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: UIText 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Shortcut 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: SxsMsmGenComponents 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: MsiSFCBypass 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: RemoveFile 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: RemoveRegistry 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: Environment 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlUpgradeFile 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlUpgradeRegistry 3: -2147287038
MSI (s) (04:F0) [03:15:46:030]: Note: 1: 2262 2: _sqlUpgradeFolders 3: -2147287038
MSI (s) (04:F0) [03:15:46:046]: Note: 1: 2262 2: _sqlRanuInstanceShutdown 3: -2147287038
MSI (s) (04:F0) [03:15:46:046]: Note: 1: 2262 2: _MsiPatchTransformView 3: -2147287038
MSI (s) (04:F0) [03:15:46:046]: File will have security applied from OpCode.
MSI (s) (04:F0) [03:15:46:327]: Original patch ==> d:\81cde445501f6af1ba76\HotFixSQL\Files\sqlrun_sql.msp
MSI (s) (04:F0) [03:15:46:327]: Patch we're running from ==> C:\WINDOWS\Installer\a743e3ef.msp
MSI (s) (04:F0) [03:15:46:327]: SOFTWARE RESTRICTION POLICY: Verifying patch --> 'd:\81cde445501f6af1ba76\HotFixSQL\Files\sqlrun_sql.msp' against software restriction policy
MSI (s) (04:F0) [03:15:46:327]: Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (s) (04:F0) [03:15:46:327]: SOFTWARE RESTRICTION POLICY: d:\81cde445501f6af1ba76\HotFixSQL\Files\sqlrun_sql.msp is not digitally signed
MSI (s) (04:F0) [03:15:46:327]: SOFTWARE RESTRICTION POLICY: d:\81cde445501f6af1ba76\HotFixSQL\Files\sqlrun_sql.msp is permitted to run at the 'unrestricted' authorization level.
MSI (s) (04:F0) [03:15:46:327]: SequencePatches starts. Product code: {9434830F-81E9-408B-9B71-84462764D6FB}, Product version: 9.3.4035.00, Upgrade code: {12EEFC9F-91FB-490B-B00B-7164C31C1650}, Product language 2052
MSI (s) (04:F0) [03:15:46:327]: PATCH SEQUENCER WARNING: d:\81cde445501f6af1ba76\HotFixSQL\Files\sqlrun_sql.msp patch will not be sequenced because it does not contain any transform that may apply to product!
MSI (s) (04:F0) [03:15:46:327]: SequencePatches returns success.
MSI (s) (04:F0) [03:15:46:327]: Final Patch Application Order:
MSI (s) (04:F0) [03:15:46:327]: Other Patches:
MSI (s) (04:F0) [03:15:46:327]: Unknown\Absent: {348C8C91-5842-433A-A7B1-27F004AA14DE} - d:\81cde445501f6af1ba76\HotFixSQL\Files\sqlrun_sql.msp
MSI (s) (04:F0) [03:15:46:343]: 产品: Microsoft SQL Server 2005 (64 位) - 无法安装更新 '{348C8C91-5842-433A-A7B1-27F004AA14DE}'。错误码 1642。可以在日志文件 C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log 中找到其他信息。MSI (s) (04:F0) [03:15:46:343]: Note: 1: 1708
MSI (s) (04:F0) [03:15:46:343]: Note: 1: 2729
MSI (s) (04:F0) [03:15:46:343]: Note: 1: 2729
MSI (s) (04:F0) [03:15:46:343]: 产品: Microsoft SQL Server 2005 (64 位) -- 安装失败。MSI (s) (04:F0) [03:15:46:358]: Attempting to delete file C:\WINDOWS\Installer\a743e3ef.msp
MSI (s) (04:F0) [03:15:46:358]: MainEngineThread is returning 1642
Windows Installer 服务无法安装升级修补程序,因为被升级的程序可能会丢失或是升级修补程序可能更新此程序的一个不同版本。请确认要被升级的程序在您的计算机上且您的升级修补程序是正确的。
C:\WINDOWS\Installer\41c2baa.msi
MSI (c) (CC:F0) [03:15:46:358]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (CC:F0) [03:15:46:358]: MainEngineThread is returning 1642
=== Verbose logging stopped: 2011-1-11 3:15:46 ===- 已编辑 xuzhiwei 2011年1月19日 2:06 add content
答案
-
This problem most likely is caused by incomplete SP3 installation previously, which led to some registry keys information corrupt. The fix steps are complex and unlikely to be done via forum. It is recommended that you call Microsoft support center since your servers are on production.
- 已标记为答案 Mog Liang 2011年2月7日 6:35
全部回复
-
select @@version;
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
I checked installation log files on each server which upgrade failed (sp3 to sp4), they are same.
-
Check this link: http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/6f56ba65-0fec-4ed2-bc03-a469323b35a0, it may help sp4 installation too.
-
This problem most likely is caused by incomplete SP3 installation previously, which led to some registry keys information corrupt. The fix steps are complex and unlikely to be done via forum. It is recommended that you call Microsoft support center since your servers are on production.
- 已标记为答案 Mog Liang 2011年2月7日 6:35