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
Comment author was deleted
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...