[前置条件]
系统正常
[重现步骤]
-- Shopeev2指定失败原因查询
SELECT
'shopeev2',
a.SiteCode,
a.Sku,
a.SellerSku,
a.OrderSourceId,
a.DelType,
d.OrderSourceName AS 来源渠道,
a.StrategyId AS 策略ID,
a.FailureReason,
COUNT( 1 ) AS '失败次数统计'
FROM
ap_autopublish_shopeev2_queue a
INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId
WHERE
a.CustomerId = 1
and a.MarketId=97
AND `Status` = 'failure'
AND a.Time >'2024-01-22 00:00:00'
AND a.Time <'2024-01-26 00:00:00'
AND a.FailureReason LIKE'%Something went wrong;please try it again%'
GROUP BY a.OrderSourceId

[重现规律]
偶现
[实际结果]
以上报错占比97%,需要确认问题原因
[期望结果]
不报错,刊登成功
1.业务后端修改发货天数,没有通知net这边对应修改