April 16, 200719 yr The following text keeps coming up, when attempting to contact support: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: Line 118: insertCmd.Parameters["@Name"].Value = strNameIn;Line 119: insertCmd.Parameters["@Status"].Value = status;Line 120: insertCmd.ExecuteNonQuery();Line 121: return new Message(customer.ID,dateTime,messText,strNameIn,status);Line 122: } Source File: nas16entdomainsvvoxatc.comuserhtdocsApp_CodeMessages.cs Line: 120 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) +857194 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734806 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135 Messages.Create(String strEMailIn, DateTime dateTime, String messText, String strNameIn, String status) in nas16entdomainsvvoxatc.comuserhtdocsApp_CodeMessages.cs:120 Contact.SubmitB_Click(Object sender, EventArgs e) in nas16entdomainsvvoxatc.comuserhtdocsContact.aspx.cs:22 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102 --------------------------------------------------------------------------------Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210Can you contact support any other way?
April 16, 200719 yr Brian,Seems to be working ok now (for me at any rate)...http://www.voxatc.com/Contact.aspxVox
April 16, 200719 yr Hi,Many thanks for your reply.Just tried again, with no luck!Must be something to do with my system, I guess?
April 16, 200719 yr I experienced the same recently and it appears to happen if your post exceeds a certain lenght.I am not sure how long, but by splitting up my post, it went through. I guess the programmer messed up with a fixed size array being a tad on the small side.../ Cheers, Poul
April 16, 200719 yr Hi Poul,Thank you for this information, I did try reducing some of my text, even cut paragraphs out!I'll give it another try.Many thanks!!
April 16, 200719 yr Just tried again, Poul.Cut it down to about 10 lines, and it went through.Many thanks for your help. I truly appreciate your help. :-)
Create an account or sign in to comment