notes/work/移动杭研/问题处理/2024-05/0517-bpm工单：046-20240412-0030 无法点击现网部署验收.md

日期, 来源

日期	来源
2024-05-17 10:19	客响

问题详情

bpm 工单：046-20240412-0030 无法点击现网部署验收，这种该如何处理

处理过程

工单号：005-20240412001

企业信息：nvqln09g-gct6z6ueir1naotw

域名：video.cmcc-cs.cn

com.cmcc.cdn.platform.selfservice.service.impl.PortalInformationServiceImpl#updateDomainInformation

总结

域名无省份信息

INSERT INTO domain_config_province (domain_id, province_id)
VALUES (107, 1),
       (107, 2),
       (107, 3),
       (107, 4),
       (107, 5),
       (107, 6),
       (107, 7),
       (107, 8),
       (107, 9),
       (107, 10),
       (107, 11),
       (107, 12),
       (107, 13),
       (107, 14),
       (107, 15),
       (107, 16),
       (107, 17),
       (107, 18),
       (107, 19),
       (107, 20),
       (107, 21),
       (107, 22),
       (107, 23),
       (107, 24),
       (107, 25),
       (107, 26),
       (107, 27),
       (107, 28),
       (107, 29),
       (107, 30),
       (107, 31);

最后工单不显示问题可参考：0926-005-20230705002

# 代码位置com.cmcc.cdn.platform.selfservice.service.impl.AdaptWorkOrderServiceImpl#saveAdaptWorkOrderDomainInfo

# 复现关联关系
SELECT api.*
from order_plain_info api
         LEFT JOIN adapt_work_order_domain_plain_info awodpi
                   ON api.id = awodpi.order_plain_info_id
         LEFT JOIN adapt_work_order_domain_info awodi
                   ON awodpi.adapt_work_order_domain_info_id = awodi.id
where awodi.domain = 'video.cmcc-cs.cn'
  AND awodi.config_change_work_order_id = 877;

# 冗余信息
select *
from adapt_work_order_domain_plain_info
where order_plain_info_id in (555461, 555462);

#  删除中间表
delete
from adapt_work_order_domain_plain_info
where adapt_work_order_domain_info_id = 1067;