Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL 2005 SP3 Upgrade 4262 from 3233 Failing

Author  Topic 

barnes_53
Starting Member

2 Posts
Posted - 2010-03-15 : 19:04:08
I have recently upgraded SQL 2005 from SP2 (version 3233) to SP3 (version 4262). I had some issues at first becasue some .msi and .msp files appeared to have been removed in the past to free up some space on the hard drive. After two days of resolving it I was able to get all of the services to update to SP3 (4262) except Integrated Services and Client Components. I have exhausted everything availble to resolve this and now it is beyond my technical capability. I have copied some of the log files below. I am respectfully requesting some assistance in in this matter if at all possible. Thank you.


----------------------------------------------------------------------------------------------------------------------------------------
DTS9_Hotfix_KB955706_sqlrun_dts.msp.log (100 lines above RETURN VALUE 3 and 100 lines below RETURN VALUE 3)
----------------------------------------------------------------------------------------------------------------------------------------


<Func Name='LaunchFunction'>
MSI (s) (3C!94) [14:19:33:636]: Transforming table _sqlAction.

MSI (s) (3C!94) [14:19:33:636]: Transforming table _sqlAction.

MSI (s) (3C!94) [14:19:33:636]: Note: 1: 2262 2: _sqlAction 3: -2147287038
Function=RestoreProductID
MSI (s) (3C!94) [14:19:33:761]: Transforming table _sqlAction.

MSI (s) (3C!94) [14:19:33:761]: Transforming table _sqlAction.

MSI (s) (3C!94) [14:19:33:761]: Note: 1: 2262 2: _sqlAction 3: -2147287038
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: RestoreProductID
PerfTime Start: RestoreProductID : Fri Mar 12 14:19:33 2010
<Func Name='RestoreProductID'>
MSI (s) (3C!94) [14:19:33:855]: PROPERTY CHANGE: Adding DigitalProductID property. Its value is '**********'.
MSI (s) (3C!94) [14:19:33:855]: PROPERTY CHANGE: Adding PID property. Its value is '**********'.
MSI (s) (3C!94) [14:19:33:855]: PROPERTY CHANGE: Adding DPID property. Its value is '**********'.
<EndFunc Name='RestoreProductID' Return='0' GetLastError='0'>
PerfTime Stop: RestoreProductID : Fri Mar 12 14:19:33 2010
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (3C:9C) [14:19:33:886]: Skipping action: SetShowPID (condition is false)
MSI (s) (3C:9C) [14:19:33:886]: Skipping action: ValidatePID (condition is false)
MSI (s) (3C:9C) [14:19:33:886]: Skipping action: DetectProductID (condition is false)
MSI (s) (3C:9C) [14:19:33:886]: Doing action: SetPIDKEY
Action ended 14:19:33: RestoreProductID. Return value 1.
MSI (s) (3C:9C) [14:19:33:901]: Transforming table CustomAction.

MSI (s) (3C:9C) [14:19:33:917]: Transforming table CustomAction.

MSI (s) (3C:9C) [14:19:33:917]: Note: 1: 2262 2: CustomAction 3: -2147287038
MSI (s) (3C:9C) [14:19:33:917]: PROPERTY CHANGE: Deleting PIDKEY property. Its current value is '**********'.
Action start 14:19:33: SetPIDKEY.
MSI (s) (3C:9C) [14:19:33:917]: Doing action: SetValidMOFInstanceNameProp.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action ended 14:19:33: SetPIDKEY. Return value 1.
MSI (s) (3C:9C) [14:19:33:933]: Transforming table CustomAction.

MSI (s) (3C:9C) [14:19:33:933]: Transforming table CustomAction.

MSI (s) (3C:9C) [14:19:33:933]: Note: 1: 2262 2: CustomAction 3: -2147287038
MSI (s) (3C:9C) [14:19:33:948]: Transforming table Binary.

MSI (s) (3C:9C) [14:19:33:964]: Transforming table Binary.

MSI (s) (3C:9C) [14:19:33:964]: Note: 1: 2262 2: Binary 3: -2147287038
MSI (s) (3C:C0) [14:19:34:058]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI59F.tmp, Entrypoint: SetValidMOFInstanceNameProp
Action start 14:19:33: SetValidMOFInstanceNameProp.D20239D7_E87C_40C9_9837_E70B8D4882C2.
<Func Name='LaunchFunction'>
MSI (s) (3C!DC) [14:19:34:620]: Transforming table _sqlAction.

