SQL Exception thrown by Umbraco.Forms.Data.Storage.RecordFieldValueStorage.InsertRecordFieldValues
Hi,
we are using umbraco 4.7 + contour.
and recently we got following exception
Please help as soon as possible.
Best regards
Stone Yen
At / (Referred by: http://websiteurl): umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) at Umbraco.Forms.Data.Storage.RecordFieldValueStorage.InsertRecordFieldValues(RecordField rf) in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Data\RecordStorage\RecordFieldValueStorage.cs:line 103 at Umbraco.Forms.Data.Storage.RecordFieldStorage.InsertRecordField(RecordField recordfield) in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Data\RecordStorage\RecordFieldStorage.cs:line 105 at Umbraco.Forms.Data.Storage.RecordStorage.InsertRecord(Record record, Form form) in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Data\RecordStorage\RecordStorage.cs:line 129 at Umbraco.Forms.Core.Services.RecordService.PersistRecord() in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Services\RecordService\RecordService.cs:line 413 at Umbraco.Forms.Core.Services.RecordService.Submit() in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Services\RecordService\RecordService.cs:line 182 at Umbraco.Forms.Core.Services.RecordService.NextPage() in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Services\RecordService\RecordService.cs:line 259 at Umbraco.Forms.UI.Usercontrols.RenderForm.nextPage(Object sender, EventArgs e) in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.UI\Usercontrols\RenderForm.ascx.cs:line 206 at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
SQL Exception thrown by Umbraco.Forms.Data.Storage.RecordFieldValueStorage.InsertRecordFieldValues
Hi,
we are using umbraco 4.7 + contour.
and recently we got following exception
Please help as soon as possible.
Best regards
Stone Yen
At / (Referred by: http://websiteurl):
umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery
---> System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)
--- End of inner exception stack trace ---
at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)
at Umbraco.Forms.Data.Storage.RecordFieldValueStorage.InsertRecordFieldValues(RecordField rf)
in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Data\RecordStorage\RecordFieldValueStorage.cs:line 103
at Umbraco.Forms.Data.Storage.RecordFieldStorage.InsertRecordField(RecordField recordfield) in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Data\RecordStorage\RecordFieldStorage.cs:line 105
at Umbraco.Forms.Data.Storage.RecordStorage.InsertRecord(Record record, Form form) in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Data\RecordStorage\RecordStorage.cs:line 129
at Umbraco.Forms.Core.Services.RecordService.PersistRecord() in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Services\RecordService\RecordService.cs:line 413
at Umbraco.Forms.Core.Services.RecordService.Submit() in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Services\RecordService\RecordService.cs:line 182
at Umbraco.Forms.Core.Services.RecordService.NextPage() in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.Core\Services\RecordService\RecordService.cs:line 259
at Umbraco.Forms.UI.Usercontrols.RenderForm.nextPage(Object sender, EventArgs e) in d:\TeamCity6\buildAgent\work\278191fcc80f7b16\Umbraco.Forms.UI\Usercontrols\RenderForm.ascx.cs:line 206
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
contour version is 1.1.6
Hi,
Are you using any third party fieldtypes? If possible could you mail me an export of the form ( tg at umbraco dot com)
Thanks,
Tim
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.