武汉新宁运维文档

常见问题：

Q: 某个订单存在机器人未去搬箱子

A:

1. 根据任务号查询订单ID；

select * from ks_sale_order_header where task_no = '1740853-2955653';

查询到订单ID: 76562

2. 根据订单ID查询订单分配情况：

select * from ks_sale_order_detail_pre_allocated_record where ks_sale_order_header_id = 76562;
+-------+----------------------------+----------------------------+------------+------------------+-------------------+-------------+----------------+-------------+-----------+-------------------------+-------------------------+---------------+---------------------+-------------------+------------+----------+--------+---------------+
| id    | create_time                | update_time                | actual_qty | compartment_code | compartment_index | identify_id | identify_no    | ks_bin_code | ks_bin_id | ks_sale_order_detail_id | ks_sale_order_header_id | ks_sku_lot_id | pre_allocated_level | pre_allocated_qty | sku_code   | sku_name | status | serial_number |
+-------+----------------------------+----------------------------+------------+------------------+-------------------+-------------+----------------+-------------+-----------+-------------------------+-------------------------+---------------+---------------------+-------------------+------------+----------+--------+---------------+
| 94392 | 2020-12-03 22:05:03.623000 | 2020-12-03 22:05:03.625000 |       NULL | WHXNC02817       |                 1 |      478076 | LS250212539441 | WHXNC02817  |      8523 |                   84747 |                   76562 |         26608 |                   3 |             10000 | S938C09985 |          |      0 |         10000 |
+-------+----------------------------+----------------------------+------------+------------------+-------------------+-------------+----------------+-------------+-----------+-------------------------+-------------------------+---------------+---------------------+-------------------+------------+----------+--------+---------------+

备注：检查status是否为0，为0则拣选任务未被拣。

3. 查询箱子状态；

select * from ks_bin where id= 8523;

如果箱子状态status字段为7（在货架上异常）：则在“料箱查询”界面上点击“恢复料箱按钮”恢复料箱
如果箱子状态status字段为4（在库外） ：则需要：
1.调用swagger接口将料箱变成异常： http://172.20.8.102:20000/swagger-ui.html --> 05.货箱 --> 测试将箱子变成异常，然后输入料箱编码,执行Execute
2. 上线入库工作站，将箱子重新入库
如果箱子状态status字段为4（异常）：则只需要将料箱重新入库

4. 如果箱子状态正常，根据查询的LsCode看看lsCode是不是被其他订单给拣走了。

select * from ks_sale_order_container_sku where sn ='LS250212539441';

+--------+---------+-----------+-------------+-------------------+----------------------------+-------------------------+-------------+------------+---------------+----------+----------------------------+----------------------------+-------------+-------------+-------------------+------------------+------------------+----------------+
| id     | qty_uom | ks_bin_id | ks_bin_code | compartment_index | ks_sale_order_container_id | ks_sale_order_detail_id | sku_barcode | sku_code   | ks_sku_lot_id | sku_name | create_time                | update_time                | create_user | update_user | ks_bin_space_code | compartment_code | num_compartments | sn             |
+--------+---------+-----------+-------------+-------------------+----------------------------+-------------------------+-------------+------------+---------------+----------+----------------------------+----------------------------+-------------+-------------+-------------------+------------------+------------------+----------------+
| 460797 |   10000 |      8523 | WHXNC02817  |                 1 |                      17300 |                   84701 |             | S938C09985 |         26608 |          | 2020-12-03 22:05:04.136000 | 2020-12-03 22:05:04.136000 |             |             |                   | WHXNC02817       | NULL             | LS250212539441 |
+--------+---------+-----------+-------------+-------------------+----------------------------+-------------------------+-------------+------------+---------------+----------+----------------------------+----------------------------+-------------+-------------+-------------------+------------------+------------------+----------------+

如果查询到记录，则说明lsCode被操作人员误拣走了。

4. 修改订单号（建议由开发人员操作）

update ks_sale_order_header set order_no=concat(order_no,"_delete") where order_no = "1740853-2955653;

5. 重新下发订单（建议由开发人员操作）
   重新下发订单需要注意，只下发没有复核的数量

6. 如果非上述原因，则在所有操作台没有未封箱的料箱的情况下，重启station&mc；

docker restart iwms-station rcs-mc

Q: 库外的箱子存在库存

A:

1. 调用swagger接口将料箱变成异常：http://172.20.8.102:20000/swagger-ui.html --> 05.货箱 --> 测试将箱子变成异常，然后输入料箱编码,执行Execute
2. 上线入库工作站，将箱子重新入库

Q: 空箱子在货架上

A:

1. 确认系统记录料箱库存是否为空；
2. 系统记录库存为空，则通过盘点，将料箱盘空；
3. 系统记录库存不为空，则查询库存是否被占用，如果被占用，则可能是未复核或者复核失败造成，需要重新复核；如果未占用，则需要查询原因；