Problem with upgrading

rdobrich

Hi,

I have SQL compare version 3.1.9.12,
and I have problem when I click for update (new dialog for upgrade).
I shows that there is new upgrade ('new free maintenence releases available '). When I clink View detail it crashed.

Radovan

Brian Donahue

Hi Radovan,

I'm sorry that the new update service is giving you a bit of a hard time. Are there any errors left behind in the Event Log as a result of this crash? Please let us know so we can try to sort out any problems.

rdobrich

Hi There is nothing in Event log.

Only message I can get is message from Detail error botton:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ComponentModel.Win32Exception: The system cannot find the file specified
at System.Diagnostics.Process.StartWithShellExecuteEx(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start()
at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start(String fileName)
at RedGate.Update.ClientForm.ViewDetails_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/winnt/microsoft.net/framework/v1.1.4322/mscorlib.dll

---

RedGate.SQLCompare.UI
Assembly Version: 3.1.9.12
Win32 Version: 3.1.9.12
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.SQLCompare.UI.exe

---

System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/winnt/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll

---

System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/winnt/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll

---

RedGate.SQLCompare.Engine
Assembly Version: 3.1.9.12
Win32 Version: 3.1.9.12
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.SQLCompare.Engine.DLL

---

System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/winnt/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll

---

RedGate.SQL.Controls
Assembly Version: 3.3.8.119
Win32 Version: 3.3.8.119
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.SQL.Controls.DLL

---

RedGate.SQL.Grids
Assembly Version: 3.3.8.119
Win32 Version: 3.3.8.119
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.SQL.Grids.DLL

---

ActiproSoftware.TabStripPanel
Assembly Version: 2.0.205.0
Win32 Version: 2.0.205.0
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/ActiproSoftware.TabStripPanel.DLL

---

RedGate.SQL.Shared
Assembly Version: 3.3.8.119
Win32 Version: 3.3.8.119
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.SQL.Shared.DLL

---

ActiproSoftware.DockableWindow
Assembly Version: 2.0.205.0
Win32 Version: 2.0.205.0
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/ActiproSoftware.DockableWindow.DLL

---

DevExpress.XtraBars
Assembly Version: 2.1.4.0
Win32 Version: 2.1.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/DevExpress.XtraBars.DLL

---

DevExpress.XtraEditors
Assembly Version: 2.0.4.0
Win32 Version: 2.0.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/DevExpress.XtraEditors.DLL

---

DevExpress.Utils
Assembly Version: 2.0.4.0
Win32 Version: 2.0.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/DevExpress.Utils.DLL

---

ActiproSoftware.Wizard
Assembly Version: 2.0.80.0
Win32 Version: 2.0.80.0
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/ActiproSoftware.Wizard.DLL

---

RedGate.Licensing.Client
Assembly Version: 1.2.4.5
Win32 Version: 1.2.4.5
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.Licensing.Client.DLL

---

RedGate.Licensing.Helper
Assembly Version: 1.2.4.5
Win32 Version: 1.2.4.5
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.Licensing.Helper.DLL

---

System.Xml
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/winnt/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll

---

RedGate.SQLCompare.BuildInfo
Assembly Version: 3.1.9.12
Win32 Version: 3.1.9.12
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.SQLCompare.BuildInfo.DLL

---

RedGate.Update.Client
Assembly Version: 1.0.0.12
Win32 Version: 1.0.0.12
CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.Update.Client.DLL

---

System.Web.Services
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/winnt/assembly/gac/system.web.services/1.0.5000.0__b03f5f7f11d50a3a/system.web.services.dll

---

System.Web
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/winnt/assembly/gac/system.web/1.0.5000.0__b03f5f7f11d50a3a/system.web.dll

---

o8g1t--k
Assembly Version: 0.0.0.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/winnt/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll

---

************** JIT Debugging **************
To enable just in time (JIT) debugging, the config file for this
application or machine (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the machine
rather than being handled by this dialog.

Brian Donahue

SQL Compare is probably trying to launch RedGate.Update.UpdateCheck.exe. Is this file not in the Red Gate SQL Bundle folder?

rdobrich

Yes,
This file is in the directory.

Version: 1.0.0.12.

Radovan

Brian Donahue

Hi Radovan,

This must have to do with Update Service attempting to launch a web browser using a Process.Start() command. This is roughly the same as doing a Start->Run from the start bar and typing the URL.

Can you please try opening Run from the start bar and type http://www.red-gate.com?

If this also returns an error, you probably need to go into Windows Explorer and edit the file types so that URLs open with one of your installed browsers.

Please let me know if you need any more help.

rdobrich

Hi,
when I open run and type http://www.red-gate.exe
Windows explorer openes and goes to your start page.

Radovan

Brian Donahue

Hi Radovan,

Which web browser do you have set as the default browser in Windows? Is it Internet Explorer, or a different browser?

rdobrich

Hi,
I only use IE.
I don't have any browser instaled on my comp.

rdobrich

Hi,
I just think one more thing.
In my company, I have firewall. Maybe, it uses samo udp port for upgrading.

Radovan

Brian Donahue

I can't imagine this would be the case. It's just doing basically the same thing as Start->Run http://www.red-gate.com...

rdobrich

Can I download trial version, uninstall my version of SQl compare and register it again?
Maybe, than I can make update?

Radovan

Brian Donahue

Hi Radovan,

Sure thing. The trial software is identical to the release version.

Further to the process start problem, I think that if the shell registry key has an incorrect or missing value, the web browser may not start. Can you try running this command, and see what the output is?

REG QUERY HKEY_CLASSES_ROOT\http\shell\open\command

rdobrich

Hi,
I can't start reg, becouse My win 2000 doesn't recognise command.
But, with regedit I can read registry.
In HKEY_CLASSES_ROOT\http\shell\open\command there is
Value name: (default)
Value data: "C:\Program Files\Internet Explorer\iexplore.exe" -nohome

rdobrich

Hi,
I just download new trial version and install (without uninstall old version) and now everything works fine.

woaksie

I had the exact same thing happen to me. I downloaded the trial version again and am working fine now. I guess we will have to see what happens with the next version.

John.

MikeR

This continues to happen to me (last three pt releases) and it takes some searching to rediscover the workaround.

Is this going to get fixed?

If not, please consider adding workaround information to the update checker.

Thanks,
-- MikeR

PS. The good news is that this last release (3.41) seems to have fixed all but one problem.

Daniel Handley

Hi

We have found that there is a problem when using Windows 2000 and passing a url to the browser.

If you are using Windows 2000 please use the check for updates to see if there is a new version and then download the file from the web site rather than by via the update service.

We are trying to find a workaround and hope to have one soon.

Regards
Dan