MSI (s) (3C!DC) [14:19:34:620]: Transforming table _sqlAction.

MSI (s) (3C!DC) [14:19:34:620]: Note: 1: 2262 2: _sqlAction 3: -2147287038
Function=SetValidMOFInstanceNameProp
MSI (s) (3C!DC) [14:19:34:761]: Transforming table _sqlAction.

MSI (s) (3C!DC) [14:19:34:776]: Transforming table _sqlAction.

MSI (s) (3C!DC) [14:19:34:776]: Note: 1: 2262 2: _sqlAction 3: -2147287038
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: SetValidMOFInstanceNameProp
PerfTime Start: SetValidMOFInstanceNameProp : Fri Mar 12 14:19:34 2010
<Func Name='SetValidMOFInstanceNameProp'>
MSI (s) (3C!DC) [14:19:34:980]: PROPERTY CHANGE: Adding ValidMOFInstanceName property. Its value is '1'.
Setting ValidMofInstanceName to 1
<EndFunc Name='SetValidMOFInstanceNameProp' Return='0' GetLastError='0'>
PerfTime Stop: SetValidMOFInstanceNameProp : Fri Mar 12 14:19:34 2010
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (3C:9C) [14:19:35:011]: Doing action: CostInitialize
Action ended 14:19:35: SetValidMOFInstanceNameProp.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (s) (3C:9C) [14:19:35:011]: Machine policy value 'MaxPatchCacheSize' is 10
MSI (s) (3C:9C) [14:19:35:011]: RTM Baseline: 9.0.1399
Action start 14:19:35: CostInitialize.
MSI (s) (3C:9C) [14:19:35:089]: PROPERTY CHANGE: Adding ROOTDRIVE property. Its value is 'y:\'.
MSI (s) (3C:9C) [14:19:35:105]: Transforming table Directory.

MSI (s) (3C:9C) [14:19:35:120]: Transforming table Directory.

MSI (s) (3C:9C) [14:19:35:120]: Note: 1: 2262 2: Directory 3: -2147287038
MSI (s) (3C:9C) [14:19:35:120]: Note: 1: 2705 2: Directory
MSI (s) (3C:9C) [14:19:35:136]: Transforming table Error.

MSI (s) (3C:9C) [14:19:35:136]: Transforming table Error.

MSI (s) (3C:9C) [14:19:35:136]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (3C:9C) [14:19:35:167]: Transforming table Error.

MSI (s) (3C:9C) [14:19:35:167]: Transforming table Error.

MSI (s) (3C:9C) [14:19:35:167]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (3C:9C) [14:19:35:167]: Product: Microsoft SQL Server 2005 Integration Services -- Error 2705. The installer has encountered an unexpected error. The error code is 2705. Invalid table: Directory; Could not be linked as tree.

Error 2705. The installer has encountered an unexpected error. The error code is 2705. Invalid table: Directory; Could not be linked as tree.
MSI (s) (3C:9C) [14:19:35:198]: Transforming table InstallExecuteSequence.

MSI (s) (3C:9C) [14:19:35:198]: Transforming table InstallExecuteSequence.

MSI (s) (3C:9C) [14:19:35:198]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
Action ended 14:19:35: CostInitialize. Return value 3.
Action ended 14:19:35: INSTALL. Return value 3.


*****(DELETED EXTRA LINES TO GET THE LOG FILE TO FIT ON THIS THREAD)******


MSI (s) (3C:9C) [14:19:36:652]: Product: Microsoft SQL Server 2005 Integration Services - Update 'Service Pack 3 for SQL Server Integration Services 2005 ENU (KB955706)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB955706_sqlrun_dts.msp.log.

MSI (s) (3C:9C) [14:19:36:652]: Product: Microsoft SQL Server 2005 Integration Services - Update 'Hotfix 3233 for SQL Server Integration Services 2005 ENU (KB948108)' could not be removed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB955706_sqlrun_dts.msp.log.

