Update from 3.10 to 3.37 failed but fixed

Brian DonahueBrian Donahue Posts: 6,590 New member
edited November 25, 2005 11:48AM in SQL Compare Previous Versions

Here is another one of those things that never comes up during testing!
What I think happened is that the downloaded installation got corrupt or
deleted. Since we distribute Bundle as a self-extracting exe, we're
vulnerable to problems like this.

Here's what happens when you install the Bundle: First, the
InstallShield self-extracting exe unpacks and copies Red Gate SQL Bundle.msi
to the %SYSTEMROOT%Downloaded Installations folder. Since the
WindowsInstaller API only supports (AFAIK) the installation of MSI files, it
needs to extract and run the MSI that's embedded in the bundle.exe file.

Next, MSIExec (Windows Installer) runs the MSI from the Downloaded
Installations folder and installs the software. As part of the installation,
MSIExec puts some information in
HKEY_CURRENT_USERSoftwareMicrosoftInstaller<Product ID GUID> to tell
Installer where the original MSI is saved so that if you go into the
Add/Remove Programs Control Panel, Windows can locate the original
installation archive and offer the uninstall/reinstall/repair options if
they're available. The 'Red Gate SQL Bundle.msi' file will stick around
forever on the hard disk.

If the MSI file becomes unavailable and you go to the Add/Remove
Programs Control Panel and try to remove Red Gate SQL Bundle, you'll get the
error that you described, but you should be able to fix it by downloading
the bundle from the website again and re-running the installation.

Trouble is, if you need to remove an older version you need to download
an older version of the Bundle and we don't make those publicly available.
If you ever run into this problem again, please contact [email protected]
and we'll send you an older version of bundle.exe so you can safely remove
it by running that installation rather than chopping away at the registry.


Brian Donahue
Red Gate Technical Support

"Tool_" <[email protected]> wrote in message
news:sg%[email protected]
> Hello,
> I got this error from bundle installer:
> "The feature you are trying to use is on a network resource that is
> unavailable.
> Click OK to try again, or enter an alternate path to a folder containing
> installation package 'Red Gate SQL Bundle.msi' in the box below'
> Use feature from:" and there is a dropdown box with
> "C:WINNTDownloaded
> The error appeared after I had given up an ongoing automatic update and
> tried to rerun the update. It kept up showing even though I recreated the
> folder{7C9CBF3E-8999-4876-8C3C-24BFD2EAF3B7} in C:WINNTDownloaded
> Installations. and copied the found elsewhere msi file there.
> Finally I found registry entry created by windows installer
> "HKEY_CURRENT_USERSoftwareMicrosoftInstaller{ installation guid for
> gate bundle}" and I deleted it. And it helped.
> Could you proof your installation package against the mess up the windows
> installer does in registry?
> Regards,
> Arek


  • Brian DonahueBrian Donahue Posts: 6,590 New member
    When you install software using Windows Installer, a registry entry is written that contains an uninstall command. If the install was done over a network, and then an administrator later deletes the MSI, you will get this type of error and nothing can be done to prevent it.

    SQL Bundle should cache its' MSI database locally in %SYSTEMROOT%\Downloaded Installations\{GUID} so going to add/remove programs in the control panel should access this cached MSI to figure out which files and settings need to be cleaned up as part of the uninstall. If this file gets deleted, then you will get an error.

    The only way to recover from this is to rerun the setup for the program. This should give you only the Uninstall option since the software is uninstalled.

    If you have lost the original installation archive, from an older version of SQL Bundle, then download the current Bundle, this may not work. If it does not, please write [email protected] and screenshot the error message. Based on the GUID in the error message, we can supply you with the original installation for that version of SQL Bundle so it can be uninstalled before installing the new version.
This discussion has been closed.