[步骤]

[16:30:51]  -------------------------------------------------------------
CODE:N16305115
Error:21_596_1_-2146232060
SQL:UPDATE w
            SET    w.LockNum = tmp.OrderLockNum
            FROM   RB_WareHouse_Product w
                   INNER JOIN (SELECT whp.ID,
                                      whp.LockNum,
                                      Isnull((SELECT Sum(ol.LockNum)
                                              FROM   RB_OrderInfo oi (nolock)
                                                     LEFT JOIN RB_OrderInfo_BeikuExpand oibe (nolock) 
                                                       ON oibe.CustomerID = oi.CustomerID 
                                                          AND oibe.OrderCode = oi.OrderCode
                                                     LEFT JOIN RB_OrderList ol (nolock)
                                                       ON oi.CustomerID = ol.CustomerID
                                                          AND oi.OrderCode = ol.OrderCode
                                                     LEFT JOIN RB_WareHouse wh (nolock)
                                                       ON oi.WareHouseID = wh.ID
                                                           AND oi.CustomerID = wh.CustomerID 
                                              WHERE  oi.CustomerID = whp.CustomerID
                                                     AND oi.WareHouseID = whp.WareHouseID
                                                     AND ol.SKU = whp.SKU
                                                     AND Isnull(ol.SKU, '') <> ''
                                                     AND ol.LockNum > 0
                                                     AND oi.OrderState = 0
                                                     AND ISNULL(oibe.OrderProductType,0) NOT IN (2,3) 
                                                     --AND Isnull(wh.IsUseGroupSKU, 0) = 0
                                                ), 0) OrderLockNum
                               FROM   RB_WareHouse_Product whp (nolock)
                               WHERE  whp.CustomerID = @CustomerID
                                      AND whp.WareHouseID = @WareHouseID
                                      AND whp.LockNum <> 0
                                      AND Isnull(whp.SKU, '') <> '') tmp
                     ON w.ID = tmp.ID
            WHERE  w.CustomerID = @CustomerID
                   AND tmp.LockNum <> tmp.OrderLockNum 
PARAMS:@CustomerID = 1 ,@WareHouseID = 15429 ,
MESSAGE:Cannot continue the execution because the session is in the kill state.
当前命令发生了严重错误。应放弃任何可能产生的结果。
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.DALExtendV2.Generate.Warehouse.RB_WareHouse_ProductExtendV2.UpdateErrLockStockByWareHouseID(UpdateErrLockStockByWareHouseID_PSParameters param)
   在 OverseaManage.OverseaHelp.AsyncStockHelp.SyncEveryStockHelp(WareHouseStockInfo wareHouseStockParam, Boolean isUpdateStock)
   在 OverseaManage.Allegro.AllegroStock.ExecSyncAllegroAvaliabelStockTask(CM_GetAllegroWarehouseResult warehouseModel)
   在 OverseaManage.Allegro.AllegroStock.<>c__DisplayClass2_0.<SyncAllegroAvaliabelStock>b__5(CM_GetAllegroWarehouseResult aw)
   在 System.Collections.Generic.List`1.ForEach(Action`1 action)
   在 ChinaDownLoadImage.Task.Allegro.Task_SyncAllegroAvaliableStockServices.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 优化 ，建议先把结果 返回 然后根据条件 依次更新