恢复了一个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 这个数据表是有的。这个报错是什么问题啊