Home > Unable To > Unable To Create A Temp Copy Of Patch 'sqlrun_sql.msp

Unable To Create A Temp Copy Of Patch 'sqlrun_sql.msp

After Reply Microsoft SQL Server Tips & Tricks says: June 12, 2009 at 7:51 pm Consider a scenario where an upgrade from SQL 2005 to SQL 2008 fails with the following MSI (c) (AC:D0) [17:45:28:515]: Cloaking enabled. If so, failure installation will again generate verbose log , open the verbose log (like SQL9_Hotfix_KB953752_sqlrun_sql.msp.log) , look at 15-20 lines above the bottom of the log file , you may Unexpected Termination Where from you got the SP4? 0 PRTG Network Monitor: Intuitive Network Monitoring Promoted by Paessler GmbH Network Monitoring is essential to ensure that computer systems and network devices http://brrian.net/unable-to/unable-to-create-a-temp-copy-of-patch-sqlrun-tools-msp.html

Message Author Comment by:PPinesAdmin ID: 357684802011-05-16 This SP4 was taken from Microsoft.com The SP4 that is in WSUS also fails. 0 LVL 46 Overall: Level 46 MS SQL Server 2005 MSI (s) (D0:F4) [17:45:47:452]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp MSI (s) (D0:F4) [17:45:47:452]: SOURCEMGMT: Processing net source list. Choose carefully. MSI (s) (F0:40) [15:25:13:780]: SOURCEMGMT: Looking for sourcelist for product {71E59621-72C0-4987-B3BD-A5E3E48F8627} MSI (s) (F0:40) [15:25:13:780]: SOURCEMGMT: Adding {71E59621-72C0-4987-B3BD-A5E3E48F8627}; to potential sourcelist list (pcode;disk;relpath). http://zhukovandrey.blogspot.com/2012/04/sql-server-2005-update-fails-missing.html

CD media or setup folder copied on local disk) , copy Servers\Setup\SqlRun_SQL.msi and paste it into C:\Windows\Installer , rename it to the cached filename , in our case we have to MSI (s) (0C:18) [11:18:12:583]: SOURCEMGMT: Trying source c:\29b88fa2a547df971728\HotFixSQL\Files\. MSI (s) (38:BC) [00:56:20:417]: User policy value 'SearchOrder' is 'nmu'MSI (s) (38:BC) [00:56:20:417]: User policy value 'DisableMedia' is 0MSI (s) (38:BC) [00:56:20:417]: Machine policy value 'AllowLockdownMedia' is 0MSI (s) (38:BC) [00:56:20:417]: | Search MSDN Search all blogs Search this blog Sign in Microsoft SQL Server Tips & Tricks Microsoft SQL Server Tips & Tricks Tips and Tricks for the SQL Server

Join the community of 500,000 technology professionals and ask your questions. Results 1 to 2 of 2 Thread: Command line install fails when including the Patch.msp Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode MSI (s) (D0:F4) [17:45:47:452]: SOURCEMGMT: Looking for sourcelist for product {4A35EF4A-D868-4B15-A84D-3E8925AA9558} MSI (s) (D0:F4) [17:45:47:452]: SOURCEMGMT: Adding {4A35EF4A-D868-4B15-A84D-3E8925AA9558}; to potential sourcelist list (pcode;disk;relpath). Cached file has a different name which is a randomized alphanumeric name generated by the installer , this is because if you have multiple instances then multiple ‘Sqlrun_sql.msi’ has to be

MSI (s) (A8:94) [14:38:21:226]: SOURCEMGMT: Attempting to use LastUsedSource from source list. So this cached msp file is also missing and we need to put it back. The MSP files are identified and they tell you what KB # that contains the download file in question. ************** REPORT SUMMARY ************** Missing installer package file "4495c.msi" for "Microsoft http://gursethi.blogspot.com/2009/09/sql-2005-patch-fails-with-error-1635.html MSI (s) (0C:18) [11:17:47:248]: MSCOREE already loaded, using loaded copy MSI (s) (0C:18) [11:17:47:248]: Applying multiple instance transform ':SqlRun01.mst'...

