SQL 2005 SP3 Upgrade 4262 from 3233 Failing for Integration Services and Client Components

Question

SQL 2005 SP3 Upgrade 4262 from 3233 Failing for Integration Services and Client Components

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

This is in NO WAY going to be easy to resolve manually because this is a mess. The easiest solution at this point is to reinstall SQL 2005 Integration Services (original). And then apply SP3.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

barnes_53 Valued Member Points: 59 More actions · Answer 2

Roc -

I was just thinking that yesterday after reviewing this again. I had to step away from it for a couple of days and regroup and came to the same conclusion. It looks like an uninstall/reinstall of Integration services and Client Comps is going to have to happen. Thanks for looking at it.

barnes_53 Valued Member Points: 59 More actions · Answer 3

well,

I finally got it fixed without an uninstall/reinstall...painfully, but fixed nonetheless:

Solution----

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

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!

COZYROC One Orange Chip Points: 28499 More actions · Answer 4

Exercise in perseverance. Congratulations on your patience!

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 5

Make sure the ResourceDb got upgraded. I had an issue where the install completing successfully but the ResourceDb never was upgraded. Totally weird because the install showed success. After discovering the difference I looked at the logs in more detail and I was getting a permissions error on the ResourceDb folder. I think this had something to do with Windows Server 2008.

The version of the Master and ResourceDb should be the same.

SELECT SERVERPROPERTY('ResourceVersion');

select @@version