MSI (s) (3C:9C) [14:19:36:667]: Attempting to delete file C:\WINDOWS\Installer\5353014.msp
MSI (s) (3C:9C) [14:19:36:667]: Unable to delete the file. LastError = 32
MSI (s) (3C:9C) [14:19:36:995]: Cleaning up uninstalled install packages, if any exist
MSI (s) (3C:9C) [14:19:36:995]: MainEngineThread is returning 1603
MSI (s) (3C:24) [14:19:37:011]: Destroying RemoteAPI object.
MSI (s) (3C:1C) [14:19:37:011]: Custom Action Manager thread ending.
=== Logging stopped: 3/12/2010 14:19:36 ===
MSI (c) (00:18) [14:19:37:058]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (00:18) [14:19:37:120]: MainEngineThread is returning 1603
=== Verbose logging stopped: 3/12/2010 14:19:37 ===






-----------------------------------------------------------------------------------------------------------------
SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log (last few lines of log file. log file is quite large)
-----------------------------------------------------------------------------------------------------------------


MSI (s) (3C:D8) [14:33:47:158]: Product: Microsoft SQL Server 2005 Tools - Update 'Service Pack 3 for SQL Server Tools and Workstation Components 2005 ENU (KB955706)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log.

MSI (s) (3C:D8) [14:33:47:158]: Product: Microsoft SQL Server 2005 Tools - Update 'Hotfix 3233 for SQL Server Tools and Workstation Components 2005 ENU (KB948108)' could not be removed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log.

MSI (s) (3C:D8) [14:33:47:251]: Attempting to delete file C:\WINDOWS\Installer\535302c.msp
MSI (s) (3C:D8) [14:33:47:251]: Unable to delete the file. LastError = 32
MSI (s) (3C:D8) [14:33:47:408]: Cleaning up uninstalled install packages, if any exist
MSI (s) (3C:D8) [14:33:47:408]: MainEngineThread is returning 1603
MSI (s) (3C:24) [14:33:47:533]: Destroying RemoteAPI object.
MSI (s) (3C:00) [14:33:47:548]: Custom Action Manager thread ending.
=== Logging stopped: 3/12/2010 14:33:47 ===
MSI (c) (00:AC) [14:33:47:751]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (00:AC) [14:33:47:751]: MainEngineThread is returning 1603
=== Verbose logging stopped: 3/12/2010 14:33:47 ===

barnes_53
Starting Member

2 Posts
Posted - 2010-03-24 : 09:58:37
Here is the resolution:

Unable to install SQL Server 2005 SP3 build 4262 (Upgrade from SP2 Build 3233)





Extracted the corresponding .exe files from the patches/hotfixes/SP/RTM. Replaced the following files which were reported missing:



Missing installer package file "11da09.msi" for "Microsoft SQL Server 2005 Backward compatibility"
Missing installer cache file "22c22da2.msp" for Patch "Hotfix 3175 for SQL Server Tools and Workstation Components 2005 ENU (KB936305)" on "Microsoft SQL Server 2005 Tools" KB Article = "Hotfix;936305;ENU;http://support.microsoft.com/?kbid=936305"
Missing installer package file "131459.msi" for "Microsoft SQL Server 2005"
Missing installer package file "11d8d2.msi" for "Microsoft SQL Server Native Client"
Missing installer package file "6adf3c.msi" for "Microsoft SQL Server 2005 Books Online (English)"
Missing installer cache file "22c22d5c.msp" for Patch "Hotfix 3175 for SQL Server Database Services 2005 ENU (KB936305)" on "Microsoft SQL Server 2005" KB Article = "Hotfix;936305;ENU;http://support.microsoft.com/?kbid=936305"
Missing installer cache file "22c22d5c.msp" for Patch "Hotfix 3175 for SQL Server Database Services 2005 ENU (KB936305)" on "Microsoft SQL Server 2005" KB Article = "Hotfix;936305;ENU;http://support.microsoft.com/?kbid=936305"
Missing installer package file "11da17.msi" for "Microsoft SQL Server VSS Writer"
Missing installer cache file "22c22d6c.msp" for Patch "Hotfix 3175 for SQL Server Integration Services 2005 ENU (KB936305)" on "Microsoft SQL Server 2005 Integration Services" KB Article = "Hotfix;936305;ENU;http://support.microsoft.com/?kbid=936305"
Missing installer cache file "24b303ee.msp" for Patch "Hotfix 3024 for SQL Server Database Services 2005 ENU (KB000000)" on "Microsoft SQL Server 2005" KB Article = "Hotfix;000000;ENU;http://support.microsoft.com/?kbid=000000"
Missing installer cache file "22c22d5c.msp" for Patch "Hotfix 3175 for SQL Server Database Services 2005 ENU (KB936305)" on "Microsoft SQL Server 2005" KB Article = "Hotfix;936305;ENU;http://support.microsoft.com/?kbid=936305"
Missing installer cache file "22c22d5c.msp" for Patch "Hotfix 3175 for SQL Server Database Services 2005 ENU (KB936305)" on "Microsoft SQL Server 2005" KB Article = "Hotfix;936305;ENU;http://support.microsoft.com/?kbid=936305"


