If you enter a long search string in the "Search For:" box, the system throws an exception.
I entered:
Unhandled Exception Arithmetic operation resulted in an overflow. TopStack:
And it returned the exception below.
The text I entered was name of several incidents that I wanted to relate together.
ee the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Data.SqlClient.SqlException: Line 69: Incorrect syntax near '.'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Axosoft.Common.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Axosoft.Common.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Axosoft.OnTime.DataLayer.Defects.GetPage(PageIdType getPageBy, Int32 pageNumber, Int32 rowCount, User currentUser, Int32 projectId, String filterString)
at Axosoft.OnTime.DataLayer.Defects.GetPage(User currentUser, String filterString)
at Axosoft.OnTimeWinControls.AddEditItemRelationForm.GetDefectsData(String searchString)
at Axosoft.OnTimeWinControls.AddEditItemRelationForm.searchButton_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.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
----------------------------------------
OnTime
Assembly Version: 7.0.1.7150
Win32 Version: 7.0.1.7150
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/OnTime.exe
----------------------------------------
Axosoft.OnTime.DataLayer
Assembly Version: 7.0.1.7150
Win32 Version: 7.0.1.7150
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.OnTime.DataLayer.DLL
----------------------------------------
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
----------------------------------------
Axosoft.Common.Utilities
Assembly Version: 7.0.1.7150
Win32 Version: 7.0.1.7150
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.Common.Utilities.DLL
----------------------------------------
Axosoft.OnTimeWinControls
Assembly Version: 7.0.1.7150
Win32 Version: 7.0.1.7150
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.OnTimeWinControls.DLL
----------------------------------------
Axosoft.Common.ExceptionManagement
Assembly Version: 7.0.1.7150
Win32 Version: 7.0.1.7150
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.Common.ExceptionManagement.DLL
----------------------------------------
Axosoft.OnTimeResources
Assembly Version: 7.0.1.7150
Win32 Version: 7.0.1.7150
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.OnTimeResources.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
----------------------------------------
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
----------------------------------------
bnazh6pz
Assembly Version: 7.0.1.7150
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Axosoft.Common.Data
Assembly Version: 7.0.1.7150
Win32 Version: 7.0.1.7150
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.Common.Data.DLL
----------------------------------------
System.Web.Services
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
----------------------------------------
Axosoft.OnTimeConfiguration
Assembly Version: 7.0.1.7150
Win32 Version: 7.0.1.7150
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.OnTimeConfiguration.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
----------------------------------------
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
----------------------------------------
System.Security
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.dll
----------------------------------------
9hknrql5
Assembly Version: 7.0.1.7150
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
8rra25fl
Assembly Version: 7.0.1.7150
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Axosoft.OnTimeDashboard
Assembly Version: 7.0.1.7150
Win32 Version: 7.0.1.7150
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.OnTimeDashboard.DLL
----------------------------------------
Axosoft.WinControls
Assembly Version: 7.0.1.7150
Win32 Version: 7.0.1.7150
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.WinControls.DLL
----------------------------------------
HTMLEditorControl
Assembly Version: 7.0.1.7150
Win32 Version: 7.0.1.7150
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/HTMLEditorControl.DLL
----------------------------------------
AxInterop.SHDocVw
Assembly Version: 1.1.0.0
Win32 Version: 1.1.0.0
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/AxInterop.SHDocVw.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
----------------------------------------
SHDocVw
Assembly Version: 1.1.0.0
Win32 Version: 1.1.0.0
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/SHDocVw.DLL
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
2tblnmkm
Assembly Version: 7.0.1.7150
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
SharpGraph.Windows
Assembly Version: 1.1.0.1545
Win32 Version: 1.1.0.1545
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/SharpGraph.Windows.DLL
----------------------------------------
System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
WebKeyGenerator
Assembly Version: 2.0.2049.23152
Win32 Version: 1.1.0.1545
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/SharpGraph.Windows.dll
----------------------------------------
Axosoft.Common.Utilities.TextHelper
Assembly Version: 7.0.1.7150
Win32 Version: 7.0.1.7150
CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.Common.Utilities.TextHelper.DLL
----------------------------------------
System.Data.SqlXml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Data.SqlXml/2.0.0.0__b77a5c561934e089/System.Data.SqlXml.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.