Custom Query (1539 matches)

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.

Need buttons/checkboxes to invoke:

1. Fleet/Effort? dynamics module
2. Network analysis in Ecosim (see additional information below)

This is what used to happen when NA was implemented in Ecosim:

Some network analysis indices have been extended into Ecosim. To obtain these indices and their changes over time from Ecosim, the Indices checkbox should be checked on the Ecosim Biomass form. If Network Analysis has not been invoked prior to Ecosim, a message stating Trophic levels not read, do Network Analysis will be given. It is not necessary to wait for all the cycles to be calculated (which might take 24 hours), but you can press cancel to obtain the Network Analysis indices given in Ecosim. When the Indices checkbox is checked and Ecosim is run the FIB, Kemptons Q etc. indices will be shown in Ecosim, and a file named network.csv will be saved in the same directory as the Ecopath database. This file should be renamed if you want rerun the network analysis indices, as it will also save results to the same file.

The file will give the throughput (Trput), development capacity (Capacity), Ascendency on import (Asc import), flow (Asc flow), export (Asc exp) and respiration (Asc resp), Overhead on import (Ovh import), flow (Ovh flow), export (Ovh exp) and respiration (Ovh resp), predatory cycling index (PCI) and Finn cycling index (FCI) for each monthly time step of the simulation.

Same issue as with forcing functions- the values in the values tab cannot be set- they can be entered in, but they do not get saved, and there is an error when you try to do this.