解决方案：
https://zhidao.baidu.com/question/1574478451455764660.html
发现本地客户端没有移动ERP模块，懒得折腾，跟踪了点击取消信息服务发布按钮的查询SQL如下
SELECT t1.FListTplID , t1.FUserDefine , CASE ISNULL(t2.FRptID, 0) WHEN 0 THEN 0 ELSE 1 END AS FDeploySMS FROM ICClassSQLReport t1 LEFT JOIN t_SMSDeployed t2 ON t2.FRptID = t1.FListTplID WHERE t1.FListTplID = 10004; SELECT * FROM t_SMSDeployed WHERE FRptID=10004 UPDATE t_SMSDeployed SET FRptID=FRptID*-1 WHERE ABS(FRptID)=10004 SELECT * INTO t_SMSDeployed_20200106 FROM t_SMSDeployed
处理方式就是先删除后插入，或者直接将FListTplID字段值更新成另外的值，记得先备份这张物理表，等取消发布后，再更新回来。