[步骤]
[00:11:58] -------------------------------------------------------------CODE:N001158712
Error:11_-2_0_-2146232060
SQL:
SELECT top 1000 * FROM (SELECT * FROM ( SELECT P.[ID],P.[SKU],P.[CustomerID],P.[Pack_Length],P.[Pack_Width],P.[Pack_Height],t2.goodnum,t1.ProcessingNum FROM(
SELECT [ID],[SKU],[CustomerID],[Pack_Length],[Pack_Width],[Pack_Height] FROM RB_Product G with(nolock) WHERE CustomerID = 1 AND ProductState != 2 AND IsGroup = 0 AND DeleteStatus = 0 AND ProductType IN (0) AND IsSeparateDefaultWarehouseSetting = 0
AND DefaultLocalWarehouse = 333
) AS P
INNER JOIN RB_Product_Admin PA WITH(nolock) ON P.CustomerID = PA.CustomerID AND P.SKU = PA.SKU AND PA.DevelopStatus IN (0,1,3)
Left JOIN
(
SELECT WP.SKU,
SUM(WP.GoodNum) goodnum
FROM RB_WareHouse_Product WP (NOLOCK)
INNER JOIN RB_WareHouse W (NOLOCK)
ON WP.CustomerID = W.CustomerID
AND WP.WareHouseID = W.ID
AND W.WareHouseType = 1 GROUP BY WP.SKU) t2 ON P.SKU = t2.SKU
left JOIN (SELECT SKU,ProcessingNum FROM (select SKU,ActualBuySpareNum as ProcessingNum from RB_Procurement_Detail b (NOLOCK) where ID < 0) tt1 ) t1 ON P.SKU = t1.SKU
JOIN dbo.RB_Product_SupplierPrice psp with(nolock)
ON p.SKU=psp.SKU AND psp.CustomerID=1 AND psp.isDefault=1
JOIN dbo.RB_Product_Supplier ps with(nolock)
ON psp.SupplierID=ps.ID AND ps.CustomerID=1 AND ps.TheWareHouseID IN (5312,1100000)
) AS TempTable ) AS PagerTable WHERE ( Isnull(goodnum,0) = 0 ) and PagerTable.ID > 1 order by PagerTable.ID
PARAMS:
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.SqlDataReader.TrySetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DALExtendV2.Generate.Product.RB_ProductExtendV2.GetProductListByParamB(Int32 customerID, CM_AssignWarehousePolicyParam param, Int32 pageIndex, Int32 pageSize)
在 Biz.product.DeliveryWarehousStrategyService.Execte(Int32 customerID, Nullable`1 ruleId)
在 Biz.product.DeliveryWarehousStrategyService.<DeliveryWarehousStrategyExecuting>b__1_1(Int32 c)
在 System.Collections.Generic.List`1.ForEach(Action`1 action)
在 Biz.product.DeliveryWarehousStrategyService.DeliveryWarehousStrategyExecuting()
在 ChinaDownLoadImage.Task.Product.Task_DeliveryWarehousStrategyExecuting.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()
-------------------------------------------------------------
[00:27:08] -------------------------------------------------------------
CODE:N002708713
Error:11_-2_0_-2146232060
SQL:
SELECT top 1000 * FROM (SELECT * FROM ( SELECT P.[ID],P.[SKU],P.[CustomerID],P.[Pack_Length],P.[Pack_Width],P.[Pack_Height],t2.goodnum,t1.ProcessingNum FROM(
SELECT [ID],[SKU],[CustomerID],[Pack_Length],[Pack_Width],[Pack_Height] FROM RB_Product G with(nolock) WHERE CustomerID = 1 AND ProductState != 2 AND IsGroup = 0 AND DeleteStatus = 0 AND ProductType IN (0) AND IsSeparateDefaultWarehouseSetting = 0
AND DefaultLocalWarehouse = 333
) AS P
INNER JOIN RB_Product_Admin PA WITH(nolock) ON P.CustomerID = PA.CustomerID AND P.SKU = PA.SKU AND PA.DevelopStatus IN (0,1,3)
Left JOIN
(
SELECT WP.SKU,
SUM(WP.GoodNum) goodnum
FROM RB_WareHouse_Product WP (NOLOCK)
INNER JOIN RB_WareHouse W (NOLOCK)
ON WP.CustomerID = W.CustomerID
AND WP.WareHouseID = W.ID
AND W.WareHouseType = 1 GROUP BY WP.SKU) t2 ON P.SKU = t2.SKU
left JOIN (SELECT SKU,ProcessingNum FROM (select SKU,ActualBuySpareNum as ProcessingNum from RB_Procurement_Detail b (NOLOCK) where ID < 0) tt1 ) t1 ON P.SKU = t1.SKU
JOIN dbo.RB_Product_SupplierPrice psp with(nolock)
ON p.SKU=psp.SKU AND psp.CustomerID=1 AND psp.isDefault=1
JOIN dbo.RB_Product_Supplier ps with(nolock)
ON psp.SupplierID=ps.ID AND ps.CustomerID=1 AND ps.TheWareHouseID IN (5312,1100000)
) AS TempTable ) AS PagerTable WHERE ( Isnull(goodnum,0) = 0 ) and PagerTable.ID > 1 order by PagerTable.ID
PARAMS:
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.SqlDataReader.TrySetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DALExtendV2.Generate.Product.RB_ProductExtendV2.GetProductListByParamB(Int32 customerID, CM_AssignWarehousePolicyParam param, Int32 pageIndex, Int32 pageSize)
在 Biz.product.DeliveryWarehousStrategyService.Execte(Int32 customerID, Nullable`1 ruleId)
在 Biz.product.DeliveryWarehousStrategyService.<DeliveryWarehousStrategyExecuting>b__1_1(Int32 c)
在 System.Collections.Generic.List`1.ForEach(Action`1 action)
在 Biz.product.DeliveryWarehousStrategyService.DeliveryWarehousStrategyExecuting()
在 ChinaDownLoadImage.Task.Product.Task_DeliveryWarehousStrategyExecuting.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()
[结果]
[期望]
修复bug 提升效率 减少资源消耗。