Pages

Wednesday, June 29, 2011

Unable to install SP4 due to missing MSI or MSP packages

I faced a situation where my SP4 installation on sqlserver 2005 failed when upgrading Client tools.
Product : Client Components
Product Version (Previous): 4053
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB2463332_sqlrun_tools.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file

It happens when ever some important files were missed from C:\WinNT\installer location.

It may happen not only to client components some times this kind of situation may arise to database engine also.

We to have to check the log for the exact reason.

Log available at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

when we check the exact log for the reason of failure,it appears something like this...

MSI (s) (34:44) [19:42:23:216]: Opening existing patch 'C:\WINNT\Installer\2b7f2f93.msp'.
MSI (s) (34:44) [19:42:23:216]: Note: 1: 2203 2:
C:\WINNT\Installer\2b7f2f93.msp 3: -2147287038
MSI (s) (34:44) [19:42:23:216]: Couldn't find local patch 'C:\WINNT\Installer\2b7f2f93.msp'. Looking for it at its source.
MSI (s) (34:44) [19:42:23:216]: Resolving Patch source.
MSI (s) (34:44) [19:42:23:216]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (34:44) [19:42:23:216]: User policy value 'DisableMedia' is 0
MSI (s) (34:44) [19:42:23:216]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (34:44) [19:42:23:216]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (34:44) [19:42:23:216]: SOURCEMGMT: Looking for sourcelist for product {6C21427B-DF99-44EE-B019-C983DFC15964}
MSI (s) (34:44) [19:42:23:216]: SOURCEMGMT: Adding {6C21427B-DF99-44EE-B019-C983DFC15964}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (34:44) [19:42:23:216]: SOURCEMGMT: Now checking product {6C21427B-DF99-44EE-B019-C983DFC15964}
MSI (s) (34:44) [19:42:23:216]: SOURCEMGMT: Media is enabled for product.
MSI (s) (34:44) [19:42:23:216]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (34:44) [19:42:23:216]: SOURCEMGMT: Trying source d:\9ce1d2cebb4bc1ac2b8929df98\HotFixTools\Files\.
MSI (s) (34:44) [19:42:23:216]: Note: 1: 2203 2: d:\9ce1d2cebb4bc1ac2b8929df98\HotFixTools\Files\sqlrun_tools.msp 3: -2147287037
MSI (s) (34:44) [19:42:23:216]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (34:44) [19:42:23:216]: Note: 1: 1706 2: -2147483647 3: sqlrun_tools.msp
MSI (s) (34:44) [19:42:23:216]: SOURCEMGMT: Processing net source list.
MSI (s) (34:44) [19:42:23:216]: Note: 1: 1706 2: -2147483647 3: sqlrun_tools.msp
MSI (s) (34:44) [19:42:23:216]: SOURCEMGMT: Processing media source list.
MSI (s) (34:44) [19:42:24:228]: SOURCEMGMT: Resolved source to: 'sqlrun_tools.msp'
MSI (s) (34:44) [19:42:24:258]: Note: 1: 1314 2: sqlrun_tools.msp
MSI (s) (34:44) [19:42:24:258]: Unable to create a temp copy of patch 'sqlrun_tools.msp'.
MSI (s) (34:44) [19:42:24:258]: Note: 1: 1708
MSI (s) (34:44) [19:42:24:258]: Note: 1: 2729
MSI (s) (34:44) [19:42:24:358]: Note: 1: 2729
MSI (s) (34:44) [19:42:24:358]: Product: Microsoft SQL Server 2005 Tools -- Installation failed.

The above highlighted code in red color are the major concerns to look forward for solution...
Sqlrun_tools.msp is unable to get copied to main base location from where installation will proceed.

We have to copy Sqlrun_tools.msp to C:\WinNT\Installer location by renaming the file as 2b7f2f93.msp (this is the file which identfied as missing in the above log.


We can get Sqlrun_tools.msp file from SP4 setup file, by following the code explained below..

Go to the location where SP4 is copied and extract to some location
by using command prompt..

D:\SP4.exe /extract

After extracting search for the file which is unable to create in the log and rename it with the file which is needed and place it at location C:\WinNT\installer

Restart the service pack setup, it will get completed successfully.

Thanks..