Ticket #172 (closed: repoened)

Opened 11 years ago

Last modified 11 years ago

Attempt to open Ocean Test model from old Ecopath mdb caused crash

Reported by: robynf Owned by: administrator
Priority: normal Milestone: Ecopath 6: build 6.0.7
Component: Database / Import Version:
Severity: crash Keywords:
Cc:

Description

I tried extracting the Ocean Test Model from the old Ecopath.mdb (with today's release). Unhandled exception occurred:

Column 'ScenarioID, FleetID, HabitatID is constrained to be unique value '1,1,0' is already present.

Details below.

The other models in that mdb open without problem.

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

Exception Text
System.Data.ConstraintException?: Column 'ScenarioID, FleetID, HabitatID' is constrained to be unique. Value '1, 1, 0' is already present.

at System.Data.UniqueConstraint?.CheckConstraint?(DataRow? row, DataRowAction? action)
at System.Data.DataTable?.RaiseRowChanging?(DataRowChangeEventArgs? args, DataRow? eRow, DataRowAction? eAction, Boolean fireEvent)
at System.Data.DataTable?.SetNewRecordWorker?(DataRow? row, Int32 proposedRecord, DataRowAction? action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataTable?.InsertRow?(DataRow? row, Int32 proposedID, Int32 pos, Boolean fireEvent)
at System.Data.DataRowCollection?.Add(DataRow? row)
at EwEUtils.Database.cEwEDatabase.cEwEDbWriter.AddRow?(DataRow? drow)
at EwECore.Database.cEwE6DatabaseImporter.ImportEcoSpaceFleets?(String strModelName)
at EwECore.Database.cEwE6DatabaseImporter.Import(String strModelName, cEwEDatabase& dbEwE6)
at EwECore.Database.cEwE6DatabaseImporter.Import(String strModelName, String strEwE6DBName)
at ScientificInterface?.Wizard.DatabaseConversionWizard?.ActivatePage?(Int32 pageIndex)
at ScientificInterface?.Wizard.WizardFormBase?.set_CurrentPage(Int32 iPageIndex)
at ScientificInterface?.Wizard.WizardFormBase?.OnPageIndexChanged?(Int32 iPageIndex)
at ScientificInterface?.Wizard.WizardFormBase?.btnNext_Click(Object sender, EventArgs? e)
at System.Windows.Forms.Control.OnClick?(EventArgs? e)
at System.Windows.Forms.Button.OnClick?(EventArgs? e)
at System.Windows.Forms.Button.OnMouseUp?(MouseEventArgs? mevent)
at System.Windows.Forms.Control.WmMouseUp?(Message& m, MouseButtons? button, Int32 clicks)
at System.Windows.Forms.Control.WndProc?(Message& m)
at System.Windows.Forms.ButtonBase?.WndProc?(Message& m)
at System.Windows.Forms.Button.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.42 (RTM.050727-4200)
CodeBase?: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll


EwE6

Assembly Version: 6.0.0.18
Win32 Version: 1.0.0.0
CodeBase?: file:///C:/Program%20Files/Ecopath%20with%20Ecosim%206/EwE6.exe


System.Windows.Forms

Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
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.42 (RTM.050727-4200)
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.42 (RTM.050727-4200)
CodeBase?: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll


WeifenLuo?.WinFormsUI.Docking

Assembly Version: 2.1.2734.23473
Win32 Version: 2.1.0.0
CodeBase?: file:///C:/Program%20Files/Ecopath%20with%20Ecosim%206/WeifenLuo.WinFormsUI.Docking.DLL


EwEPlugin

Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase?: file:///C:/Program%20Files/Ecopath%20with%20Ecosim%206/EwEPlugin.DLL


EwEUtils

Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase?: file:///C:/Program%20Files/Ecopath%20with%20Ecosim%206/EwEUtils.DLL


System.Configuration

Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase?: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll


System.Xml

Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase?: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll


EwECore

Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase?: file:///C:/Program%20Files/Ecopath%20with%20Ecosim%206/EwECore.DLL


SAUPUtil

Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase?: file:///C:/Program%20Files/Ecopath%20with%20Ecosim%206/SAUPUtil.DLL


Microsoft.VisualBasic?

Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase?: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll


System.Data

Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase?: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll


EwECustomPlugins

Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase?: file:///C:/Program%20Files/Ecopath%20with%20Ecosim%206/EwECustomPlugins.DLL


EwENetworkAnalysis

Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase?: file:///C:/Program%20Files/Ecopath%20with%20Ecosim%206/EwENetworkAnalysis.DLL


SourceGrid2

Assembly Version: 2.0.3.1
Win32 Version: 2.0.3.1
CodeBase?: file:///C:/Program%20Files/Ecopath%20with%20Ecosim%206/SourceGrid2.DLL


SourceLibrary?

Assembly Version: 1.2.0.0
Win32 Version: 1.2.0.0
CodeBase?: file:///C:/Program%20Files/Ecopath%20with%20Ecosim%206/SourceLibrary.DLL


ZedGraph?

Assembly Version: 5.0.8.21916
Win32 Version: 5.0.8.21916
CodeBase?: file:///C:/Program%20Files/Ecopath%20with%20Ecosim%206/ZedGraph.DLL


mf5yloga

Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase?: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll


System.Transactions

Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
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.42 (RTM.050727-4200)
CodeBase?: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll


Microsoft.mshtml

Assembly Version: 7.0.3300.0
Win32 Version: 7.0.3300.0
CodeBase?: file:///C:/WINDOWS/assembly/GAC/Microsoft.mshtml/7.0.3300.0__b03f5f7f11d50a3a/Microsoft.mshtml.dll


System.Deployment

Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase?: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.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.

Change History

comment:1 Changed 11 years ago by jeroens

The code tried to import Ecospace fishing for a habitat that no longer existed. I added the check (and a potential similar crash on MPAs), fixed after build 6.0.0.18

comment:2 Changed 11 years ago by carieh

Hey, just tried this with the new version 6.0.3 and importing gets stuck, and progress bar freezes saying Importing Ecospace fleet.

comment:3 Changed 11 years ago by jeroens

Hey Carie, would you be able to send me the model this occurs in?

comment:4 Changed 11 years ago by carieh

Ok in newest version, the import box still freezes, but there is a database that is created, and if you go back you can open the database. You do have to close EwE down first, as it still freezes, but the database is created, and does open normally. I e-mailed you the model, try importing it from the ecopath.mdb file

comment:5 Changed 11 years ago by jeroens

In this particular model, some fields in the Ecospace Gear table were unexpectedly emty (DBNull). Added a test for these and similar cases.

Note: See TracTickets for help on using tickets.