[步骤]
[结果]
-- 查询自动清库策略是否正常
SELECT
a.sku AS 系统SKU,
a.MarketId AS 平台编号,
a.OrderSourceId AS 渠道编号,
a.Sku AS 系统SKU,
a.SellerSku AS 渠道SKU,
a.ItemId AS 平台ID,
a.`Status` AS 执行状态,
a.FailureReason
-- COUNT( 1 ) AS '失败次数统计'
from cs_clearstock_aliexpress_queue a
WHERE
a.CustomerId = 1
and a.MarketId=57
-- AND `Status` = '2'
AND a.Time >'2023-01-01 00:00:00'
AND a.Time <'2023-02-07 00:00:00'
问题
1、1月28日之后没有执行成功的数据
2、队列中出现重复记录，一天产生多次
报错信息：
清库促销加入活动失败，失败原因：{"data":{"is_success":false,"target":null,"time_stamp":null,"code":null,"msg":null,"sub_code":null,"sub_msg":null,"Body":"{"error_response":{"type":"ISP","request_id":"2102ff6f16738338097306148"}}","error_code":null,"error_message":null,"result_success":true,"IsError":false},"status":"success","message":null}
[期望]
执行正常
帮忙问一下平台以下报错具体是原因，确定再指回我处理
清库促销加入活动失败，失败原因：{"data":{"is_success":false,"target":null,"time_stamp":null,"code":null,"msg":null,"sub_code":null,"sub_msg":null,"Body":"{"error_response":{"type":"ISP","request_id":"212a6cab16765062846024785"}}","error_code":null,"error_message":null,"result_success":true,"IsError":false},"status":"success","message":null}