单据转换规则双击报错
金蝶云社区-云社区用户8W141234
云社区用户8W141234
0人赞赏了该文章 573次浏览 未经作者许可,禁止转载编辑于2016年10月17日 14:59:26

恢复了一个ORACLE账套,双击具体的转换规则数据,弹出报错如下:
2016-10-17 14:29:40 INFO [con.out] [2016-10-17 14:29:40,927 ERROR RPC-7]execute sql error: ORA-00942: table or view does not exist

sql:SELECT "T0"."FID" "ID", "T0"."FMERGECHARSKEY" "MERGECHARSKEY", "T0"."FMERGECHARSEXPRESSION" "MERGECHARSEXPRESSION", "T0"."FMERGEMAPPINGID" "T1.ID" FROM "T_BOT_BOTMERGECHARSINFO" "T0" INNER JOIN "T_BOT_MAPPING" "T1" ON "T0"."FMERGEMAPPINGID" = "T1"."FID" WHERE "T1"."FID" = ? ORDER BY "T1.ID" ASC
ksql:SELECT "T0"."FID" "ID", "T0"."FMERGECHARSKEY" "MERGECHARSKEY", "T0"."FMERGECHARSEXPRESSION" "MERGECHARSEXPRESSION", "T0"."FMERGEMAPPINGID" "t1.id" FROM "T_BOT_BOTMERGECHARSINFO" "T0" INNER JOIN "T_BOT_MAPPING" "t1" ON "T0"."FMERGEMAPPINGID" = "T1"."FID" WHERE "T1"."FID" = ? ORDER BY "T1.ID" ASC
2016-10-17 14:29:40 INFO [con.out] [2016-10-17 14:29:40,927 ERROR RPC-7]select() occur error:ORA-00942: table or view does not exist

sql: SELECT "T0"."FID" "ID", "T0"."FMERGECHARSKEY" "MERGECHARSKEY", "T0"."FMERGECHARSEXPRESSION" "MERGECHARSEXPRESSION", "T0"."FMERGEMAPPINGID" "t1.id" FROM "

看了其中的表 T_BOT_BOTMERGECHARSINFO在正式账套也是没有的,但是正式账套是不报错的啊。

T_BOT_MAPPING 这个数据表是有的。这个报错是什么问题啊