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

  • 问题

  • 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
    2011年1月19日 2:01

答案

  • 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
    2011年1月24日 9:55

全部回复