重现步骤
 CODE:N0910091
Error:11_-2_0_-2146232060
SQL:
                    SELECT pop.StockOrderNumber,
                           pbl.BoxNo,
                           pbli.SKU,
                           pop.ID,
                           wh.AccountNo,
                           wh.Password,
                           wh.WareHouseCode,
                           whp.OrderSourceSKU,
                           pbli.ProductNum,
                           wh.UserKey,
                           wh.Token,
                           ot.LevelName1,
                           ot.LevelValue1,
                           wh.WareHouseLinkName,
                           oi.IsFBABarCodes,
                           wh.IsUseOverseaPlatformApi,
                           wh.WareHouseType
                    FROM   RB_Procurement_Order_Package pop (NOLOCK)
                           INNER JOIN RB_OrderInfo oi (nolock)
                             ON pop.MergerPackageNo = oi.OrderCode
                                AND pop.CustomerID = oi.CustomerID
                           INNER JOIN RB_WareHouse wh (nolock)
                             ON oi.ToWareHouseID = wh.ID
                                AND oi.CustomerID = wh.CustomerID
                                AND wh.WareHouseType = @WareHouseType
                           LEFT JOIN RB_PackingBoxingList pbl (NOLOCK)
                             ON pbl.OrderPackageID = pop.ID
                                AND pbl.CustomerID = pop.CustomerID
                           LEFT JOIN RB_PackingBoxingList_Items pbli (NOLOCK)
                             ON pbl.ID = pbli.PackingBoxingID
                           LEFT JOIN rb_product pro (NOLOCK)
                             ON pbli.SKU = CASE
                                             WHEN pbli.SkuType = 1 THEN pro.SKU
                                             ELSE pro.ClientSKU
                                           END
                                AND pro.CustomerID = pbli.CustomerID
                           LEFT JOIN RB_WareHouse_Product whp (nolock)
                             ON oi.CustomerID = whp.CustomerID
                                AND oi.ToWareHouseID = whp.WareHouseID
                                AND PRO.SKU = whp.SKU
                           LEFT JOIN RB_Oversea_Transport ot (nolock)
                             ON oi.CustomerID = ot.CustomerID
                                AND oi.TransportID = ot.TransportID
                                AND ot.WareHouseType = @WareHouseType
                    WHERE  pop.CustomerID = @customerID
                           AND pop.StockOrderNumber = @StockOrderNumber
                           AND wh.WareHouseType = @WareHouseType
PARAMS:@StockOrderNumber = RVG1009-220926-0002 ,@customerID = 1 ,@WareHouseType = 13 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。


建议优化为：


declare @StockOrderNumber varchar(200)= 'RVG1009-220926-0002' ,@customerID int= 1 ,@WareHouseType int= 13
SELECT pop.StockOrderNumber,
                           pbl.BoxNo,
                           pbli.SKU,
                           pop.ID,
                           wh.AccountNo,
                           wh.Password,
                           wh.WareHouseCode,
                           whp.OrderSourceSKU,
                           pbli.ProductNum,
                           wh.UserKey,
                           wh.Token,
                           ot.LevelName1,
                           ot.LevelValue1,
                           wh.WareHouseLinkName,
                           oi.IsFBABarCodes,
                           wh.IsUseOverseaPlatformApi,
                           wh.WareHouseType
                    FROM   RB_Procurement_Order_Package pop (NOLOCK)
                           INNER JOIN RB_OrderInfo oi (nolock)
                             ON pop.MergerPackageNo = oi.OrderCode
                                AND pop.CustomerID = oi.CustomerID
                           INNER JOIN RB_WareHouse wh (nolock)
                             ON oi.ToWareHouseID = wh.ID
                                AND oi.CustomerID = wh.CustomerID
                                AND wh.WareHouseType = @WareHouseType
                           LEFT JOIN RB_PackingBoxingList pbl (NOLOCK)
                             ON pbl.OrderPackageID = pop.ID
                                AND pbl.CustomerID = pop.CustomerID
                           LEFT JOIN RB_PackingBoxingList_Items pbli (NOLOCK)
                             ON pbl.ID = pbli.PackingBoxingID                          
                           LEFT JOIN RB_WareHouse_Product whp (nolock)
                             ON oi.CustomerID = whp.CustomerID
                                AND oi.ToWareHouseID = whp.WareHouseID
                                AND pbli.SKU = whp.SKU
                           LEFT JOIN RB_Oversea_Transport ot with(nolock)
                             ON oi.CustomerID = ot.CustomerID
                                AND oi.TransportID = ot.TransportID
                                AND ot.WareHouseType = @WareHouseType
                    WHERE  pop.CustomerID = @customerID
                           AND pop.StockOrderNumber = @StockOrderNumber
                           AND wh.WareHouseType = @WareHouseType




