重现步骤
反馈人：袁慧斌
严重级别：严重
所属项目：hwy-zh-gz-lfw-datax
问题原因：同步工作流数据，造成阻塞
select [ID],[CustomerID],[SettlementDate],[OrderSourceTypeName],[OrderSourceID],[OrderSourceName],[ClientOrderCode],[OrderCode],[TransactionId],[PayTime],[ShipTime],[OrderSourceContry],[WareHouseID],[WareHouseName],[TransportID],[TransportName],[TrackNumbers],[TotalPrice],[ExchangeRMB],[USD_ExchangeRMB],[Currency],[OperatorName],[SKU],[ClientSKU],[SellerSKU],[OrderItemId],[ProductSalesPrice],[ProductShipPrice],[ProductNameCN],[ProductGrossWeight],[LastSupplierPrice],[ProductNum],[ProdutNumUpdate],[GroupSKU],[GroupProductNum],[AssignDevelopAdminName],[DevelopAdminName],[EditAdminName],[ImageAdminName],[BusinessAdminID],[BusinessAdminName],[BuyerName],[CheckAdminName],[BusinessTeamID],[BusinessTeamName],[Profits],[Incomes],[Expenses],[SalesPrice],[TransportPay],[SalesRefunds],[PromotionRebates],[OtherCredits],[CommisionFee],[FBATransactionFees],[OrderSourceOtherDebits],[BuyPrice],[PackageFees],[OverSeasShipFees],[FirstLegFees],[TariffFees],[ExchangeLost],[ProductReturnsFee],[AddTime],[OrderSourceType],[PackagedCost],[OrderAddedTime],[OrderStatus],[OrderState],[SalesAdminID],[SalesAdminName],[SalesTeamID],[SalesTeamName],[ConfirmTime],[PayDate],[SettlementShortDate],[DevIDSellerId],[SellerUserID],[PaypalAccount],[CostOfAdvertising],[IsBiSycnComplete],[BiSycnCompleteTime],[ShipDate],[UpdateTime],[OrderListID],[SalesVatFee],[SubsidyPrice],[DistributionPrice],[ASINorItemID],[ProductGroupSKU],[AddOrderReasonType],[WareHouseManagementPrice],[CustomFeeOtherCostPrice],[TaxRefundFee],[Tax],[MarketplaceFacilitatorTax],[ImportFee],[PromotionType],[CostOfStorageFee],[RelationID] from dbo.RB_Report_OrderSettlement where (CustomerID=1 and UpdateTime= replace(DATEADD(HOUR, -24,'2025-07-20 20:00:24'),'%',' ') AND OrderSourceType=45)
解决方案：添加 nolock('2025-07-20>
历史记录  
  1. 2025-07-21 09:41:47, 由 陈莉珍 创建。
  2. 2025-07-21 11:48:01, 由 唐飞飞 指派给 谭颖。
    修改了 指派给，旧值为 "tangfeifei"，新值为 "tanying"。
    你看下这个是什么功能，我这边没有弄过这张表
  3. 2025-07-21 13:51:42, 由 谭颖 指派给 任芳涛。
    修改了 指派给，旧值为 "tanying"，新值为 "renfangtao"。



  4. 2025-07-21 13:55:48, 由 任芳涛 指派给 陈莉珍。
    修改了 指派给，旧值为 "renfangtao"，新值为 "chenlizhen"。

    datax同步任务，同步订单数据，目前已切换到新的任务，该任务关闭即可。

  5. 2025-07-21 13:59:08, 由 陈莉珍 解决，方案为 配置问题 。
    修改了 解决方案，旧值为 ""，新值为 "deploy"。
    修改了 解决日期，旧值为 ""，新值为 "2025-07-21 13:59:01"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "chenlizhen"。
  6. 2025-07-21 14:00:12, 由 陈莉珍 编辑。
    修改了 所属模块 ，旧值为 "0"，新值为 "1872"。
    修改了 业务部门 ，旧值为 "0"，新值为 "2"。
    修改了 开发责任人，旧值为 ""，新值为 "renfangtao"。
    修改了 测试责任人，旧值为 ""，新值为 "renfangtao"。
    修改了 解决时效 ，旧值为 "0"，新值为 "4.29"。
    修改了 重现步骤 ，区别为：
    001- 反馈人：袁慧斌
    001+ 反馈人：袁慧斌 严重级别：严重 所属项目：hwy-zh-gz-lfw-datax 问题原因：同步工作流数据，造成阻塞 select [ID],[CustomerID],[SettlementDate],[OrderSourceTypeName],[OrderSourceID],[OrderSourceName],[ClientOrderCode],[OrderCode],[TransactionId],[PayTime],[ShipTime],[OrderSourceContry],[WareHouseID],[WareHouseName],[TransportID],[TransportName],[TrackNumbers],[TotalPrice],[ExchangeRMB],[USD_ExchangeRMB],[Currency],[OperatorName],[SKU],[ClientSKU],[SellerSKU],[OrderItemId],[ProductSalesPrice],[ProductShipPrice],[ProductNameCN],[ProductGrossWeight],[LastSupplierPrice],[ProductNum],[ProdutNumUpdate],[GroupSKU],[GroupProductNum],[AssignDevelopAdminName],[DevelopAdminName],[EditAdminName],[ImageAdminName],[BusinessAdminID],[BusinessAdminName],[BuyerName],[CheckAdminName],[BusinessTeamID],[BusinessTeamName],[Profits],[Incomes],[Expenses],[SalesPrice],[TransportPay],[SalesRefunds],[PromotionRebates],[OtherCredits],[CommisionFee],[FBATransactionFees],[OrderSourceOtherDebits],[BuyPrice],[PackageFees],[OverSeasShipFees],[FirstLegFees],[TariffFees],[ExchangeLost],[ProductReturnsFee],[AddTime],[OrderSourceType],[PackagedCost],[OrderAddedTime],[OrderStatus],[OrderState],[SalesAdminID],[SalesAdminName],[SalesTeamID],[SalesTeamName],[ConfirmTime],[PayDate],[SettlementShortDate],[DevIDSellerId],[SellerUserID],[PaypalAccount],[CostOfAdvertising],[IsBiSycnComplete],[BiSycnCompleteTime],[ShipDate],[UpdateTime],[OrderListID],[SalesVatFee],[SubsidyPrice],[DistributionPrice],[ASINorItemID],[ProductGroupSKU],[AddOrderReasonType],[WareHouseManagementPrice],[CustomFeeOtherCostPrice],[TaxRefundFee],[Tax],[MarketplaceFacilitatorTax],[ImportFee],[PromotionType],[CostOfStorageFee],[RelationID] from dbo.RB_Report_OrderSettlement where (CustomerID=1 and UpdateTime= replace(DATEADD(HOUR, -24,'2025-07-20 20:00:24'),'%',' ') AND OrderSourceType=45) 解决方案：添加 nolock('2025-07-20>
    002- 严重级别：严重
    003- 所属项目：hwy-zh-gz-lfw-datax
    004- 问题原因：同步工作流数据，造成阻塞
    005- select [ID],[CustomerID],[SettlementDate],[OrderSourceTypeName],[OrderSourceID],[OrderSourceName],[ClientOrderCode],[OrderCode],[TransactionId],[PayTime],[ShipTime],[OrderSourceContry],[WareHouseID],[WareHouseName],[TransportID],[TransportName],[TrackNumbers],[TotalPrice],[ExchangeRMB],[USD_ExchangeRMB],[Currency],[OperatorName],[SKU],[ClientSKU],[SellerSKU],[OrderItemId],[ProductSalesPrice],[ProductShipPrice],[ProductNameCN],[ProductGrossWeight],[LastSupplierPrice],[ProductNum],[ProdutNumUpdate],[GroupSKU],[GroupProductNum],[AssignDevelopAdminName],[DevelopAdminName],[EditAdminName],[ImageAdminName],[BusinessAdminID],[BusinessAdminName],[BuyerName],[CheckAdminName],[BusinessTeamID],[BusinessTeamName],[Profits],[Incomes],[Expenses],[SalesPrice],[TransportPay],[SalesRefunds],[PromotionRebates],[OtherCredits],[CommisionFee],[FBATransactionFees],[OrderSourceOtherDebits],[BuyPrice],[PackageFees],[OverSeasShipFees],[FirstLegFees],[TariffFees],[ExchangeLost],[ProductReturnsFee],[AddTime],[OrderSourceType],[PackagedCost],[OrderAddedTime],[OrderStatus],[OrderState],[SalesAdminID],[SalesAdminName],[SalesTeamID],[SalesTeamName],[ConfirmTime],[PayDate],[SettlementShortDate],[DevIDSellerId],[SellerUserID],[PaypalAccount],[CostOfAdvertising],[IsBiSycnComplete],[BiSycnCompleteTime],[ShipDate],[UpdateTime],[OrderListID],[SalesVatFee],[SubsidyPrice],[DistributionPrice],[ASINorItemID],[ProductGroupSKU],[AddOrderReasonType],[WareHouseManagementPrice],[CustomFeeOtherCostPrice],[TaxRefundFee],[Tax],[MarketplaceFacilitatorTax],[ImportFee],[PromotionType],[CostOfStorageFee],[RelationID] from dbo.RB_Report_OrderSettlement where (CustomerID=1 and UpdateTime= replace(DATEADD(HOUR, -24,'2025-07-20 20:00:24'),'%',' ') AND OrderSourceType=45)
    006- 解决方案：添加 nolock
    001- 反馈人：袁慧斌<br />
    001+ 反馈人：袁慧斌<br /> 严重级别：严重<br /> 所属项目：hwy-zh-gz-lfw-datax<br /> 问题原因：同步工作流数据，造成阻塞<br /> select [ID],[CustomerID],[SettlementDate],[OrderSourceTypeName],[OrderSourceID],[OrderSourceName],[ClientOrderCode],[OrderCode],[TransactionId],[PayTime],[ShipTime],[OrderSourceContry],[WareHouseID],[WareHouseName],[TransportID],[TransportName],[TrackNumbers],[TotalPrice],[ExchangeRMB],[USD_ExchangeRMB],[Currency],[OperatorName],[SKU],[ClientSKU],[SellerSKU],[OrderItemId],[ProductSalesPrice],[ProductShipPrice],[ProductNameCN],[ProductGrossWeight],[LastSupplierPrice],[ProductNum],[ProdutNumUpdate],[GroupSKU],[GroupProductNum],[AssignDevelopAdminName],[DevelopAdminName],[EditAdminName],[ImageAdminName],[BusinessAdminID],[BusinessAdminName],[BuyerName],[CheckAdminName],[BusinessTeamID],[BusinessTeamName],[Profits],[Incomes],[Expenses],[SalesPrice],[TransportPay],[SalesRefunds],[PromotionRebates],[OtherCredits],[CommisionFee],[FBATransactionFees],[OrderSourceOtherDebits],[BuyPrice],[PackageFees],[OverSeasShipFees],[FirstLegFees],[TariffFees],[ExchangeLost],[ProductReturnsFee],[AddTime],[OrderSourceType],[PackagedCost],[OrderAddedTime],[OrderStatus],[OrderState],[SalesAdminID],[SalesAdminName],[SalesTeamID],[SalesTeamName],[ConfirmTime],[PayDate],[SettlementShortDate],[DevIDSellerId],[SellerUserID],[PaypalAccount],[CostOfAdvertising],[IsBiSycnComplete],[BiSycnCompleteTime],[ShipDate],[UpdateTime],[OrderListID],[SalesVatFee],[SubsidyPrice],[DistributionPrice],[ASINorItemID],[ProductGroupSKU],[AddOrderReasonType],[WareHouseManagementPrice],[CustomFeeOtherCostPrice],[TaxRefundFee],[Tax],[MarketplaceFacilitatorTax],[ImportFee],[PromotionType],[CostOfStorageFee],[RelationID] from dbo.RB_Report_OrderSettlement where (CustomerID=1 and UpdateTime= replace(DATEADD(HOUR, -24,'2025-07-20 20:00:24'),'%',' ') AND OrderSourceType=45)<br /> 解决方案：添加 nolock('2025-07-20&gt;
    002- 严重级别：严重<br />
    003- 所属项目：hwy-zh-gz-lfw-datax<br />
    004- 问题原因：同步工作流数据，造成阻塞<br />
    005- select [ID],[CustomerID],[SettlementDate],[OrderSourceTypeName],[OrderSourceID],[OrderSourceName],[ClientOrderCode],[OrderCode],[TransactionId],[PayTime],[ShipTime],[OrderSourceContry],[WareHouseID],[WareHouseName],[TransportID],[TransportName],[TrackNumbers],[TotalPrice],[ExchangeRMB],[USD_ExchangeRMB],[Currency],[OperatorName],[SKU],[ClientSKU],[SellerSKU],[OrderItemId],[ProductSalesPrice],[ProductShipPrice],[ProductNameCN],[ProductGrossWeight],[LastSupplierPrice],[ProductNum],[ProdutNumUpdate],[GroupSKU],[GroupProductNum],[AssignDevelopAdminName],[DevelopAdminName],[EditAdminName],[ImageAdminName],[BusinessAdminID],[BusinessAdminName],[BuyerName],[CheckAdminName],[BusinessTeamID],[BusinessTeamName],[Profits],[Incomes],[Expenses],[SalesPrice],[TransportPay],[SalesRefunds],[PromotionRebates],[OtherCredits],[CommisionFee],[FBATransactionFees],[OrderSourceOtherDebits],[BuyPrice],[PackageFees],[OverSeasShipFees],[FirstLegFees],[TariffFees],[ExchangeLost],[ProductReturnsFee],[AddTime],[OrderSourceType],[PackagedCost],[OrderAddedTime],[OrderStatus],[OrderState],[SalesAdminID],[SalesAdminName],[SalesTeamID],[SalesTeamName],[ConfirmTime],[PayDate],[SettlementShortDate],[DevIDSellerId],[SellerUserID],[PaypalAccount],[CostOfAdvertising],[IsBiSycnComplete],[BiSycnCompleteTime],[ShipDate],[UpdateTime],[OrderListID],[SalesVatFee],[SubsidyPrice],[DistributionPrice],[ASINorItemID],[ProductGroupSKU],[AddOrderReasonType],[WareHouseManagementPrice],[CustomFeeOtherCostPrice],[TaxRefundFee],[Tax],[MarketplaceFacilitatorTax],[ImportFee],[PromotionType],[CostOfStorageFee],[RelationID] from dbo.RB_Report_OrderSettlement where (CustomerID=1 and UpdateTime<replace('2025-07-20 21:00:23','%','="" ')="" and="" updatetime="">= replace(DATEADD(HOUR, -24,'2025-07-20 20:00:24'),'%',' ') AND OrderSourceType=45)<br />
    006- 解决方案：添加 nolock</replace('2025-07-20>
  7. 2025-07-21 14:00:15, 由 陈莉珍 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "chenlizhen"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "chenlizhen"。
    修改了 关闭日期，旧值为 ""，新值为 "2025-07-21 14:00:15"。
返回
所属项目 技术中心-需求池
所属模块 多平台   walmart
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P2
Bug状态 已关闭
业务部门 总经办
影响功能
开发责任人 任芳涛
测试责任人 任芳涛
解决时效 4.29
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-07-21 14:00:15
截止日期 0000-00-00
上线时间 2025-07-21 13:55:00
上线时效 4.22
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 陈莉珍 于 2025-07-21 09:41:47
影响环境 生产环境-业务反馈
由谁解决 陈莉珍 于 2025-07-21 13:59:01
解决版本
解决方案 配置问题
由谁关闭 陈莉珍 于 2025-07-21 14:00:15
最后修改 陈莉珍 于 2025-07-21 14:00:15
相关Bug