用视图反向生成本体，标准ACTION报错，查不到数据

hanmeiyiyi · 发表于 2017-6-28 16:48:15

用我用ORALE视图反向生成本体，标准ACTION报错，查不到数据
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select V_REPAIR_REPORT.*    from V_REPAIR_REPORT V_REPAIR_REPORT LIMIT 0, 50
--> sql: SELECT  V_REPAIR_REPORT.ORGCODE AS V_REPAIR_REPORT, V_REPAIR_REPORT.ORGCODE AS ORGCODE, V_REPAIR_REPORT.ORGNAME AS ORGNAME, V_REPAIR_REPORT.ALL AS ALL, V_REPAIR_REPORT.FINISH AS FINISH, V_REPAIR_REPORT.UNFINISH AS UNFINISH, V_REPAIR_REPORT.PATCHED AS PATCHED, V_REPAIR_REPORT.NOPATCHED AS NOPATCHED FROM V_REPAIR_REPORT V_REPAIR_REPORT
--> binds: []
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.KSQL.select(Unknown Source)
at KSQLProcedure.query(KSQLProcedure.java:17)
... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  V_REPAIR_REPORT.ORGCODE AS V_REPAIR_REPORT, V_REPAIR_REPORT.ORGCODE AS ORGCODE, V_REPAIR_REPORT.ORGNAME AS ORGNAME, V_REPAIR_REPORT.ALL AS ALL, V_REPAIR_REPORT.FINISH AS FINISH, V_REPAIR_REPORT.UNFINISH AS UNFINISH, V_REPAIR_REPORT.PATCHED AS PATCHED, V_REPAIR_REPORT.NOPATCHED AS NOPATCHED FROM V_REPAIR_REPORT V_REPAIR_REPORT, binds: []出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 32 more
Caused by: java.sql.SQLException: ORA-01747: user.table.column, table.column 或列说明无效

jishuang · 发表于 2017-6-28 16:55:43

V_REPAIR_REPORT.ORGCODE AS V_REPAIR_REPORT, V_REPAIR_REPORT.ORGCODE AS ORGCODE, V_REPAIR_REPORT.ORGNAME AS ORGNAME, V_REPAIR_REPORT.ALL AS ALL, V_REPAIR_REPORT.FINISH AS FINISH, V_REPAIR_REPORT.UNFINISH AS UNFINISH, V_REPAIR_REPORT.PATCHED AS PATCHED, V_REPAIR_REPORT.NOPATCHED AS NOPATCHED FROM V_REPAIR_REPORT V_REPAIR_REPORT
到数据库中执行看看报错吗？

hanmeiyiyi · 发表于 2017-6-28 17:19:31

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150109; 提示: "/test/report/ontology/ORGCODE@Relation"不存在

重新做了一遍，又报这个错，什么原因啊，可是我第一次做的时候都是很顺利的

jishuang · 发表于 2017-6-28 17:31:06

http://docs.wex5.com/bex5-server-question-list-10026/

hanmeiyiyi · 发表于 2017-6-28 17:31:23

报一样的错

jishuang · 发表于 2017-6-28 17:37:50

这个是数据库报错的，确认视图设置的正确吗？

hanmeiyiyi · 发表于 2017-6-29 11:27:11

重新解压一个BEX5,重新做一遍就好了，原因不明，是不是把一个概念删除，再重新做一个名称一样的概念，容易出错？

jishuang · 发表于 2017-6-29 14:18:37

不会

hanmeiyiyi · 发表于 2017-6-29 15:41:40

十分感谢，结帖

		自动登录	找回密码
密码			注册

[结贴] 用视图反向生成本体，标准ACTION报错，查不到数据