Edit SWAT Databases

722 views
Skip to first unread message

Philipp

unread,
Jan 21, 2015, 4:32:59 AM1/21/15
to swat...@googlegroups.com
Hi everybody,

 I try to edit my database User Soils. I would like to add a new Soil-Type, but when I am done with the procedure (chnaging the parameters)
I always receive the following message;

Unhandled exception has occured in a component in your application. If you click Continue, the application will ignore the error and attempt to continue.
The number of que
ry values and the target fields are not identical.

It would be great if someone could help me with it!
Thanks.
Philipp

Philipp

unread,
Jan 21, 2015, 9:51:07 AM1/21/15
to swat...@googlegroups.com
its me again - still hope that someone can help - here the details of the error message;

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

************** Exception Text **************
System.Data.OleDb.OleDbException: Anzahl der Abfragewerte und Zielfelder stimmt nicht überein.
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
   at SWAT_InputFileEdit.frmUsrSoilEdit.cmdSave_Click(Object sender, EventArgs e)
   at SWAT_InputFileEdit.frmUsrSoilEdit.cmdExit_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.5485 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ESRI.DADF.Core
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.2/bin/ESRI.DADF.Core.DLL
----------------------------------------
msvcm90
    Assembly Version: 9.0.30729.7523
    Win32 Version: 9.00.30729.7523
    CodeBase: file:///C:/Windows/WinSxS/x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.7523_none_508f21ccbcbbb7a8/msvcm90.dll
----------------------------------------
SWAT_HRUs
    Assembly Version: 0.0.0.0
    Win32 Version: 0.0.0.0
    CodeBase: file:///c:/SWAT/ArcSWAT/swat_hrus.dll
----------------------------------------
ESRI.ArcGIS.System
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.System/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.System.dll
----------------------------------------
SWAT_PM2
    Assembly Version: 1.0.5365.21245
    Win32 Version: 1.0.5365.21245
    CodeBase: file:///c:/SWAT/ArcSWAT/SWAT_PM2.dll
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.5483 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5485 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
SWAT_WD
    Assembly Version: 1.1.5365.21245
    Win32 Version: 1.1.5365.21245
    CodeBase: file:///c:/SWAT/ArcSWAT/SWAT_WD.dll
----------------------------------------
ESRI.ArcGIS.ArcMapUI
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.ArcMapUI/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.ArcMapUI.dll
----------------------------------------
Interop.Scripting
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///c:/SWAT/ArcSWAT/Interop.Scripting.DLL
----------------------------------------
ESRI.ArcGIS.Framework
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Framework/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Framework.dll
----------------------------------------
ESRI.ArcGIS.SearchUI
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.2/bin/ESRI.ArcGIS.SearchUI.DLL
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5483 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5483 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
ESRI.ArcGIS.SearchControl
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.2/bin/ESRI.ArcGIS.SearchControl.DLL
----------------------------------------
ESRI.ArcGIS.SearchCore
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.2/bin/ESRI.ArcGIS.SearchCore.DLL
----------------------------------------
ESRI.ArcGIS.Carto
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Carto/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Carto.dll
----------------------------------------
ESRI.ArcGIS.Search
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Search/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Search.dll
----------------------------------------
ESRI.ArcGIS.SystemUI
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.SystemUI/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.SystemUI.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5483 (Win7SP1GDR.050727-5400)
    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.5485 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
ESRI.ArcGIS.Version
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Version/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Version.dll
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5483 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
ESRI.ArcGIS.Geoprocessing
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Geoprocessing/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Geoprocessing.dll
----------------------------------------
GpMetadataFunctions
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.2/bin/GpMetadataFunctions.DLL
----------------------------------------
ESRI.ArcGIS.Geodatabase
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Geodatabase/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Geodatabase.dll
----------------------------------------
System.Core
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.5420 built by: Win7SP1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Data.SqlXml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5485 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Data.SqlXml/2.0.0.0__b77a5c561934e089/System.Data.SqlXml.dll
----------------------------------------
System.Xml.Xsl.CompiledQuery.1
    Assembly Version: 0.0.0.0
    Win32 Version: 2.0.50727.5485 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Data.SqlXml/2.0.0.0__b77a5c561934e089/System.Data.SqlXml.dll
----------------------------------------
mscorlib.resources
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5485 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Lucene.Net
    Assembly Version: 2.9.2.1
    Win32 Version: 2.9.2.1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Lucene.Net/2.9.2.1__402f1553d5c332e7/Lucene.Net.dll
