Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Stone Yen 34 posts 55 karma points
    Jun 01, 2011 @ 17:46
    Stone Yen
    0

    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)

  • Stone Yen 34 posts 55 karma points
    Jun 01, 2011 @ 17:50
    Stone Yen
    0

    contour version is 1.1.6

  • Comment author was deleted

    Jun 02, 2011 @ 11:06

    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

Please Sign in or register to post replies

Write your reply to:

Draft