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

  • 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.

Please Sign in or register to post replies