----------------------------------------
ESRI.ArcGIS.Geometry
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Geometry/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Geometry.dll
----------------------------------------
Snowball.Net
    Assembly Version: 2.0.0.1
    Win32 Version: 2.0.0.1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Snowball.Net/2.0.0.1__402f1553d5c332e7/Snowball.Net.dll
----------------------------------------
ESRI.ArcGIS.MxCommands
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.2/bin/ESRI.ArcGIS.MxCommands.DLL
----------------------------------------
PresentationFramework
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.6920.5453 built by: Win7SP1GDR
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/PresentationFramework/3.0.0.0__31bf3856ad364e35/PresentationFramework.dll
----------------------------------------
WindowsBase
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.6920.5453 built by: Win7SP1GDR
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsBase/3.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
PresentationCore
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.6920.5453 built by: Win7SP1GDR
    CodeBase: file:///C:/Windows/assembly/GAC_32/PresentationCore/3.0.0.0__31bf3856ad364e35/PresentationCore.dll
----------------------------------------
ESRI.ArcGIS.Desktop.AddIns.Factory
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.2/bin/ESRI.ArcGIS.Desktop.AddIns.Factory.DLL
----------------------------------------
ESRI.ArcGIS.Desktop.AddIns
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.2/bin/ESRI.ArcGIS.Desktop.AddIns.DLL
----------------------------------------
ESRI.ArcGIS.MapCenter
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Users/Admin/AppData/Local/ESRI/Desktop10.2/AssemblyCache/%7B75701328-F0CC-4E65-B204-99944EDF5B93%7D/ESRI.ArcGIS.MapCenter.dll
----------------------------------------
SWAT_InputFileGen
    Assembly Version: 1.0.5365.21245
    Win32 Version: 1.0.5365.21245
    CodeBase: file:///c:/SWAT/ArcSWAT/swat_inputfilegen.dll
----------------------------------------
SWAT_InputFileEdit
    Assembly Version: 1.0.5365.21245
    Win32 Version: 1.0.5365.21245
    CodeBase: file:///c:/SWAT/ArcSWAT/swat_inputfileedit.dll
----------------------------------------
SWAT_RunSwat
    Assembly Version: 1.0.5365.21245
    Win32 Version: 1.0.5365.21245
    CodeBase: file:///c:/SWAT/ArcSWAT/swat_runswat.dll
----------------------------------------
ESRI.ArcGIS.ArcGlobe
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.ArcGlobe/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.ArcGlobe.dll
----------------------------------------
ESRI.ArcGIS.ArcScene
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.ArcScene/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.ArcScene.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
----------------------------------------
ESRI.ArcGIS.GlobeCore
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.GlobeCore/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.GlobeCore.dll
----------------------------------------
ESRI.ArcGIS.3DAnalyst
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.3DAnalyst/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.3DAnalyst.dll
----------------------------------------
ESRI.ArcGIS.Display
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.Display/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.Display.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5483 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5483 (Win7SP1GDR.050727-5400)
    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.5483 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
ESRI.ArcGIS.DataSourcesGDB
    Assembly Version: 10.2.0.0
    Win32 Version: 10.2.1.3497
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ESRI.ArcGIS.DataSourcesGDB/10.2.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.DataSourcesGDB.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.

Camila Guimaraes

unread,
Apr 27, 2015, 2:18:35 PM4/27/15
to swat...@googlegroups.com
Hi Philipp, 
I am having the same problem. Did you find the solution for for it?
How? I would appreciate if you help me!
Thanks!

hadi

unread,
Apr 28, 2015, 1:49:43 PM4/28/15
to swat...@googlegroups.com
Hi Camila.

Check for any blank cell in your user soil database. I also suggest to compare your usersoil database with geodatabse (e.g. SWAT2012.mdb) files in SWAT examples.

Hope that helps.
Hadi

Thais Palumbo

unread,
Feb 4, 2020, 3:32:37 PM2/4/20
to SWAT-user
Hello! 
Did you find the solution for this?

Thanks


Em quarta-feira, 21 de janeiro de 2015 07:32:59 UTC-2, Philipp escreveu:

Amanda Snow

unread,
Feb 6, 2020, 3:18:30 PM2/6/20
to SWAT-user
I was running into this same problem.

For me, it turned out that my database was too large to open in Access (where it is edited).  To get around that, I have to edit it directly in the Access table.

Setareh Amini

unread,
Jan 6, 2022, 7:04:20 AM1/6/22
to SWAT-user
Hi everyone,
I got into the same trouble, it would be my pleasure to guide me on how I can deal with it.
Many Thanks
Reply all
Reply to author
Forward
0 new messages