May 24, 2012 at 9:13 am
Hello Team,
I am facing issue while uninstalling SQL 2005 SP2 version ( standard edition). I am attaching log file from setup bootstrap folder
This is standalone server. It also has two other SQL 2005 instances all with standard edition.
Somehow, it is logging below error :
MSI (s) (40:C0) [16:01:06:705]: SOURCEMGMT: Trying source \\lhrdbs0106\d$\SQLMedia\SQL2005\Setup\.
Kindly help.
May 24, 2012 at 5:36 pm
chetanr.jain (5/24/2012)
...Somehow, it is logging below error :
MSI (s) (40:C0) [16:01:06:705]: SOURCEMGMT: Trying source \\lhrdbs0106\d$\SQLMedia\SQL2005\Setup\.
...
That sure doesn't look like an error..?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 25, 2012 at 2:53 am
@hello Rburry,
yes, this is not an error. However, i not able to find why this uninstall process is trying access network path.
( this network path is not mapped to the server).
On digging further on the log, below is found
MSI (s) (14:3C) [09:36:35:076]: Couldn't find local patch 'C:\WINDOWS\Installer\416ea4f.msp'. Looking for it at its source.
MSI (s) (14:3C) [09:36:57:203]: Unable to create a temp copy of patch 'sqlrun_sql.msp'.
MSI (s) (14:3C) [09:36:57:281]: MainEngineThread is returning 1635
The Cab file of the all logs is attached.
Kindly let me know about issue.
May 25, 2012 at 2:58 am
May 25, 2012 at 3:00 am
Hi,
I have tried both the way : Control Panel and by execting ARPWrapper.exe also.
May 28, 2012 at 7:11 am
All,
I was able to solve the issue. Below are the steps taken :
1)IT was having issue earlier while we have tried to uninstall database instance after decommissioning database. Below is the error log snaps (error log is attached – UninstallLog.zip)
Missing .msi files in local installer folder
MSI (s) (88:88) [13:41:12:996]: Warning: Local cached package 'C:\WINDOWS\Installer\42f05.msi' is missing.
MSI (s) (04:58) [15:30:37:989]: Couldn't find local patch 'C:\WINDOWS\Installer\416ea4f.msp'. Looking for it at its source.
Trying to access network path for finding .msi files
MSI (s) (88:88) [13:41:12:996]: SOURCEMGMT: Trying source (Network Path)
MSI (s) (88:88) [13:41:13:152]: Note: 1: 2203 2: (Network Path) 2147287038
Missing .msp files from local temp folder
MSI (s) (04:58) [15:30:37:989]: Note: 1: 2203 2: d:\354b32d1e8d0b7c91623f319c4fb\HotFixSQL\Files\sqlrun_sql.msp 3: -2147287037
MSI (s) (04:58) [15:30:37:989]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
2)To Find out which all files are missing, I have executed one vbscript (FindSQLInstalls.vbs) from below MS Link. It has generated attached file (Missing_SQL_Files_Logs.zip)
http://support.microsoft.com/kb/969052
3)From the file, it came to know that it is using another network path
Copy "\\<Network Path >\database support\SQL Server\SQL 2005\Tools\Setup\SqlRun_Tools.msi" C:\WINDOWS\Installer\2ba067.msi
(in this line, it seems that it is trying to fetch sqlRun_tools.msi file from network path since it does not finding the file in C:\windows location). There is plenty of references to \\lgwvr011 path for copying files to C:\windows location.
4)To correct this and place file in the proper folders, I have extracted SQL 2005 SP2 patch
D:\SQL Media\SP2\ SQLServer2005SP2-KB921896-x86-ENU.exe /x
5)After extraction, all the missing files are placed in C:\windows folder with \(name).msi. Name of the files are changed with as same file name which are missing. Overwritten files which were already there.
6)After placing all the files, Uninstall is completed successfully.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply