Can't Upgrade SQL Server 2005 SP3 to SP4, error code 1642

Question

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

 

Answer 1

Can you post result of 'select @@version' from that server? Did you check other installation log files?

Answer 2

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.

Answer 3

Check this link: http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/6f56ba65-0fec-4ed2-bc03-a469323b35a0, it may help sp4 installation too.

Answer 4

thanks for you reply, but i don't find a way to resolve this problem, may be it's not the same problem.

Answer 5

What did you try so far?

Answer 6

I don't know what operation you adivce me to do. my SQL Server is on-line service, so i need to know the reason exactly then i can apply to off-line the service and upgrade again.

Answer 7

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.

Answer 8

Please try to re-install SP3 and then patch SP4. This may be caused by incomplate SP3 instalation or corruption of SP3

---

This posting is provided "AS IS" with no warranties, and confers no rights.