SQL Compare and Data Compare 5.1 buggier than 5.0

dscribellito · May 23, 2006 11:28AM

Hi - I have just upgraded to SQL Bundle 5.1 from 5.0, and I am getting exceptions where I never have before. For example, when trying to set up a compare in either app, I get an exception in the Project Configuration dialog almost all of the time (see below). Once in a while I can get past this to actually do a compare, but it takes a number of attempts. I have also seen a few other different exceptions, but the one below is consistent and almost every time.

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

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at DevExpress.Utils.Win.TopFormBase.SetWindowPos(IntPtr hWnd, IntPtr hWndInsertAfter, Int32 X, Int32 Y, Int32 cx, Int32 cy, UInt32 uFlags)
at DevExpress.Utils.Win.TopFormBase.SetVisibleCore(Boolean newVisible)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at DevExpress.Utils.ToolTipController.ShowHintCore(ToolTipControllerShowEventArgs eShow)
at DevExpress.Utils.ToolTipController.ShowHint(ToolTipControllerShowEventArgs eShow, Point cursorPosition)
at DevExpress.Utils.ToolTipController.ShowHint()
at DevExpress.Utils.ToolTipController.OnInitialTimerTick(Object sender, EventArgs e)
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.Callback(IntPtr hWnd, Int32 msg, IntPtr idEvent, IntPtr dwTime)

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

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

System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/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:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll

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

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

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

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

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

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

ActiproSoftware.UIStudio.Dock
Assembly Version: 2.0.62.0
Win32 Version: 2.0.62.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/ActiproSoftware.UIStudio.Dock.DLL

ActiproSoftware.Shared
Assembly Version: 1.0.77.0
Win32 Version: 1.0.77.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/ActiproSoftware.Shared.DLL

ActiproSoftware.WinUICore
Assembly Version: 1.0.77.0
Win32 Version: 1.0.77.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/ActiproSoftware.WinUICore.DLL

DevExpress.XtraBars3
Assembly Version: 3.7.5.0
Win32 Version: 3.7.5.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraBars3.DLL

DevExpress.XtraEditors3
Assembly Version: 3.2.5.0
Win32 Version: 3.2.5.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraEditors3.DLL

DevExpress.Utils3
Assembly Version: 3.2.5.0
Win32 Version: 3.2.5.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.Utils3.DLL

System.Design
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/assembly/gac/system.design/1.0.5000.0__b03f5f7f11d50a3a/system.design.dll

DevExpress.XtraPrinting3
Assembly Version: 1.12.5.0
Win32 Version: 1.12.5.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraPrinting3.DLL

DevExpress.XtraGrid3
Assembly Version: 3.2.5.0
Win32 Version: 3.2.5.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraGrid3.DLL

DevExpress.Data3
Assembly Version: 3.2.5.0
Win32 Version: 3.2.5.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.Data3.DLL

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

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

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

Accessibility
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/assembly/gac/accessibility/1.0.5000.0__b03f5f7f11d50a3a/accessibility.dll

System.EnterpriseServices
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/assembly/gac/system.enterpriseservices/1.0.5000.0__b03f5f7f11d50a3a/system.enterpriseservices.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.

david connell · May 23, 2006 12:22PM

Hi there,
Sorry to hear about your problems, you are the first person who has mentioned this problem. We will invistigate this issue straight away and get back to you.
Do you know why sometimes it starts up and sometimes it does not. It would appear from the exception list that a tool tip is trying to be displayed. So does SQL Compare have a problem if the mouse is left on the start button and SQL compare is started up via the menu?
best regards
David

david connell · May 23, 2006 1:35PM

Hi,

Can you give us a step by step guide to exactly at what point the exception is thrown please.

What happens if you hit compare now from the the Comparison Projects dialog box please?

Also have you got a second machine that exhibits the same problem?

Best regards
David

david connell · May 24, 2006 6:07AM

Hi,
One further question,
What OS and Service pack are you running the software on please.
Regards
David

dscribellito · May 24, 2006 11:11AM

Hi David,

This is Windows XP with SP2 and all the latest patches from Windows Update applied. The SQL Compare version is 5.1.0.80 and the SQL Data Compare version is 5.1.0.106. Note that I verified with SQL Compare but have seen them with SQL Data Compare.

I think you may be on to something with the tooltip. Here are steps I use to reproduce:
1. Launch SQL Compare (or SQL Data Compare)
2. The Comparison Projects dialog is displayed.
3. Click on New or Edit to display the Project Configuration dialog.
4. Mouse over any active buttons to try to get the tooltip to display (e.g. Compare Now, Cancel) and the exception will happen. However, note that which button causes the exception is not consistent. For example, sometimes the tooltip will display on the Compare Now button but the exception will happen while waiting for the tooltip to display on the Cancel button. Or the Compare Now button will throw an exception right away.
5. I am also able to get this to happen on the Comparison Projects dialog as well. Same process - mouse over the buttons looking for tooltips and some will display and then one will cause an exception. It is never consistent as to which one.

I installed 5.1 on my laptop as well to see if I can reproduce these issues. I can but not nearly with the same frequency. The laptop is also Windows XP SP2 with all the latest Windows updates. Both machines were recent fresh installations so haven't had time to accumulate much junk yet.

There are two other exceptions I get as well in addition to the initial one I reported. The first one (EXCEPTION 1 below) happens when clicking Cancel on the Project Configuration dialog. The steps to reproduce are:
1. Launch SQL Compare (or SQL Data Compare)
2. The Comparison Projects dialog is displayed.
3. Click on either New or Edit to display the Project Configuration dialog.
4. Click Cancel and you get the exception below. This happens very consistently - sometimes it doesn't do it but the exception happens about 85% of the time.

The second exception (EXCEPTION 2 below) happens when clicking Cancel on the Project Configuration dialog. The steps to reproduce are:
1. Launch SQL Compare (or SQL Data Compare)
2. The Comparison Projects dialog is displayed.
3. Click Compare Now with a project highlighted in which one of the databases is non-existent.
4. If you don't get the tooltip exception and the comparison is attempted, you get EXCEPTION 2 below.

Let me know what other info I can provide to help.

Thanks,
Dave

EXCEPTION 1

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

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.ComponentManager.System.Windows.Forms.UnsafeNativeMethods+IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.RunDialog(Form form)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at System.Windows.Forms.Form.ShowDialog()
at _81._8()
at _81._1(String , Object )
at _92._5(Object , EventArgs )
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.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:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll