补丁PT077836执行脚本的时候提示报错
金蝶云社区-曹鹏
曹鹏
0人赞赏了该文章 1,210次浏览 未经作者许可,禁止转载编辑于2015年09月08日 15:08:36

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

您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!

请选择打赏金币数 *

10金币20金币30金币40金币50金币60金币
可用金币: 0