However , in case if it fails again, that may be due to the fact that it might be looking for some other patch which might have been applied previously and Verify that the patch package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer patch package.C:\WINDOWS\Installer\1298b.msiMSI (c) (4C:A4) [04:35:19:657]: Related This entry was posted on February 8, 2010 at 9:50 am and is filed under SQL Server. Connect with top rated Experts 16 Experts available now in Live!

If counter >= 0, shutdown will be denied. MSI (s) (F0:40) [15:25:05:983]: Resetting cached policy values MSI (s) (F0:40) [15:25:05:983]: Machine policy value ‘Debug' is 0 MSI (s) (F0:40) [15:25:05:983]: ******* RunEngine: ******* Product: Counter after decrement: -1 MSI (s) (F0:40) [15:25:06:030]: Entering CMsiConfigurationManager::SetLastUsedSource. MSI (s) (F0:40) [15:25:05:983]: SOURCEMGMT: Looking for sourcelist for product {1DD463C0-A50A-4394-B7E4-5895C02F9E0D} MSI (s) (F0:40) [15:25:05:983]: SOURCEMGMT: Adding {1DD463C0-A50A-4394-B7E4-5895C02F9E0D}; to potential sourcelist list (pcode;disk;relpath).

Like a pit bull, I’m not letting go of this one. . . 0 Comments [ + ] Show Comments Comments Please log in to comment Community Chosen Answer 2 Check This Out Counter after increment: 0 MSI (s) (F0:0C) [15:25:05:983]: Grabbed execution mutex. In my case the guid and patchcode were missing from the registry. MSI (s) (A8:94) [14:38:20:008]: File will have security applied from OpCode.

You cannot delete your own posts. MSI (s) (6C:54) [10:14:55:782]: Note: 1: 1708 MSI (s) (6C:54) [10:14:55:782]: Product: Interactive Update Client -- Installation failed. Search* (See Search Hints below) them ,open regedit , go toHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\\Patches\Here is a catch, values for "GUID" & "PatchCode" will be in there reverse order like below:GUID = {1EB3A031CC585314E87AA527E46EECC2} PatchCode = http://brrian.net/unable-to/unable-to-create-a-temp-copy-of-patch.html Although the process is not fast, being able to rebuild is perfect.

Error code 1646 Update ‘Hotfix 3257 for SQL Server Tools and Workstation Components 2005 ENU (KB951217)' could not be removed. Counter after decrement: -1 MSI (c) (AC:D0) [17:46:19:827]: MainEngineThread is returning 1635 === Verbose logging stopped: 1/20/2009 17:46:19 === 1. You cannot rate topics.

Looking for it at its source.

MSI (s) (0C:18) [11:17:47:248]: TRANSFORM: Applying regular transform to database. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. Answered 04/11/2013 by: rileyz Please log in to comment Please log in to comment Answer this question or Comment on this question for clarity AnswerSubmit Don't be a Stranger! Anyways, if you know the GUID (ProductCode) of the instance , you can find the name of this cached file , go toHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\\InstallPropertiesIn the right pane , look for the value

MSI (s) (A8:94) [14:38:21:226]: Note: 1: 2203 2: C:\WINDOWS\Installer\6af1f2.msp 3: -2147287038 MSI (s) (A8:94) [14:38:21:226]: Machine policy value ‘AllowLockdownBrowse' is 0 MSI (s) (A8:94) [14:38:21:226]: Machine policy value ‘DisableBrowse' is 0 If counter >= 0, shutdown will be denied. Product Language: 1033. http://brrian.net/unable-to/unable-to-create-a-temp-copy-of-patch-net.html MSI (s) (F0:40) [15:25:13:702]: End dialog not enabled MSI (s) (F0:40) [15:25:13:702]: Original package ==> I:SoftwareMicrosoftSQL server 2005Disc2SetupSqlRun_Tools.msi MSI (s) (F0:40) [15:25:13:702]: Package we're running from ==> C:WINDOWSInstallerd3b410.msi MSI (s) (F0:40)

You can go up one level in the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Patches\, and match up this ID and it will tell you the name of the .msp that you need to replace. Powered by Blogger.