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

[步骤]

[00:05:10]  -------------------------------------------------------------
CODE:N0005101080
Error:16_8152_30_-2146232060
SQL:UPDATE RB_OrderInfo_FundReceipt
                                            SET    UpdateTime = Getdate(),
                                                   RefundTime = Getdate(),
                                                   RefundResult = @RefundResult
                                            WHERE  ID = @ID
                                                   AND CustomerID = @CustomerID 
PARAMS:@RefundResult = <br>错误信息:WCP - WCPRefundPurchaseOrderFailed for po: 309026388989112 with error: org.springframework.web.client.HttpClientErrorException$BadRequest: 400 Bad Request: "{"status":"BAD_REQUEST","error":[{"code":"400.11","description":"Requested discount amt is greater than available amount in charge summary. orderNumber: 600000035893156, lineId: 1, chargeSummaryAmtAvailable: 0.00, requestedAdjustment : 16.19","severity":"ERROR","category":"APPLICATION"}]}", url: http://pg-oms-update-order.prod-tg2.oms-phoenix.cp.prod.walmart.com/orders/v1.0/ordermanagement/order/600000035893156/adjust, header: [WM_CONSUMER.ID:"362c2148-de98-11ed-b5ea-0242ac120002", WM_CONSUMER.TENANT_ID:"1", WM_QOS.CORRELATION_ID:"Irobotbox", WM_SVC.ENV:"prod", tenant-id:"qxjed8", WM_SVC.NAME:"PG-OMS-UPDATE-ORDER", WM_SVC.VERSION:"1.0.0", X-Request-ID:"Irobotbox_2af01652-d4bd-4da1-a6fe-5d3c81109a0e", SEGMENT:"Irobotbox_2af01652-d4bd-4da1-a6fe-5d3c81109a0e", Content-Type:"application/json", Accept:"application/json", WM_SEC.AUTH_SIGNATURE:"fj5aX5/Cyus+KRejUi3liVli9AevvwcIs93jDqjrSlJY7hgo5EAqcpI4LCsri1KIa9dHrM8xaiuuVg9mPn8cZ8wwZGU79qUV9HarnUcbjfxypSnEKsJoUSZRFLIoKNzdoiWkHhy4V4NWFLFqIrpZ76tAVCtyOVrZG9efWC7PuFjYpTTOz7DIHeQivDzVetyGSWe8+VKCcapdUmICUBtK6Yidva0j6IVtDt6xjvcSGjXdXjV3LySvvHokWRvzljh3fvuqsSxgPSp4X/pKLRDbk0a0GJWw79ilv2ZIXScDLJk3bWmzj1s0zb4ijureCHh2uQkW+ElHSJnzNtLacpaKfw==", WM_SEC.KEY_VERSION:"1", WM_CONSUMER.INTIMESTAMP:"1760717109673"], totalTime: totalTime=203, ,@CustomerID = 1 ,@ID = 13004714 ,
MESSAGE:String or binary data would be truncated.
The statement has been terminated.
TRACE:   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 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_OrderInfo_FundReceiptExtend.UpdateRefundResultByID(Int32 customerID, Int32 fundReceiptID, String refundResult)
   在 Biz.Walmart.WalmartOrderRefund.RefundFailed(DALHelper hp, WalmartRefundOrder refundModel, String strResult, String errorMsg)
   在 Biz.Walmart.WalmartOrderRefund.<>c__DisplayClass2_1.<WalmartRefundExcute>b__2(WalmartRefundOrder refundModel)
   在 System.Collections.Generic.List`1.ForEach(Action`1 action)
   在 System.Collections.Generic.List`1.ForEach(Action`1 action)
   在 ChinaDownLoadImage.Task.Walmart.Task_Walmart_Refund.Execute()
   在 RB.Utility.SystemTask.<doTask>b__43_0()
   在 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()

[结果]

[期望]

修复 SQL