深圳智汇创想科技有限公司

prometheus告警

            开始时间: 04:01:27 

            错误代码: N040127115  

            sql类型: UPDATE   

            sql: [04:01:27]  -------------------------------------------------------------

CODE:N040127115

Error:16_8152_30_-2146232060

SQL:UPDATE RB_AmazonUploadProduct_V2

SET

Status=@Status,

UpdateTime=getdate(),

ErrRetryRemarks=isnull(ErrRetryRemarks,'')+'【重试标识_属性缺陷_230725_04_01】',

ErrRetryTime=getdate()

where QueueID in ( SELECT CONVERT(INT, item) FROM Charsplitforin(@QueueIDs, ',') )

And [CustomerID] = @CustomerID

PARAMS:@CustomerID = 1 ,@QueueIDs = 794628848,794625431,794630730,794628044,794629986,794630274,794632055,794632315,794626792,794627681,794629561,794622824,794625177,794630287,794622877,794624370,794630192,794629810,794633381,794633474,794633932,794635325,794635683,794635466,794637313,794633733,794632289,794626781,794627486,794630756,794640426,794636228,794638049,794639687,794637468,794634871,794640183,794640990,794635397,794641557,794642236,794641572,794634511,794633242,794635453,794637543,794640045,794643182,794626945,794632782,794634211,794641064,794638962,794646243,794646014,794643067,794643415,794643940,794647368,794643577,794643952,794644428,794644705,794645116,794645442,794644508,794650892,794643173,794646907,794648107,794649576,794618143,794646374,794620739,794651526,794649207,794650298,794655923,794655119,794651145,794655700,794658757,794660736,794623151,794625479,794627848,794666113,794601064,794663488,794667923,794625102,794626345,794626947,794663324,794664258,794664799,794668391,794669091,794669863,794663496,794663882,794664167,794665223,794665646,794666015,794666218,794667100,794669350,794669763,794671813,794670235,794672062,794672435,794671605,794664208,794674352,794674515,794670680,794671838,794644384,794647238,794656810,794661279,794662805,794664568,794667207,794669005,794670298,794675045,794675180,794675263,794675439,794675339,794675419,794657874,794675673,794676155,794673727,794677254,794676360,794669357,794604804,794679562,794681382,794681548,794679475,794679069,794674422,794676042,794676157,794676418,794678146,794682261,794683762,794683889,794681626,794683690,794679849,794685576,794685337,794685795,794685208,794691610,794693059,794677028,794679880,794688228 ,@Status = 0 ,

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.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.DALExtend.RB_AmazonUploadProduct_V2Extend.BatchUploadProductV2StatusByQueueIDsWithSign(Int32 customerID, Int32 status, List1 queueIDs, String descStr)

在 Biz.Irobotbox.Amazon.Amazon_RetryErrorUpload.UploadRetryOnlyStatusByErrorCode(DateTime starTime, DateTime endTime, String errorCode, String retryDescStr)

在 ChinaDownLoadImage.Task.Amazon.Task_Amazon_AmazonRetryByErrorCode.Execute()

在 System.Threading.Tasks.Task.Execute()

在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)

在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)

在 System.Threading.ThreadPoolWorkQueue.Dispatch()

---