[步骤]
prometheus告警
开始时间: 19:27:16
错误代码: N1927162
sql类型: UPDATE
sql: [19:27:16] -------------------------------------------------------------
CODE:N1927162
Error:16_8152_30_-2146232060
SQL:UPDATE [RB_Procurement_Detail_SingleList] SET UpdateTime=GETDATE(), [TrackingNumber] = @TrackingNumber_1, [TrackingNumbers] = @TrackingNumbers_1 WHERE [CustomerID]=@CustomerID_1 And [Single_NO] = @Single_NO_1 ;
PARAMS:@CustomerID_1 = 1 ,@Single_NO_1 = 9743669 ,@TrackingNumber_1 = 990102827509540 ,@TrackingNumbers_1 = 990102827509540,990102827514440,990102827514351,990102827509313,990102827542793,990102827571182,990102827571035,990102827557411,990102827514416,990102827570999,990102827575371,990102827537568,990102827509305,990102827514385,990102827571051,990102827561770,990102827509389,990102827523288,990102827514369,990102827547589,990102827509339,990102827552439,990102827571205,990102827547610,990102827571027,990102827547571,990102827552421,990102827561827,990102827547628,990102827571001,990102827514424,990102827514432 ,
MESSAGE:String or binary data would be truncated.
The statement has been terminated.
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
在 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)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.ExecuteSqlNoTimeOut(String SQLString, Int32 times, SqlParameter[] cmdParms)
在 RB.DALExtendV2.RB_Procurement_Detail_SingleListExtendV2.BatchUpdateTrackingNumber(List`1 models)
在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.Procurement.ProcurementBuyList.BindTrackingNumber()
在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.Procurement.ProcurementBuyList.OnPreInit(EventArgs e)
在 System.Web.UI.Page.PerformPreInit()
在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest()
在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
在 System.Web.UI.Page.ProcessRequest(HttpContext context)
在 ASP.irobotbox_procurementv2_procurement_procurementbuylist_aspx.ProcessRequest(HttpContext context)
在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
[结果]
[期望]


销单页面更新追踪号方法,追踪号太长导致的,限制一下追踪号最大长度不要超过500
TrackingNumbers varchar 500 500 0 √ 多个快递单号逗号分隔