001-
001+ 反馈人：erp运维监控
002- 反馈人：erp运维监控
002+ ERP站点慢sql, 仓库频繁反馈卡顿超时小黄鸡: [10:22:14] -------------------------------------------------------------
003-
003+ CODE:N10221413
004-
004+ Error:11_-2_0_-2146232060 SQL: SELECT pos.CustomerID,pos.WareHouseID,wpa.WareHouseAreaID AS AreaID,ISNULL(SUM(CASE WHEN pos.StockReduceNum > 0 THEN pos.StockReduceNum ELSE pos.PickingNum END),0) AS StatisticCount FROM RB_Package_OperateStock pos(NOLOCK) INNER JOIN RB_WareHousePostArea wpa(NOLOCK) ON pos.WareHouseID=wpa.WareHouseID AND pos.PositionID=wpa.PositionID AND pos.CustomerID=wpa.CustomerID INNER JOIN RB_Procurement_Order_Package pop WITH(NOLOCK) ON pop.ID = pos.PackageID AND pop.CustomerID = pos.CustomerID INNER JOIN RB_Package_Picking pp WITH(NOLOCK) ON pp.PrintBatchNo = pop.PrintBatchNo AND pp.CustomerID = pop.CustomerID WHERE pos.CustomerID=@CustomerID AND pos.WareHouseID=@WarehouseID AND pos.IsDelete=@IsDelete AND pos.PickingTime>=@StartTime AND pos.PickingTime<=@EndTime AND pos.StockReduceNum+pos.PickingNum>0 AND wpa.WareHouseAreaID in(315,327,329,330,456,458,465,467,468,469,470,534,542,554,556,572,573,574,575,576,577,578,579) AND pp.PickingType = @PickingType AND pp.PickingStatus IN(0,1) GROUP BY pos.CustomerID,pos.WareHouseID,wpa.WareHouseAreaID PARAMS:@CustomerID = 1 ,@WarehouseID = 5312 ,@StartTime = 2026/4/2 9:00:00 ,@EndTime = 2026/4/3 9:00:00 ,@IsDelete = False ,@PickingType = 1 , MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
005- ERP站点慢sql, 仓库频繁反馈卡顿超时小黄鸡: [10:22:14] -------------------------------------------------------------
006-
007- CODE:N10221413
008- Error:11_-2_0_-2146232060
009- SQL:
010- SELECT
011- pos.CustomerID,pos.WareHouseID,wpa.WareHouseAreaID AS AreaID,ISNULL(SUM(CASE WHEN pos.StockReduceNum > 0 THEN pos.StockReduceNum ELSE pos.PickingNum END),0) AS StatisticCount
012- FROM RB_Package_OperateStock pos(NOLOCK)
013- INNER JOIN RB_WareHousePostArea wpa(NOLOCK)
014- ON pos.WareHouseID=wpa.WareHouseID
015- AND pos.PositionID=wpa.PositionID
016- AND pos.CustomerID=wpa.CustomerID
017- INNER JOIN RB_Procurement_Order_Package pop WITH(NOLOCK)
018- ON pop.ID = pos.PackageID
019- AND pop.CustomerID = pos.CustomerID
020- INNER JOIN RB_Package_Picking pp WITH(NOLOCK)
021- ON pp.PrintBatchNo = pop.PrintBatchNo
022- AND pp.CustomerID = pop.CustomerID
023- WHERE pos.CustomerID=@CustomerID
024- AND pos.WareHouseID=@WarehouseID
025- AND pos.IsDelete=@IsDelete
026- AND pos.PickingTime>=@StartTime AND pos.PickingTime<=@EndTime
027- AND pos.StockReduceNum+pos.PickingNum>0
028- AND wpa.WareHouseAreaID in(315,327,329,330,456,458,465,467,468,469,470,534,542,554,556,572,573,574,575,576,577,578,579)
029- AND pp.PickingType = @PickingType AND pp.PickingStatus IN(0,1)
030- GROUP BY pos.CustomerID,pos.WareHouseID,wpa.WareHouseAreaID
031- PARAMS:@CustomerID = 1 ,@WarehouseID = 5312 ,@StartTime = 2026/4/2 9:00:00 ,@EndTime = 2026/4/3 9:00:00 ,@IsDelete = False ,@PickingType = 1 ,
032- MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。

