Selecting data in poped up viewer produces error
mulmad
Posts: 94
If I, in the "viewer" window, that pops up when double-clicking a cell of a data compare result, click-drag select text in the viewer I get the error below.
Steps to reproduce error:
1) data compare table with a column of data type text
2) click the compared table, and select to view rows that are not in the one table
3) click the text column cell to view what the column contains
4) click-drag to select part of the text in the poped up viewer
Error:
Unhandled exception has occurred in your application. If you click
Continue, the application will ignore this error and attempt to continue.
If you click Quit, the application will close immediately.
ScriptStringAnalyse error:2147942487.
Error details:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Exception: ScriptStringAnalyse error:2147942487
at q.a(IntPtr , Rectangle , Int32 , Int32 , String , a , Int32 , Int32 , Int64& )
at q.a(IntPtr , String , ICharacterFormatProvider , Int32 , Int32 , Int32 , Rectangle , Boolean )
at RedGate.Shared.Controls.TextBoxControls.ColoredTextBox.OnPaint(PaintEventArgs e)
at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer, Boolean disposeEventArgs)
at System.Windows.Forms.Control.WmPaint(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.UserControl.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.1433 (REDBITS.050727-1400)
CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
RedGate.SQLDataCompare.UI
Assembly Version: 7.1.0.245
Win32 Version: 7.1.0.245
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.SQLDataCompare.UI.exe
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
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.1433 (REDBITS.050727-1400)
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.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
RedGate.SQLDataCompare.Engine
Assembly Version: 7.1.0.230
Win32 Version: 7.1.0.230
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.SQLDataCompare.Engine.DLL
DevExpress.Utils.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/DevExpress.Utils.v7.2.DLL
RedGate.Licensing.Client
Assembly Version: 2.7.0.3
Win32 Version: 2.7.0.3
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.Licensing.Client.DLL
RedGate.Shared.Controls
Assembly Version: 7.1.0.82
Win32 Version: 7.1.0.82
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.Shared.Controls.DLL
RedGate.Shared.SQL
Assembly Version: 7.1.0.39
Win32 Version: 7.1.0.39
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.Shared.SQL.DLL
RedGate.Shared.Utils
Assembly Version: 7.1.0.39
Win32 Version: 7.1.0.39
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.Shared.Utils.DLL
RedGate.SQLCompare.Engine
Assembly Version: 7.1.0.182
Win32 Version: 7.1.0.182
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.SQLCompare.Engine.DLL
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
ActiproSoftware.UIStudio.Dock.Net20
Assembly Version: 2.0.77.0
Win32 Version: 2.0.77.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/ActiproSoftware.UIStudio.Dock.Net20.DLL
DevExpress.XtraEditors.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/DevExpress.XtraEditors.v7.2.DLL
DevExpress.Data.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/DevExpress.Data.v7.2.DLL
DevExpress.XtraBars.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/DevExpress.XtraBars.v7.2.DLL
ActiproSoftware.Shared.Net20
Assembly Version: 1.0.85.0
Win32 Version: 1.0.85.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/ActiproSoftware.Shared.Net20.DLL
ActiproSoftware.WinUICore.Net20
Assembly Version: 1.0.85.0
Win32 Version: 1.0.85.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/ActiproSoftware.WinUICore.Net20.DLL
DevExpress.XtraGrid.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/DevExpress.XtraGrid.v7.2.DLL
DevExpress.XtraPrinting.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/DevExpress.XtraPrinting.v7.2.DLL
RedGate.Shared.Controls.SQL
Assembly Version: 7.1.0.82
Win32 Version: 7.1.0.82
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.Shared.Controls.SQL.DLL
Syncfusion.Grid.Windows
Assembly Version: 4.202.0.37
Win32 Version: 4.202.0.37
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/Syncfusion.Grid.Windows.DLL
Syncfusion.Shared.Base
Assembly Version: 4.202.0.37
Win32 Version: 4.202.0.37
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/Syncfusion.Shared.Base.DLL
Syncfusion.Core
Assembly Version: 4.202.0.37
Win32 Version: 4.202.0.37
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/Syncfusion.Core.DLL
System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
RedGate.Update.Client
Assembly Version: 2.2.0.3
Win32 Version: 2.2.0.3
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.Update.Client.DLL
System.Web.Services
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
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.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
RedGate.SQLCompare.ASTParser
Assembly Version: 7.1.0.182
Win32 Version: 7.1.0.182
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.SQLCompare.ASTParser.DLL
RedGate.SQLCompare.Rewriter
Assembly Version: 7.1.0.182
Win32 Version: 7.1.0.182
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.SQLCompare.Rewriter.DLL
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.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.
Steps to reproduce error:
1) data compare table with a column of data type text
2) click the compared table, and select to view rows that are not in the one table
3) click the text column cell to view what the column contains
4) click-drag to select part of the text in the poped up viewer
Error:
Unhandled exception has occurred in your application. If you click
Continue, the application will ignore this error and attempt to continue.
If you click Quit, the application will close immediately.
ScriptStringAnalyse error:2147942487.
Error details:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Exception: ScriptStringAnalyse error:2147942487
at q.a(IntPtr , Rectangle , Int32 , Int32 , String , a , Int32 , Int32 , Int64& )
at q.a(IntPtr , String , ICharacterFormatProvider , Int32 , Int32 , Int32 , Rectangle , Boolean )
at RedGate.Shared.Controls.TextBoxControls.ColoredTextBox.OnPaint(PaintEventArgs e)
at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer, Boolean disposeEventArgs)
at System.Windows.Forms.Control.WmPaint(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.UserControl.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.1433 (REDBITS.050727-1400)
CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
RedGate.SQLDataCompare.UI
Assembly Version: 7.1.0.245
Win32 Version: 7.1.0.245
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.SQLDataCompare.UI.exe
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
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.1433 (REDBITS.050727-1400)
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.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
RedGate.SQLDataCompare.Engine
Assembly Version: 7.1.0.230
Win32 Version: 7.1.0.230
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.SQLDataCompare.Engine.DLL
DevExpress.Utils.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/DevExpress.Utils.v7.2.DLL
RedGate.Licensing.Client
Assembly Version: 2.7.0.3
Win32 Version: 2.7.0.3
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.Licensing.Client.DLL
RedGate.Shared.Controls
Assembly Version: 7.1.0.82
Win32 Version: 7.1.0.82
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.Shared.Controls.DLL
RedGate.Shared.SQL
Assembly Version: 7.1.0.39
Win32 Version: 7.1.0.39
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.Shared.SQL.DLL
RedGate.Shared.Utils
Assembly Version: 7.1.0.39
Win32 Version: 7.1.0.39
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.Shared.Utils.DLL
RedGate.SQLCompare.Engine
Assembly Version: 7.1.0.182
Win32 Version: 7.1.0.182
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.SQLCompare.Engine.DLL
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
ActiproSoftware.UIStudio.Dock.Net20
Assembly Version: 2.0.77.0
Win32 Version: 2.0.77.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/ActiproSoftware.UIStudio.Dock.Net20.DLL
DevExpress.XtraEditors.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/DevExpress.XtraEditors.v7.2.DLL
DevExpress.Data.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/DevExpress.Data.v7.2.DLL
DevExpress.XtraBars.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/DevExpress.XtraBars.v7.2.DLL
ActiproSoftware.Shared.Net20
Assembly Version: 1.0.85.0
Win32 Version: 1.0.85.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/ActiproSoftware.Shared.Net20.DLL
ActiproSoftware.WinUICore.Net20
Assembly Version: 1.0.85.0
Win32 Version: 1.0.85.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/ActiproSoftware.WinUICore.Net20.DLL
DevExpress.XtraGrid.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/DevExpress.XtraGrid.v7.2.DLL
DevExpress.XtraPrinting.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/DevExpress.XtraPrinting.v7.2.DLL
RedGate.Shared.Controls.SQL
Assembly Version: 7.1.0.82
Win32 Version: 7.1.0.82
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.Shared.Controls.SQL.DLL
Syncfusion.Grid.Windows
Assembly Version: 4.202.0.37
Win32 Version: 4.202.0.37
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/Syncfusion.Grid.Windows.DLL
Syncfusion.Shared.Base
Assembly Version: 4.202.0.37
Win32 Version: 4.202.0.37
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/Syncfusion.Shared.Base.DLL
Syncfusion.Core
Assembly Version: 4.202.0.37
Win32 Version: 4.202.0.37
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/Syncfusion.Core.DLL
System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
RedGate.Update.Client
Assembly Version: 2.2.0.3
Win32 Version: 2.2.0.3
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.Update.Client.DLL
System.Web.Services
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
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.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
RedGate.SQLCompare.ASTParser
Assembly Version: 7.1.0.182
Win32 Version: 7.1.0.182
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.SQLCompare.ASTParser.DLL
RedGate.SQLCompare.Rewriter
Assembly Version: 7.1.0.182
Win32 Version: 7.1.0.182
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Data%20Compare%207/RedGate.SQLCompare.Rewriter.DLL
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.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.
Comments
Thank you for your post into the forum, I apologise you are encountering issues with SQL Data Compare.
I am struggling to recreate this, could you please give me more information?
Database A SQL Server version
Database B SQL Server version
Machine running GUI OS version.
Also, is the Data Compare GUI on a workstation or actually on the SQL Server?
Thanks,
Redgate Foundry
W2003 latest sp
Local machine:
XP pro latest sp
Both servers are sql 2000 latest service pack
Data Compare GUI runs on local machine.
Have you tried using SQL Data Compare from a different machine?
If you could e-mail your table schema and some sample data to support@red-gate.com quoting reference F0015737 that would be useful.
Thanks,
Redgate Foundry