补丁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 的字符集有问题,但是后台该表和字段已经有数据发生,不宜后台自行处理,请总部处理一下。
推荐阅读