历史记录  
  1. 2022-09-28 11:16:59, 由 吴高发 创建。
  2. 2022-09-28 15:37:46, 由 胡晓龙 指派给 程伟。
    修改了 指派给，旧值为 "huxiaolong"，新值为 "chengwei"。
  3. 2022-09-28 15:46:40, 由 程伟 指派给 鞠智明。
    修改了 指派给，旧值为 "chengwei"，新值为 "juzhiming"。
  4. 2022-09-28 18:21:53, 由 鞠智明 解决，方案为 性能问题 。
    修改了 解决方案，旧值为 ""，新值为 "performance"。
    修改了 解决版本，旧值为 ""，新值为 "trunk"。
    修改了 解决日期，旧值为 ""，新值为 "2022-09-28 16:53:46"。
    修改了 指派给 ，旧值为 "juzhiming"，新值为 "linhonggui"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "juzhiming"。

    开发报告

    1.这个类型判断关联容易出现超时，现在调整为，

    DECLARE @StockOrderNumber NVARCHAR(19) = 'RVG1009-220926-0002',
            @customerID INT = 1,
            @WareHouseType INT = 13;

    SELECT pop.StockOrderNumber,
           pbl.BoxNo,
           pbli.SKU,
           pop.ID,
           wh.AccountNo,
           wh.Password,
           wh.WareHouseCode,
           whp.OrderSourceSKU,
           pbli.ProductNum,
           wh.UserKey,
           wh.Token,
           ot.LevelName1,
           ot.LevelValue1,
           wh.WareHouseLinkName,
           oi.IsFBABarCodes,
           wh.IsUseOverseaPlatformApi,
           wh.WareHouseType
    FROM RB_Procurement_Order_Package pop WITH (NOLOCK)
        INNER JOIN RB_OrderInfo oi (NOLOCK)
            ON pop.MergerPackageNo = oi.OrderCode
               AND pop.CustomerID = oi.CustomerID
        INNER JOIN RB_WareHouse wh (NOLOCK)
            ON oi.ToWareHouseID = wh.ID
               AND oi.CustomerID = wh.CustomerID
               AND wh.WareHouseType = @WareHouseType
        LEFT JOIN RB_PackingBoxingList pbl (NOLOCK)
            ON pbl.OrderPackageID = pop.ID
               AND pbl.CustomerID = pop.CustomerID
        LEFT JOIN RB_PackingBoxingList_Items pbli (NOLOCK)
            ON pbl.ID = pbli.PackingBoxingID
        LEFT JOIN RB_Product pro (NOLOCK)
            ON pbli.SKU = pro.ClientSKU
               AND pro.CustomerID = pbli.CustomerID
        LEFT JOIN RB_WareHouse_Product whp (NOLOCK)
            ON oi.CustomerID = whp.CustomerID
               AND oi.ToWareHouseID = whp.WareHouseID
               AND pbli.SKU = whp.SKU
        LEFT JOIN RB_Oversea_Transport ot (NOLOCK)
            ON oi.CustomerID = ot.CustomerID
               AND oi.TransportID = ot.TransportID
               AND ot.WareHouseType = @WareHouseType
    WHERE pop.CustomerID = @customerID
          AND pop.StockOrderNumber = @StockOrderNumber
          AND wh.WareHouseType = @WareHouseType
    UNION
    SELECT pop.StockOrderNumber,
           pbl.BoxNo,
           pbli.SKU,
           pop.ID,
           wh.AccountNo,
           wh.Password,
           wh.WareHouseCode,
           whp.OrderSourceSKU,
           pbli.ProductNum,
           wh.UserKey,
           wh.Token,
           ot.LevelName1,
           ot.LevelValue1,
           wh.WareHouseLinkName,
           oi.IsFBABarCodes,
           wh.IsUseOverseaPlatformApi,
           wh.WareHouseType
    FROM RB_Procurement_Order_Package pop WITH (NOLOCK)
        INNER JOIN RB_OrderInfo oi (NOLOCK)
            ON pop.MergerPackageNo = oi.OrderCode
               AND pop.CustomerID = oi.CustomerID
        INNER JOIN RB_WareHouse wh (NOLOCK)
            ON oi.ToWareHouseID = wh.ID
               AND oi.CustomerID = wh.CustomerID
               AND wh.WareHouseType = @WareHouseType
        LEFT JOIN RB_PackingBoxingList pbl (NOLOCK)
            ON pbl.OrderPackageID = pop.ID
               AND pbl.CustomerID = pop.CustomerID
        LEFT JOIN RB_PackingBoxingList_Items pbli (NOLOCK)
            ON pbl.ID = pbli.PackingBoxingID
        LEFT JOIN RB_Product pro (NOLOCK)
            ON pbli.SKU = pro.SKU
               AND pro.CustomerID = pbli.CustomerID
        LEFT JOIN RB_WareHouse_Product whp (NOLOCK)
            ON oi.CustomerID = whp.CustomerID
               AND oi.ToWareHouseID = whp.WareHouseID
               AND pbli.SKU = whp.SKU
        LEFT JOIN RB_Oversea_Transport ot (NOLOCK)
            ON oi.CustomerID = ot.CustomerID
               AND oi.TransportID = ot.TransportID
               AND ot.WareHouseType = @WareHouseType
    WHERE pop.CustomerID = @customerID
          AND pop.StockOrderNumber = @StockOrderNumber
          AND wh.WareHouseType = @WareHouseType;


  5. 2022-09-29 10:04:29, 由 林鸿贵 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "linhonggui"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "linhonggui"。
    修改了 关闭日期，旧值为 ""，新值为 "2022-09-29 10:04:29"。

    已上线发布

    线上验证通过

  6. 2023-11-17 09:53:28, 由 刘超 编辑。
    修改了 所属模块，旧值为 "0"，新值为 "1863"。
所属项目 技术中心-需求池
所属模块 系统运维   性能优化
所属计划
所属迭代
Bug类型 性能问题
严重程度 提示
优先级 P2
Bug状态 已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2022-09-29 10:04:29
截止日期 0000-00-00
上线时间
上线时效
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 吴高发 于 2022-09-28 11:16:59
影响环境 577
由谁解决 鞠智明 于 2022-09-28 16:53:46
解决版本 主干
解决方案 性能问题
由谁关闭 林鸿贵 于 2022-09-29 10:04:29
最后修改 刘超 于 2023-11-17 09:53:23
相关Bug