Copied to clipboard

Flag this post as spam?

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


  • Jason D 21 posts 52 karma points
    Jan 21, 2021 @ 17:09
    Jason D
    0

    I recently put our Umbraco site up into an Azure App, and it is working well, except I see tons of these errors:

       Jan 20, 2021 3:29:04 PM  Error   RD0003FF84E5CF  Exception ("fcd10e9e").
    Exception
    System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated.
    The statement has been terminated.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteScalar()
       at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteScalar() in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbCommand.cs:line 336
       at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<ExecuteScalar>b__32_0() in d:\a\1\s\src\Umbraco.Core\Persistence\FaultHandling\RetryDbConnection.cs:line 214
       at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass33_0`1.<Execute>b__0() in d:\a\1\s\src\Umbraco.Core\Persistence\FaultHandling\RetryDbConnection.cs:line 222
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) in d:\a\1\s\src\Umbraco.Core\Persistence\FaultHandling\RetryPolicy.cs:line 172
       at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.Execute[T](Func`1 f) in d:\a\1\s\src\Umbraco.Core\Persistence\FaultHandling\RetryDbConnection.cs:line 219
       at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteScalar() in d:\a\1\s\src\Umbraco.Core\Persistence\FaultHandling\RetryDbConnection.cs:line 214
       at NPoco.Database.ExecuteScalarHelper(DbCommand cmd)
       at NPoco.DatabaseTypes.SqlServerDatabaseType.ExecuteInsert[T](Database db, DbCommand cmd, String primaryKeyName, Boolean useOutputClause, T poco, Object[] args)
       at NPoco.Database.InsertImp[T](PocoData pocoData, String tableName, String primaryKeyName, Boolean autoIncrement, T poco)
       at NPoco.Database.Insert[T](String tableName, String primaryKeyName, Boolean autoIncrement, T poco)
       at NPoco.Database.Insert[T](T poco)
       at InboundLinkErrors.Core.LinkErrorsRepository.Add(LinkErrorEntity entity)
       at InboundLinkErrors.Core.LinkErrorsService.TrackMissingLink(String url)
       at InboundLinkErrors.Core.LinkErrorsInjectedModule.OnContextEndRequestHandler(Object sender, EventArgs args)
       at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
    ClientConnectionId:e9c63e6a-d292-4efb-bb43-08e1b528990a
    Error Number:8152,State:30,Class:16
    ClientConnectionId before routing:d8a58dcf-8f79-4920-9175-2375faa31695
    Routing Destination:ad55a619fe4e.tr3708.westus1-a.worker.database.windows.net,11026
    

    I am not sure how to pinpoint the issue?

  • AddWeb Solution Pvt. Ltd 71 posts 291 karma points
    Jan 22, 2021 @ 10:23
    AddWeb Solution Pvt. Ltd
    100

    Hello Jason,

    This error might occurs when your column size is less than your text size. For Example : In Database you have column "name varchar(10)" and the size of your data is greater than 10 . At this Situation error is occurred. EX : If i enter "length is more than 10" in name field than it will give error . so I have to change my column size from 10 to 20.

  • Jason D 21 posts 52 karma points
    Jan 25, 2021 @ 18:37
    Jason D
    0

    Ok, thank you. I'll look into this and see what I can find... I'm guessing it happened in a migration of the database.

  • Markus Johansson 1696 posts 4865 karma points c-trib
    Jan 25, 2021 @ 21:16
    Markus Johansson
    0

    You can also see from the trace that it’s a table in some package

    InboundLinkErrors.Core.LinkErrorsRepository.Add()

    Most likely a long URL that could not be stored?

Please Sign in or register to post replies

Write your reply to:

Draft