SQL compare and SQL Data compare randomly crash

Kbeiting1Kbeiting1 Posts: 6
edited October 29, 2007 10:36AM in SQL Compare Previous Versions
I am having trouble with SQL Compare and SQL Data Compare randomly crashing, generally I get an error message simular to this one:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at _126._1()
OK

I am running RedGate 6.1 on a 64 bit Windows 2003 server, Standard edition and SQL 2005 64 bit Developer
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    It looks like the .NET Framework installation is corrupt (especially considering 'randomness'). You may want to try cleaning up your .NET Framework native images: the Framework has probably cached some native code because you would not normally see these type of memory errors in managed code.

    Try running ngen update from a command prompt. Ngen.exe is in your .NET Framework installation folder ie c:\windows\microsoft.net\framework\vx.x.xxxx

    It could also be a virus checker/file protection agent causing the problem so you'll want to rule those out as well.
    · Share on Twitter
  • Kbeiting1Kbeiting1 Posts: 6
    I ran the ngen update as suggested, but I have a new error:
    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 RedGate.SQLDataCompare.UI.TableView.SQLViewTab.DisposeCancel()
    at _141.Dispose(Boolean disposing)
    at System.ComponentModel.Component.Dispose()
    at System.Windows.Forms.Control.Dispose(Boolean disposing)
    at System.Windows.Forms.ContainerControl.Dispose(Boolean disposing)
    at ActiproSoftware.WinUICore.UIContainerControl.Dispose(Boolean disposing)
    at ActiproSoftware.UIStudio.Dock.ToolWindow.Dispose(Boolean disposing)
    at System.ComponentModel.Component.Dispose()
    at ActiproSoftware.UIStudio.Dock.DockManager.Dispose(Boolean disposing)
    at System.ComponentModel.Component.Dispose()
    at System.ComponentModel.Container.Dispose(Boolean disposing)
    at System.ComponentModel.Container.Dispose()
    at _113.Dispose(Boolean disposing)
    at System.ComponentModel.Component.Dispose()
    at System.Windows.Forms.Form.WmClose(Message& m)
    at System.Windows.Forms.Form.WndProc(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


    ************** Loaded Assemblies **************
    mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
    RedGate.SQLDataCompare.UI
    Assembly Version: 6.0.0.1124
    Win32 Version: 6.0.0.1124
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/RedGate.SQLDataCompare.UI.exe
    RedGate.SQLDataCompare.Engine
    Assembly Version: 6.0.0.776
    Win32 Version: 6.0.0.776
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/RedGate.SQLDataCompare.Engine.DLL
    System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    DevExpress.Utils.v6.3
    Assembly Version: 6.3.1.0
    Win32 Version: 6.3.1.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/DevExpress.Utils.v6.3.DLL
    RedGate.SQL.Shared
    Assembly Version: 6.2.0.25
    Win32 Version: 6.2.0.25
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/RedGate.SQL.Shared.DLL
    RedGate.SQLCompare.Engine
    Assembly Version: 6.2.0.45
    Win32 Version: 6.2.0.45
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/RedGate.SQLCompare.Engine.DLL
    RedGate.SQLCompare.BackupReader
    Assembly Version: 6.0.0.776
    Win32 Version: 6.0.0.776
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/RedGate.SQLCompare.BackupReader.DLL
    System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
    RedGate.Licensing.Client
    Assembly Version: 1.4.0.8
    Win32 Version: 1.4.0.8
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/RedGate.Licensing.Client.DLL
    ActiproSoftware.UIStudio.Dock.Net20
    Assembly Version: 2.0.77.0
    Win32 Version: 2.0.77.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/ActiproSoftware.UIStudio.Dock.Net20.DLL
    DevExpress.XtraEditors.v6.3
    Assembly Version: 6.3.1.0
    Win32 Version: 6.3.1.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/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%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/DevExpress.Data.v6.3.DLL
    DevExpress.XtraBars.v6.3
    Assembly Version: 6.3.1.0
    Win32 Version: 6.3.1.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/DevExpress.XtraBars.v6.3.DLL
    ActiproSoftware.Shared.Net20
    Assembly Version: 1.0.85.0
    Win32 Version: 1.0.85.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/ActiproSoftware.Shared.Net20.DLL
    ActiproSoftware.WinUICore.Net20
    Assembly Version: 1.0.85.0
    Win32 Version: 1.0.85.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/ActiproSoftware.WinUICore.Net20.DLL
    DevExpress.XtraGrid.v6.3
    Assembly Version: 6.3.1.0
    Win32 Version: 6.3.1.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/DevExpress.XtraGrid.v6.3.DLL
    DevExpress.XtraPrinting.v6.3
    Assembly Version: 6.3.1.0
    Win32 Version: 6.3.1.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/DevExpress.XtraPrinting.v6.3.DLL
    System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
    RedGate.SQL.Controls
    Assembly Version: 6.2.0.25
    Win32 Version: 6.2.0.25
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/RedGate.SQL.Controls.DLL
    Syncfusion.Grid.Windows
    Assembly Version: 4.202.0.37
    Win32 Version: 4.202.0.37
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/Syncfusion.Grid.Windows.DLL
    Syncfusion.Shared.Base
    Assembly Version: 4.202.0.37
    Win32 Version: 4.202.0.37
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/Syncfusion.Shared.Base.DLL
    Syncfusion.Core
    Assembly Version: 4.202.0.37
    Win32 Version: 4.202.0.37
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/Syncfusion.Core.DLL
    System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    System.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
    XtraDataTempAssembly
    Assembly Version: 0.0.0.0
    Win32 Version: 6.3.1.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/DevExpress.Data.v6.3.dll
    System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
    System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
    RedGate.SQLCompare.ASTParser
    Assembly Version: 6.2.0.45
    Win32 Version: 6.2.0.45
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/RedGate.SQLCompare.ASTParser.DLL
    RedGate.SQLCompare.Rewriter
    Assembly Version: 6.2.0.45
    Win32 Version: 6.2.0.45
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/RedGate.SQLCompare.Rewriter.DLL
    RedGate.BackupReader
    Assembly Version: 1.0.0.408
    Win32 Version: 1.0.0.408
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/RedGate.BackupReader.DLL
    RedGate.Update.Client
    Assembly Version: 1.2.1.1
    Win32 Version: 1.2.1.1
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/RedGate.Update.Client.DLL
    ActiproSoftware.Wizard.Net20
    Assembly Version: 3.0.125.0
    Win32 Version: 3.0.125.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Red%20Gate/SQL%20Data%20Compare%206/ActiproSoftware.Wizard.Net20.DLL

    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (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 computer
    rather than be handled by this dialog box.
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    You know I'm going to have to ask: exactly when does this exception occur? Presumably not during program load.
    · Share on Twitter
  • Kbeiting1Kbeiting1 Posts: 6
    Sorry I forgot to include, this occurred as I was closing out after syncing.
    · Share on Twitter
  • richardjmrichardjm Posts: 598
    I wonder if you're hitting a race condition to do with SQL generation. I assume you had the SQL tab on the table visible in SQL Data Compare when you chose to synchronise the databases.

    After synchronizing the SQL tab was still shown and was still generating data when you chose to exit the application?

    By the looks of it the order of the disposing objects may cause a null exception on application exit on occasion.

    Is that right?
    Richard Mitchell
    Project Manager
    Red Gate Software Ltd
    · Share on Twitter
  • Kbeiting1Kbeiting1 Posts: 6
    I don’t usually have the SQL tab open. I may have that time.
    · Share on Twitter
  • Kbeiting1Kbeiting1 Posts: 6
    The errors continue, I was in the process of trying to sync some data, and when I attempt to open SqlCompare 6, it doesn’t open. I get this error on my screen:
    “EventType clr20r3, P1 redgate.sqldatacompare.ui.exe, P2 6.0.0.1124, P3 4703485d, P4 redgate.sqldatacompare.ui, P5 6.0.0.1124, P6 4703485d, P7 8f1, P8 91, P9 system.typeinitialization, P10 NIL.”

    And this error in the Application log of the server:
    Event Type: Information
    Event Source: Application Error
    Event Category: (100)
    Event ID: 1004
    Date: 10/25/2007
    Time: 9:41:02 PM
    User: N/A
    Computer: DEVSQL
    Description:
    Reporting queued error: faulting application RedGate.SQLDataCompare.UI.exe, version 6.0.0.1124, faulting module mscorwks.dll, version 2.0.50727.832, fault address 0x0021e171.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
    Data:
    0000: 41 70 70 6c 69 63 61 74 Applicat
    0008: 69 6f 6e 20 46 61 69 6c ion Fail
    0010: 75 72 65 20 20 52 65 64 ure Red
    0018: 47 61 74 65 2e 53 51 4c Gate.SQL
    0020: 44 61 74 61 43 6f 6d 70 DataComp
    0028: 61 72 65 2e 55 49 2e 65 are.UI.e
    0030: 78 65 20 36 2e 30 2e 30 xe 6.0.0
    0038: 2e 31 31 32 34 20 69 6e .1124 in
    0040: 20 6d 73 63 6f 72 77 6b mscorwk
    0048: 73 2e 64 6c 6c 20 32 2e s.dll 2.
    0050: 30 2e 35 30 37 32 37 2e 0.50727.
    0058: 38 33 32 20 61 74 20 6f 832 at o
    0060: 66 66 73 65 74 20 30 30 ffset 00
    0068: 32 31 65 31 37 31 21e171
    · Share on Twitter
Sign In or Register to comment.