Compare now causes exception when password hasn't been saved
drhoten
Posts: 21
Earlier today, I created a snapshot of a database and then used it to compare against a live database. But when I entered the options for the live database, I unchecked the option for save password.
Now going back into SQL compare, selecting the project and clicking compare now fires the exception. I went back edited the project to save the password, and no there is no problem.
I would have expected SQL Compare to prompt me, or open the edit the project dialog if one of the passwords was blank.
Doug
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 _50._1(LiveDatabaseSource )
at _91._1(_117 )
at _93._1(_117 )
at _93._1(Project )
at _93._2(Object , EventArgs )
at System.Windows.Forms.Control.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.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
RedGate.SQLCompare.UI
Assembly Version: 5.3.0.44
Win32 Version: 5.3.0.44
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQLCompare.UI.exe
DevExpress.Utils.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.Utils.v6.3.DLL
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.3.0.2
Win32 Version: 5.3.0.2
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.1.4
Win32 Version: 1.3.1.4
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.Licensing.Client.DLL
RedGate.SQLCompare.Engine
Assembly Version: 5.3.0.44
Win32 Version: 5.3.0.44
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQLCompare.Engine.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
RedGate.Licensing.Helper
Assembly Version: 1.3.1.0
Win32 Version: 1.3.1.4
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.Licensing.Helper.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.XtraBars.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraBars.v6.3.DLL
DevExpress.XtraEditors.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraEditors.v6.3.DLL
DevExpress.Data.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.Data.v6.3.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.XtraPrinting.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraPrinting.v6.3.DLL
DevExpress.XtraGrid.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraGrid.v6.3.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.3.0.2
Win32 Version: 5.3.0.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQL.Controls.DLL
RedGate.Update.Client
Assembly Version: 1.2.1.1
Win32 Version: 1.2.1.1
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
************** 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.
Now going back into SQL compare, selecting the project and clicking compare now fires the exception. I went back edited the project to save the password, and no there is no problem.
I would have expected SQL Compare to prompt me, or open the edit the project dialog if one of the passwords was blank.
Doug
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 _50._1(LiveDatabaseSource )
at _91._1(_117 )
at _93._1(_117 )
at _93._1(Project )
at _93._2(Object , EventArgs )
at System.Windows.Forms.Control.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.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
RedGate.SQLCompare.UI
Assembly Version: 5.3.0.44
Win32 Version: 5.3.0.44
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQLCompare.UI.exe
DevExpress.Utils.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.Utils.v6.3.DLL
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.3.0.2
Win32 Version: 5.3.0.2
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.1.4
Win32 Version: 1.3.1.4
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.Licensing.Client.DLL
RedGate.SQLCompare.Engine
Assembly Version: 5.3.0.44
Win32 Version: 5.3.0.44
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQLCompare.Engine.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
RedGate.Licensing.Helper
Assembly Version: 1.3.1.0
Win32 Version: 1.3.1.4
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.Licensing.Helper.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.XtraBars.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraBars.v6.3.DLL
DevExpress.XtraEditors.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraEditors.v6.3.DLL
DevExpress.Data.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.Data.v6.3.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.XtraPrinting.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraPrinting.v6.3.DLL
DevExpress.XtraGrid.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/DevExpress.XtraGrid.v6.3.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.3.0.2
Win32 Version: 5.3.0.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Bundle%205/RedGate.SQL.Controls.DLL
RedGate.Update.Client
Assembly Version: 1.2.1.1
Win32 Version: 1.2.1.1
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
************** 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.
Comments
Thanks for pointing this out. It's easily reproducible and shouldn't be that hard to fix. I've noted this as a bug to be fixed in a future version of SQL Compare.