×
![]()
Back to ITRS Internal Only FAQ
Internal documentation only
This page has been marked as draft.
[INTERNAL] GENEOS - License Database Error: Server Error in '/' Application
Related to Copied
Errors:
String or binary data would be truncated. The statement has been terminated.
The statement has been terminated.
System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
Overview Copied
A server error occurred within the application during the execution of a database operation. The system returned a SQL exception indicating that string or binary data was being truncated. This type of error typically arises when an application attempts to insert or update data that exceeds the maximum allowed length of a database section.
Problem Copied
Agents may encounter a server error when submitting a form that includes a comment section that has too many characters. The system fails to save the information and displays an error message below:
Server Error in '/' Application.
String or binary data would be truncated.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
This issue prevents the request from completing successfully and will result in no change in the license.
Cause Copied
- Root Cause 1: E****xcessive characters being entered into the comment section of the edit license function. The database column associated with this field has a fixed character limit, and the input provided exceeded that limit.
UI:
![[INTERNAL] GENEOS - License Database Error: Server Error in ‘/’ Application.](../../faq/images/itrs-internal-only/33512909139357-34234767952925-image.png)
![[INTERNAL] GENEOS - License Database Error: Server Error in ‘/’ Application.](../../faq/images/itrs-internal-only/33512909139357-34234738535197-image.png)
Stack Trace:
[SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection,
Action`1 wrapCloseInAction)
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj,
Boolean callerHasConnectionLock, Boolean asyncClose)
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler,
SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
TdsParserStateObject stateObj, Boolean& dataReady)
System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async,
Int32 timeout, Boolean asyncWrite)
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion,
String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache,
Boolean asyncWrite, Boolean inRetry)
System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
LicenseDB.AddLicense.SaveActive(String id)
in C:\Users\clee\source\repos\LicenseDB\LicenseDB\AddLicense.aspx.cs:289
LicenseDB.EditLicense.btnSave_OnClick(Object sender, EventArgs e)
in C:\Users\clee\source\repos\LicenseDB\LicenseDB\EditLicense.aspx.cs:131
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint)
Version Information: Microsoft .NET Framework Version: 4.0.30319; ASP.NET Version: 4.8.4749.0
- Root Cause 2: E****xcessive characters being entered into the comment section of the add license function. The database column associated with this field has a fixed character limit, and the input provided exceeded that limit.
UI:
![[INTERNAL] GENEOS - License Database Error: Server Error in ‘/’ Application.](../../faq/images/itrs-internal-only/33512909139357-34234767953309-image.png)
Stack Trace:
[SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName,
Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
LicenseDB.AddLicense.SaveActive(String id) in C:\Projects\LicenseDB\LicenseDB\AddLicense.aspx.cs:292
LicenseDB.AddLicense.btnAdd_OnClick(Object sender, EventArgs e) in C:\Projects\LicenseDB\LicenseDB\AddLicense.aspx.cs:245
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint)
Version Information: Microsoft .NET Framework Version: 4.0.30319; ASP.NET Version: 4.8.4749.0
Solution Copied
- Solution Root Cause 1 & 2: Remove the oldest comment entry to make way for the newest comment. Make it short and simple but complete to avoid confusion when backtracking.
["Geneos"]
["FAQ"]