补丁PT077836执行脚本的时候提示报错

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

补丁PT077836执行脚本的时候提示报错

补丁PT077836执行脚本的时候提示报错,如下:
com.kingdee.eas.tools.admin.domain.DomainException: Run SQLScript Patch[PT077836] in DC[test123] failed!ErrInfo is:Execute provider[./sql/PT076939_mm_control_data.sql], sql[UPDATE T_MM_Productionorder po SET FActualBeginDate = (SELECT min(pickDate) FROM (SELECT m.FBizDate PICKDATE, p.FProductionorderID ORDERID FROM T_IM_Materialreqbill M INNER JOIN T_IM_MaterialreqbillEntry ME ON m.fid = me.FParentID INNER JOIN T_MM_PSMRRelation PSM ON me.fsourcebillentryid = psm.ftempentryid INNER JOIN T_MM_PickingSlipBillEntry PE ON psm.fsrcentryid = pe.fid INNER JOIN T_MM_PickingSlipBill P ON pe.FParentID = p.fid WHERE m.FbaseStatus = 4 UNION SELECT m.FBizDate PICKDATE, me.FSourceBillID ORDERID FROM T_IM_Materialreqbill M INNER JOIN T_IM_MaterialreqbillEntry ME ON m.fid = me.FParentID WHERE m.FbaseStatus = 4 UNION SELECT rpt.FBizDate PICKDATE, rpt.FProductionorderID ORDERID FROM T_MM_FinishedRpt RPT WHERE rpt.FbaseStatus = 4) T WHERE t.orderID = po.fid) WHERE (po.FActualBeginDate IS NULL)] failed, sqlcode[12704] sqlstat[72000],Causedby[ORA-12704: 字符集不匹配
],DBType=[Oracle]
经测试T_IM_MaterialreqbillEntry的FSourceBillID 的字符集有问题,但是后台该表和字段已经有数据发生,不宜后台自行处理,请总部处理一下。


这个补丁很久了,是在打补丁还是在单独执行脚本?

补丁PT077836执行脚本的时候提示报错

补丁PT077836执行脚本的时候提示报错,如下:com.kingdee.eas.tools.admin.domain.DomainException: Run SQLScript Patch[PT077836] in...
点击下载文档
分享:
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息