[步骤]
-- kogan 指定失败原因查询
SELECT
'kogan',
a.SiteCode,
a.Sku,
a.SellerSku,
a.OrderSourceId,
d.OrderSourceName AS 来源渠道,
a.`Status`,
a.FailureReason
FROM
ap_autopublish_kogan_queue a
INNER JOIN sys_ordersource AS d ON a.OrderSourceId = d.OrderSourceId
WHERE
a.CustomerId = 1
and a.MarketId=81
-- AND a.OrderSourceId=18356
-- AND `Status` = 'failure'
AND a.Time >'2023-04-06 00:00:00'
AND a.Time <'2023-04-13 00:00:00'
AND a.FailureReason LIKE'%Unable to process image with%'

[结果]
上传失败,报处理图片出现异常,无法处理图像
{"product_sku":"RI1J001410LGRIAYDB","errors":{"creation error":["Unable to process image with url: https://picture.irobotbox.com/Kogan-Z0202003-AU53Yij-赛盒_5477254013237292139/1/ProductImages/16318459/2023/3/1/9a01c690d6cc461ea58bff7fd9e4181c/144027d8-bcc1-8016-92cc-c9c2aa804506.jpg"]}}
[期望]
处理图片正常,上传成功