[步骤]
[04:02:52] -------------------------------------------------------------
CODE:N04025213
Error:11_-2_0_-2146232060
SQL:UPDATE a
SET a.FirstLegShippingType = @FirstLegShippingType,
UpdateTime = @UpdateTime
FROM RB_Product_OrderSourceSKU (NOLOCK) a
INNER JOIN @OrderSourceSKU ordersku
ON a.OrderSourceSKU = ordersku.Id
WHERE CustomerID = @CustomerID
AND a.OrderSourceID = @OrderSourceID;
PARAMS:@CustomerID = 1 ,@OrderSourceSKU = 8NZ16T33HO59IGN, ,@OrderSourceID = 19247 ,@FirstLegShippingType = 1 ,@UpdateTime = 2024/8/22 4:02:22 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
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.DALExtendV3.Generate.Product.RB_Product_OrderSourceSKUExtendV3.BatchUpdateProductOrderSourceSKUFirstLegShippingType(Int32 customerId, Int32 orderSourceID, List`1 osSkuList, Int32 firstLegShippingType, DateTime updateTime)
在 Biz.Amazon.FBA.AmazonFbaHeaderTransportMapService.<>c__DisplayClass4_30.<FbaHeaderTransportYearSaleMappingExecute>b__132()
在 Biz.Amazon.FBA.AmazonFbaHeaderTransportMapService.ExcuteWithRetry(Action action, Int32 retryCount)
在 Biz.Amazon.FBA.AmazonFbaHeaderTransportMapService.FbaHeaderTransportYearSaleMappingExecute(FbaHeaderTransportMapping model)
在 RB.Utility.TaskSmartManager`1.execute(Func`2 execFunction)
在 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()
-------------------------------------------------------------
[04:03:06] -------------------------------------------------------------
CODE:N04030614
Error:11_-2_0_-2146232060
SQL:UPDATE a
SET a.FirstLegShippingType = @FirstLegShippingType,
UpdateTime = @UpdateTime
FROM RB_Product_OrderSourceSKU (NOLOCK) a
INNER JOIN @OrderSourceSKU ordersku
ON a.OrderSourceSKU = ordersku.Id
WHERE CustomerID = @CustomerID
AND a.OrderSourceID = @OrderSourceID;
PARAMS:@CustomerID = 1 ,@OrderSourceSKU = HSV215611NU,EV56FBM12015AA9WY, ,@OrderSourceID = 19237 ,@FirstLegShippingType = 1 ,@UpdateTime = 2024/8/22 4:02:36 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
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.DALExtendV3.Generate.Product.RB_Product_OrderSourceSKUExtendV3.BatchUpdateProductOrderSourceSKUFirstLegShippingType(Int32 customerId, Int32 orderSourceID, List`1 osSkuList, Int32 firstLegShippingType, DateTime updateTime)
在 Biz.Amazon.FBA.AmazonFbaHeaderTransportMapService.<>c__DisplayClass4_30.<FbaHeaderTransportYearSaleMappingExecute>b__132()
在 Biz.Amazon.FBA.AmazonFbaHeaderTransportMapService.ExcuteWithRetry(Action action, Int32 retryCount)
在 Biz.Amazon.FBA.AmazonFbaHeaderTransportMapService.FbaHeaderTransportYearSaleMappingExecute(FbaHeaderTransportMapping model)
在 RB.Utility.TaskSmartManager`1.execute(Func`2 execFunction)
在 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()
-------------------------------------------------------------
@OrderSourceSKU ordersku
ON a.OrderSourceSKU = ordersku.Id 的类型 和数据库类型不一致 nvarchar 应采用 Tb_NStringIds
[结果]
[期望]
保证一直的参数类型
