补丁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执行脚本的时候提示报错
本文2024-09-16 23:21:28发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-54045.html
- 鼎捷EAI整合規範文件V3.1.07 (集團).pdf
- 鼎捷OpenAPI應用場景說明_基礎資料.pdf
- 鼎捷OpenAPI應用場景說明_財務管理.pdf
- 鼎捷T100 API設計器使用手冊T100 APIDesigner(V1.0).docx
- 鼎新e-GoB2雲端ERP B2 線上課程E6-2應付票據整批郵寄 領取.pdf
- 鼎新e-GoB2雲端ERP B2 線上課程A4使用者建立權限設定.pdf
- 鼎新e-GoB2雲端ERP B2 線上課程C3會計開帳與會計傳票.pdf
- 鼎新e-GoB2雲端ERP B2 線上課程E6-1應付票據.pdf
- 鼎新e-GoB2雲端ERP B2 線上課程A5-1進銷存參數設定(初階篇).pdf
- 鼎新e-GoB2雲端ERP B2 線上課程D2帳款開帳與票據開帳.pdf