[步骤]
SELECT
'allegro',
a.SiteCode,
a.Sku,
a.SellerSku,
a.OrderSourceId,
a.DelType,
d.OrderSourceName AS 来源渠道,
a.FailureReason
FROM
ap_autopublish_allegro_queue a
INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId
WHERE
a.CustomerId = 1
and a.MarketId=67
AND `Status` = 'failure'
AND a.Time >'2023-07-13 00:00:00'
AND a.Time <'2023-07-14 00:00:00'
AND a.FailureReason LIKE'%渠道%'
[结果]
DelType 为null，这个错误，应该标记为1[期望]
标记为1003-SELECT 'allegro', a.SiteCode, a.Sku, a.SellerSku, a.OrderSourceId, a.DelType, d.OrderSourceName AS 来源渠道, a.FailureReason FROM ap_autopublish_allegro_queue a INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceIdWHERE a.CustomerId = 1 and a.MarketId=67AND `Status` = 'failure'AND a.Time >'2023-07-13 00:00:00'AND a.Time <'2023-07-14 00:00:00' AND a.FailureReason LIKE'%渠道%'
003+ SELECT 'allegro', a.SiteCode, a.Sku, a.SellerSku, a.OrderSourceId, a.DelType, d.OrderSourceName AS 来源渠道, a.FailureReason FROM ap_autopublish_allegro_queue a INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceIdWHERE a.CustomerId = 1 and a.MarketId=67AND `Status` = 'failure'AND a.Time >'2023-07-13 00:00:00'AND a.Time <'2023-07-14 00:00:00' AND a.FailureReason LIKE'%渠道%'
003-<p>SELECT<br /><span> </span>'allegro',<br /> a.SiteCode,<br /><span> </span>a.Sku,<br /><span> </span>a.SellerSku,<br /><span> </span>a.OrderSourceId,<br /><span> </span>a.DelType,<br /><span> </span>d.OrderSourceName AS 来源渠道,<br /> a.FailureReason<br /><span> </span>FROM<br /> ap_autopublish_allegro_queue a<br /><span> </span>INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId<br />WHERE<br /> a.CustomerId = 1<br /> and a.MarketId=67<br />AND `Status` = 'failure'<br />AND a.Time >'2023-07-13 00:00:00'<br />AND a.Time <'2023-07-14 00:00:00'<br /><span> </span> AND a.FailureReason LIKE'%渠道%'<br /></p>
003+ <p>SELECT<br /><span> </span>'allegro',<br /> a.SiteCode,<br /><span> </span>a.Sku,<br /><span> </span>a.SellerSku,<br /><span> </span>a.OrderSourceId,<br /><span> </span>a.DelType,<br /><span> </span>d.OrderSourceName AS 来源渠道,<br /> a.FailureReason<br /><span> </span>FROM<br /> ap_autopublish_allegro_queue a<br /><span> </span>INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId<br />WHERE<br /> a.CustomerId = 1<br /> and a.MarketId=67<br />AND `Status` = 'failure'<br />AND a.Time >'2023-07-13 00:00:00'<br />AND a.Time <'2023-07-14 00:00:00'<br /><span> </span> AND a.FailureReason LIKE'%渠道%'</p>
SELECT
'allegro',
a.SiteCode,
a.Sku,
a.SellerSku,
a.OrderSourceId,
a.DelType,
d.OrderSourceName AS 来源渠道,
a.FailureReason
FROM
ap_autopublish_allegro_queue a
INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId
WHERE
a.CustomerId = 1
and a.MarketId=67
AND `Status` = 'failure'
AND a.Time >'2023-07-13 00:00:00'
AND a.Time <'2023-07-14 00:00:00'
AND a.FailureReason LIKE'%Invalid image address.%'
| 由谁创建 | 李乐同 于 2023-07-14 14:18:48 |
|---|---|
| 影响环境 |
702 |
| 由谁解决 | 韦思成 于 2023-07-17 16:23:26 |
| 解决版本 | 主干 |
| 解决方案 | 重复BUG #39008:【生产环境】shopee平台自动刊登队列需要重跑的数据没有打上标识 |
| 由谁关闭 | 李乐同 于 2023-07-19 14:19:02 |
| 最后修改 | 刘超 于 2023-11-17 09:45:52 |
| 相关Bug |
|---|
'allegro',
a.SiteCode,
a.Sku,
a.SellerSku,
a.OrderSourceId,
a.DelType,
d.OrderSourceName AS 来源渠道,
a.FailureReason
FROM
ap_autopublish_allegro_queue a
INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId
WHERE
a.CustomerId = 1
and a.MarketId=67
AND `Status` = 'failure'
AND a.Time >'2023-07-13 00:00:00'
AND a.Time <'2023-07-14 00:00:00'
AND a.FailureReason LIKE'%ProductValidationException;productSet[0].product;Product needs to have at least one image%'