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

barnes_53

Valued Member

Points: 59
More actions
March 15, 2010 at 4:53 pm

#212531

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

Viewing 6 posts - 1 through 5 (of 5 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