BOTP报错,缺少字段"FPREMERGE“处理方案
yangyang0283
887次浏览
编辑于2014年03月12日 13:51:19
问题分析：错误信息：select data error.ORA-00904: "T0"."FPREMERGE": invalid identifierCaused exception message is: ORA-00904: "T0"."FPREMERGE": invalid identifier错误详细堆栈信息：com.kingdee.bos.dao.ormapping.SQLAccessException: select data error.ORA-00904: "T0"."FPREMERGE": invalid identifierCaused exception message is: ORA-00904: "T0"."FPREMERGE": invalid identifier
解决方法：增加预分组合并字段IF NOT EXISTS (SELECT * FROM KSQL_USERCOLUMNS WHERE KSQL_COL_NAME = 'FPreMerge' AND KSQL_COL_TABNAME = 'T_BOT_Mapping')alter table T_BOT_Mapping add FPreMerge INT DEFAULT(0);
解决方法：增加预分组合并字段IF NOT EXISTS (SELECT * FROM KSQL_USERCOLUMNS WHERE KSQL_COL_NAME = 'FPreMerge' AND KSQL_COL_TABNAME = 'T_BOT_Mapping')alter table T_BOT_Mapping add FPreMerge INT DEFAULT(0);
推荐阅读