001- <p>
001+ <p>反馈人：erp运维监控</p>
002- 反馈人：erp运维监控
002+ <p>ERP站点慢sql, 仓库频繁反馈卡顿超时小黄鸡: [10:22:14] -------------------------------------------------------------</p>
003- </p>
003+ CODE:N10221413<br />
004- <p>
004+ Error:11_-2_0_-2146232060<br /> SQL:<br /> SELECT <br /> pos.CustomerID,pos.WareHouseID,wpa.WareHouseAreaID AS AreaID,ISNULL(SUM(CASE WHEN pos.StockReduceNum &gt; 0 THEN pos.StockReduceNum ELSE pos.PickingNum END),0) AS StatisticCount <br /> FROM RB_Package_OperateStock pos(NOLOCK) <br /> INNER JOIN RB_WareHousePostArea wpa(NOLOCK) <br /> ON pos.WareHouseID=wpa.WareHouseID <br /> AND pos.PositionID=wpa.PositionID <br /> AND pos.CustomerID=wpa.CustomerID<br /> INNER JOIN RB_Procurement_Order_Package pop WITH(NOLOCK) <br /> ON pop.ID = pos.PackageID<br /> AND pop.CustomerID = pos.CustomerID<br /> INNER JOIN RB_Package_Picking pp WITH(NOLOCK) <br /> ON pp.PrintBatchNo = pop.PrintBatchNo<br /> AND pp.CustomerID = pop.CustomerID<br /> WHERE pos.CustomerID=@CustomerID <br /> AND pos.WareHouseID=@WarehouseID <br /> AND pos.IsDelete=@IsDelete<br /> AND pos.PickingTime&gt;=@StartTime AND pos.PickingTime&lt;=@EndTime<br /> AND pos.StockReduceNum+pos.PickingNum&gt;0 <br /> AND wpa.WareHouseAreaID in(315,327,329,330,456,458,465,467,468,469,470,534,542,554,556,572,573,574,575,576,577,578,579) <br /> AND pp.PickingType = @PickingType AND pp.PickingStatus IN(0,1)<br /> GROUP BY pos.CustomerID,pos.WareHouseID,wpa.WareHouseAreaID<br /> PARAMS:@CustomerID = 1 ,@WarehouseID = 5312 ,@StartTime = 2026/4/2 9:00:00 ,@EndTime = 2026/4/3 9:00:00 ,@IsDelete = False ,@PickingType = 1 ,<br /> MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
005- ERP站点慢sql, 仓库频繁反馈卡顿超时小黄鸡: [10:22:14] -------------------------------------------------------------
006- </p>
007- CODE:N10221413<br />
008- Error:11_-2_0_-2146232060<br />
009- SQL:<br />
010- SELECT <br />
011- pos.CustomerID,pos.WareHouseID,wpa.WareHouseAreaID AS AreaID,ISNULL(SUM(CASE WHEN pos.StockReduceNum &gt; 0 THEN pos.StockReduceNum ELSE pos.PickingNum END),0) AS StatisticCount <br />
012- FROM RB_Package_OperateStock pos(NOLOCK) <br />
013- INNER JOIN RB_WareHousePostArea wpa(NOLOCK) <br />
014- ON pos.WareHouseID=wpa.WareHouseID <br />
015- AND pos.PositionID=wpa.PositionID <br />
016- AND pos.CustomerID=wpa.CustomerID<br />
017- INNER JOIN RB_Procurement_Order_Package pop WITH(NOLOCK) <br />
018- ON pop.ID = pos.PackageID<br />
019- AND pop.CustomerID = pos.CustomerID<br />
020- INNER JOIN RB_Package_Picking pp WITH(NOLOCK) <br />
021- ON pp.PrintBatchNo = pop.PrintBatchNo<br />
022- AND pp.CustomerID = pop.CustomerID<br />
023- WHERE pos.CustomerID=@CustomerID <br />
024- AND pos.WareHouseID=@WarehouseID <br />
025- AND pos.IsDelete=@IsDelete<br />
026- AND pos.PickingTime&gt;=@StartTime AND pos.PickingTime&lt;=@EndTime<br />
027- AND pos.StockReduceNum+pos.PickingNum&gt;0 <br />
028- AND wpa.WareHouseAreaID in(315,327,329,330,456,458,465,467,468,469,470,534,542,554,556,572,573,574,575,576,577,578,579) <br />
029- AND pp.PickingType = @PickingType AND pp.PickingStatus IN(0,1)<br />
030- GROUP BY pos.CustomerID,pos.WareHouseID,wpa.WareHouseAreaID<br />
031- PARAMS:@CustomerID = 1 ,@WarehouseID = 5312 ,@StartTime = 2026/4/2 9:00:00 ,@EndTime = 2026/4/3 9:00:00 ,@IsDelete = False ,@PickingType = 1 ,<br />
032- MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。