Issue: dbForge Studio for Oracle crashes while attempting to compare profile statistics

Issue: dbForge Studio for Oracle crashes while attempting to compare profile statistics

Postby wi937c-amr » Thu 19 Jul 2012 16:05

Issue:

dbForge Studio for Oracle crashes while attempting to compare profile statistics.

Steps to reproduce:

- In the profiler window/tab select two or more query profiles to compare
- Click the "Compare Selected Results" icon on the profiler toolbar.

dbForge Studio for Oracle Error Report

=========================
General
=========================
Application: dbForge Studio for Oracle
Product: Devart dbForge Studio for Oracle
Product Locale: English
Assembly: dbforgeoracle, Version=3.1.206.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.exe
Global cache: False
Framework: 2.0.50727.5456

=========================
Exception Information
=========================
Message: Object reference not set to an instance of an object.
Source: Devart.DbForge.Provider
TargetSite: qk a(System.Object, System.Object, System.Object)
HelpLink:
Type: System.NullReferenceException
Place: 2
Stack:
at jq.a.a(Object A_0, Object A_1, Object A_2)
at ca0.a(Int32 A_0, IList`1 A_1, ag4 A_2, String A_3)
at ca0.MergeTablesForComparison(IList`1 tables, IList`1 columnsToPropagate, Int32 keyColumn, ag4 rowComparer)
at jq.a(IList`1 A_0)
at jq.l()
at Controls.Bars.BarItem.OnClick(BarItemLink link)
at Controls.Bars.BarItemLink.OnLinkClick()
at Controls.Bars.ViewInfo.BarSelectionInfo.UnPressLink(BarItemLink link)
at Controls.Bars.Controls.CustomLinksControl.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at Controls.Bars.Controls.DockedBarControl.WndProc(Message& msg)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

=========================
Window Layout
=========================
Active document window: 'SQL.sql*' (Profiler)

Documents:
Name: 'QAMN0160.PACKAGE1 (Body)', Caption: 'QAMN0160.PACKAGE1 (Body)', Visible: False, Active view: 'Code', Initial view: ''
Name: 'GET_FOLDER_LEVELS.sql', Caption: 'GET_FOLDER_LEVELS.sql*', Visible: False, Active view: 'Code', Initial view: 'Code'
Name: 'SQL.sql', Caption: 'SQL.sql*', Visible: True, Active view: 'Profiler', Initial view: 'Code'
Name: 'QAMN0160.PACKAGE1.GET_FOLDER_HIERARCHY', Caption: 'QAMN0160.PACK...DER_HIERARCHY', Visible: False, Active view: 'Data', Initial view: 'Code'

Toolwindows (visible or have been shown in current session):
Caption: 'Start Page', Visible: 'False', DefaultVisibility: 'Never', IsControlCreated: 'True', State: Tabbed
Caption: 'Output', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Docked
Caption: 'Code Snippets', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Error List', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Properties', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Docked
Caption: 'Database Explorer', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Docked

=========================
Projects
=========================
No projects

=========================
Connections
=========================
Performance.WR0038 (open) - 'User Id=<redacted>;Server=//<redacted>:1521/<redacted>;Unicode=True;'. Server version Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options
Performance.QAMN0160 (current) (open) - 'User Id=<redacted>;Server=//<redacted>:1521/<redacted>;Unicode=True;'. Server version Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options
Development.BVT0001 - 'User Id=<redacted>;Server=//<redacted>:1521/<redacted>;Unicode=True;'

