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

[robynf]

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.

[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

[carieh]

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

[jeroens]

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

[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

[jeroens]

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