Even after replacing the missing MSP/MSI files was getting failures with Integration services and Client components:



MSI (s) (94:5C) [13:20:35:430]: Product: Microsoft SQL Server 2005 Integration Services -- Error 2705. The installer has encountered an unexpected error. The error code is 2705. Invalid table: Directory; Could not be linked as tree.


Error 2705. The installer has encountered an unexpected error. The error code is 2705. Invalid table: Directory; Could not be linked as tree.


MSI (s) (94:5C) [13:20:35:493]: Transforming table InstallExecuteSequence.


MSI (s) (94:5C) [13:20:38:227]: Product: Microsoft SQL Server 2005 Integration Services - Update 'Hotfix 3233 for SQL Server Integration Services 2005 ENU (KB948108)' could not be removed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB955706_sqlrun_dts.msp.log.


Replaced all the msp and msi files related to the components:



Microsoft SQL Server 2005 Tools


SqlRun_DTS.msi from RTM --> 6adf64.msi



SqlRun_DTS.msp from Service Pack 2 for SQL Server Tools and Workstation Components 2005 ENU (KB921896) to --> 11d9d9.msp



SqlRun_DTS.msp from Hotfix 3175 for SQL Server Tools and Workstation Components 2005 ENU (KB936305) to -->22c22da2.msp



SqlRun_DTS.msp from Hotfix 3233 for SQL Server Tools and Workstation Components 2005 ENU (KB948108) to -->24f3a34b.msp



Microsoft SQL Server 2005 Integration Services


SqlRun_Tools from RTM -->6adf4b.msi



SqlRun_Tools from Service Pack 2 for SQL Server Integration Services 2005 ENU (KB921896) -->11d8c6.msp



SqlRun_Tools from Hotfix 3175 for SQL Server Integration Services 2005 ENU (KB936305) -->22c22d6c.msp



SqlRun_Tools from Hotfix 3233 for SQL Server Integration Services 2005 ENU (KB948108) -->24f3a31a.msp





From the log I got the following error code:



MainEngineThread is returning 1646 ERROR_PATCH_REMOVAL_UNSUPPORTED 1646 The patch package is not a removable patch package. Available beginning with Windows Installer version 3.0.


Located the following registry subkey:



HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products

Navigated to the GUID under the Patches key and in the details pane, right-clicked the Uninstallable registry value, and then modified the Value data box from 0X0 to 0X1(for all the patches)


Successfully patched the Client components but still not able to patch Integration Services

The error from the dts log:



MSI (s) (A0:40) [08:21:46:130]: Product: Microsoft SQL Server 2005 Integration Services - Update 'Hotfix 3233 for SQL Server Integration Services 2005 ENU (KB948108)' could not be removed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB955706_sqlrun_dts.msp.log.


MSI (s) (A0:40) [08:21:46:130]: Product: Microsoft SQL Server 2005 Integration Services - Update 'Service Pack 2 for SQL Server Integration Services 2005 ENU (KB921896)' could not be removed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB955706_sqlrun_dts.msp.log.


Checked the registry for both the patches under:



HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\<Product Code>\Patches\<Patch Code>


Had 3 patches listed:



Service Pack 2 for SQL Server Integration Services 2005 ENU (KB921896)
Hotfix 3175 for SQL Server Integration Services 2005 ENU (KB936305)
Hotfix 3233 for SQL Server Integration Services 2005 ENU (KB948108)


Was getting errors for these patches :

Hotfix 3233 for SQL Server Integration Services 2005 ENU (KB948108)
Service Pack 2 for SQL Server Integration Services 2005 ENU (KB921896)


Navigated to the registry key and replicated the registry entries (for Service Pack 2 and Hotfix 3233 ) as mentioned :



HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\<Product Code>\Patches\<Patch Code>
MSI3 1
Patch Type 0
State 2
Uninstallable 1


Ran SP3 and it finished successfully!
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site