=========================
Loaded Assemblies
=========================
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
dbforgeoracle, Version=3.1.206.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.1.206.0 C:/Program Files/Devart/dbForge Studio for Oracle/dbforgeoracle.exe
Devart.Shell.Studio, Version=1.3.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.24.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.Shell.Studio.DLL
Devart.Shell.Interfaces, Version=1.3.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.24.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.Shell.Interfaces.DLL
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
Devart.Shell.Utils, Version=1.3.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.24.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.Shell.Utils.DLL
System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
Devart.Shell.CommonRes, Version=1.3.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.24.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.Shell.CommonRes.DLL
Devart.XBars, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.XBars.DLL
Devart.XEditors, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.XEditors.DLL
Devart.XData, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.XData.DLL
Devart.XUtils, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.XUtils.DLL
Devart.Shell.Controls, Version=1.3.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.24.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.Shell.Controls.DLL
Devart.Shell.Projects, Version=1.3.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.24.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.Shell.Projects.DLL
Devart.Shell.TextEditor, Version=1.3.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.24.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.Shell.TextEditor.DLL
Devart.Studio.Help, Version=1.3.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.24.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.Studio.Help.DLL
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
Devart.DbForge.Utils, Version=5.0.282.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.282.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.Utils.DLL
Devart.DbForge.CommonServices, Version=5.0.282.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.282.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.CommonServices.DLL
Devart.DbForge.Interfaces, Version=4.0.45.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.45.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.Interfaces.DLL
Devart.Shell.TextEditor.Interfaces, Version=1.3.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.24.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.Shell.TextEditor.Interfaces.DLL
Devart.BrowseObjects, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.Shell.Utils.dll
Devart.Ole.UndoManager, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.Ole.UndoManager.DLL
Devart.DbForge.Oracle, Version=3.1.206.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.1.206.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.Oracle.DLL
Devart.DbForge.Provider, Version=5.0.282.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.282.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.Provider.DLL
Devart.DbForge.Data.Interfaces, Version=5.0.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.8.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.Data.Interfaces.DLL
Devart.DbForge.Data.Oracle, Version=5.0.54.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.54.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.Data.Oracle.DLL
Devart.DbForge.DbObjectsUI, Version=5.0.282.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.282.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.DbObjectsUI.DLL
Devart.DbForge.DbObjects, Version=5.0.282.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.282.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.DbObjects.DLL
Devart.DbForge.DbObjectsUI.Oracle, Version=3.1.206.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.1.206.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.DbObjectsUI.Oracle.DLL
Devart.DbForge.DbObjects.Oracle, Version=3.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.0.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.DbObjects.Oracle.DLL
Devart.DbForge.LanguageService.Oracle, Version=3.1.206.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.1.206.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.LanguageService.Oracle.DLL
Devart.DbForge.LanguageService, Version=5.0.282.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.282.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.LanguageService.DLL
Antlr3.Runtime, Version=0.3.0.37313, Culture=neutral, PublicKeyToken=09af7300eec23701 0.3.0.37313 C:/Program Files/Devart/dbForge Studio for Oracle/Antlr3.Runtime.DLL
Devart.DbForge.SqlComplete.Oracle, Version=3.1.206.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.1.206.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.SqlComplete.Oracle.DLL
Devart.DbForge.SqlComplete, Version=5.0.282.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.282.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.SqlComplete.DLL
Devart.DbForge.Repository, Version=5.0.282.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.282.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.Repository.DLL
Devart.DbForge.Repository.Oracle, Version=3.1.206.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.1.206.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.Repository.Oracle.DLL
Devart.Shell.Wizard, Version=1.3.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.24.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.Shell.Wizard.DLL
System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
Devart.DbForge.DataEditor.Oracle, Version=3.1.206.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.1.206.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.DataEditor.Oracle.DLL
Devart.DbForge.DataEditor, Version=5.0.282.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.282.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.DataEditor.DLL
Devart.XGrid, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.XGrid.DLL
Devart.XTreeList, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.XTreeList.DLL
System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_64/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
OciCall.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.Data.Oracle.dll
Devart.DbForge.DbEditors, Version=5.0.282.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.282.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.DbEditors.DLL
Devart.DbForge.DbEditors.Oracle, Version=3.1.206.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.1.206.0 C:/Program Files/Devart/dbForge Studio for Oracle/Devart.DbForge.DbEditors.Oracle.DLL
Ionic.Zip.Reduced, Version=1.9.1.2, Culture=neutral, PublicKeyToken=09af7300eec23701 1.9.1.2 C:/Program Files/Devart/dbForge Studio for Oracle/Ionic.Zip.Reduced.DLL

=========================
System Information
=========================
Processor architecture: amd64
Processor quantity: 4
Intel(R) Core(TM) i7 CPU M 620 @ 2.67GHz Intel64 Family 6 Model 37 Stepping 2
Intel(R) Core(TM) i7 CPU M 620 @ 2.67GHz Intel64 Family 6 Model 37 Stepping 2
Intel(R) Core(TM) i7 CPU M 620 @ 2.67GHz Intel64 Family 6 Model 37 Stepping 2
Intel(R) Core(TM) i7 CPU M 620 @ 2.67GHz Intel64 Family 6 Model 37 Stepping 2

Total physical memory: 8181Mb
Available virtual memory: 11819Mb

Operating System Name: Windows 7 Enterprise
Operating System Version: Microsoft Windows NT 6.1.7601 Service Pack 1
UAC: Disabled
Elevation Level: Default

Instances: 1
Culture: English (United States)
Process started at 07/19/2012 09:47:35
Report created at 07/19/2012 10:47:39
wi937c-amr
 
Posts: 16
Joined: Fri 29 Jun 2012 19:49

Re: Issue: dbForge Studio for Oracle crashes while attempting to compare profile statistics

Postby alexa » Fri 20 Jul 2012 10:22

Could you please provide us the SQL scripts the results of which you are comparing along with the CREATE TABLE statements of the tables mentioned in the scripts (right-click the table in Database Explorer and select 'Generate Script As -> CREATE' from the popup menu)?
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17

Re: Issue: dbForge Studio for Oracle crashes while attempting to compare profile statistics

Postby alexa » Tue 20 Nov 2012 11:51

We would like to let you know that the new build 3.1.243 of dbForge Studio for Oracle where the issue you reported is fixed, has been released and is available for downloading: http://www.devart.com/dbforge/oracle/studio/download.html

Thank you for your help in improving dbForge Studio for Oracle.
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17

Re: Issue: dbForge Studio for Oracle crashes while attempting to compare profile statistics

Postby wi937c-amr » Wed 19 Dec 2012 17:22

Thank you for addressing the issue.
wi937c-amr
 
Posts: 16
Joined: Fri 29 Jun 2012 19:49


Return to dbForge for Oracle