打完PT099001补丁后，MRP运算出错
186xxxx3391
591次浏览
编辑于2015年11月02日 11:02:35
cloud5.0打完PT099001后，出错！能否处理一下！QQ: 84617384
错误日志：source:SELECT FMATERIALID, FMATERIALNUMBER,FCOMPUTEID FROM T_MRP_MATERIALDATA11 A INNER JOIN ( select COLUMN_VALUE as FIDfrom table(cast(:FID_udt as UDT_VARCHARTABLE))) t ON a.FCOMPUTEID = t.FID UNIONALL SELECT FMATERIALID, FMATERIALNUMBER, FCOMPUTEID FROM T_MRP_MATERIALDATA8 AINNER JOIN ( select COLUMN_VALUE as FID from table(cast(:FID_udt asUDT_VARCHARTABLE))) t ON a.FCOMPUTEID = t.FID UNION ALL SELECT FMATERIALID,FMATERIALNUMBER, FCOMPUTEID FROM T_MRP_MATERIALDATA9 A INNER JOIN ( selectCOLUMN_VALUE as FID from table(cast(:FID_udt as UDT_VARCHARTABLE))) t ONa.FCOMPUTEID = t.FID UNION ALL SELECT FMATERIALID, FMATERIALNUMBER, FCOMPUTEIDFROM T_MRP_MATERIALDATA10 A INNER JOIN ( select COLUMN_VALUE as FID fromtable(cast(:FID_udt as UDT_VARCHARTABLE))) t ON a.FCOMPUTEID = t.FID UNION ALLSELECT FMATERIALID, FMATERIALNUMBER, FCOMPUTEID FROM T_MRP_MATERIALDATA2 AINNER JOIN ( select COLUMN_VALUE as FID from table(cast(:FID_udt asUDT_VARCHARTABLE))) t ON a.FCOMPUTEID = t.FID UNION ALL SELECT FMATERIALID,FMATERIALNUMBER, FCOMPUTEID FROM T_MRP_MATERIALDATA13 A INNER JOIN ( selectCOLUMN_VALUE as FID from table(cast(:FID_udt as UDT_VARCHARTABLE))) t ONa.FCOMPUTEID = t.FID UNION ALL SELECT FMATERIALID, FMATERIALNUMBER, FCOMPUTEIDFROM T_MRP_MATERIALDATA15 A INNER JOIN ( select COLUMN_VALUE as FID fromtable(cast(:FID_udt as UDT_VARCHARTABLE))) t ON a.FCOMPUTEID = t.FID UNION ALLSELECT FMATERIALID, FMATERIALNUMBER, FCOMPUTEID FROM T_MRP_MATERIALDATA4 AINNER JOIN ( select COLUMN_VALUE as FID from table(cast(:FID_udt asUDT_VARCHARTABLE))) t ON a.FCOMPUTEID = t.FID UNION ALL SELECT FMATERIALID,FMATERIALNUMBER, FCOMPUTEID FROM T_MRP_MATERIALDATA5 A INNER JOIN ( selectCOLUMN_VALUE as FID from table(cast(:FID_udt as UDT_VARCHARTABLE))) t ONa.FCOMPUTEID = t.FID UNION ALL SELECT FMATERIALID, FMATERIALNUMBER, FCOMPUTEIDFROM T_MRP_MATERIALDATA1 A INNER JOIN ( select COLUMN_VALUE as FID fromtable(cast(:FID_udt as UDT_VARCHARTABLE))) t ON a.FCOMPUTEID = t.FID UNION ALL
推荐阅读