反向生成本体报表设计时没有表的字段

fwdfn

使用mysql数据库通过数据库里面的表进行反向生成本体后，在进行报表设计时数据源里面没有字段如图field:

报表数据设置了，但是不显示字段，求指点，是哪儿错了。

jishuang

reportData具体怎么设置的？

fwdfn

我将东西全部删除后又重新配置了一下就好了，步骤都是一样的，但是现在的又有新的问题了
network里面是没问题的，

fwdfn

错误
network没问题

jishuang

看tomcat控制台完整的错误信息

fwdfn

tomcat错误信息如下：

1. com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select Demo_products,Demo_products.version as version,Demo_products.fProductName as fProductName,Demo_products.fSupplierID as fSupplierID,Demo_products.fCategoryID as fCategoryID,Demo_products.fQuantityPerUnit as fQuantityPerUnit,Demo_products.fUnitPrice as fUnitPrice,Demo_products.fUnitsinstock as fUnitsinstock from Demo_products Demo_products
   
2. --> sql: SELECT  Demo_products.fProductID, Demo_products.VERSION AS version, Demo_products.FPRODUCTNAME AS fProductName, Demo_products.FSUPPLIERID AS fSupplierID, Demo_products.FCATEGORYID AS fCategoryID, Demo_products.FQUANTITYPERUNIT AS fQuantityPerUnit, Demo_products.FUNITPRICE AS fUnitPrice, Demo_products.FUNITSINSTOCK AS fUnitsinstock FROM demo_products Demo_products
   
3. --> binds: []

复制代码

但是我把--> sql:
SELECT  Demo_products.fProductID, Demo_products.VERSION AS version, Demo_products.FPRODUCTNAME AS fProductName, Demo_products.FSUPPLIERID AS fSupplierID, Demo_products.FCATEGORYID AS fCategoryID, Demo_products.FQUANTITYPERUNIT AS fQuantityPerUnit, Demo_products.FUNITPRICE AS fUnitPrice, Demo_products.FUNITSINSTOCK AS fUnitsinstock FROM demo_products Demo_products拿到mysql里跑了下，是可以查询到数据的

jishuang

发tomcat完整的错误信息

fwdfn

2017-07-31 11:44:45 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2017-07-31 11:44:45 加载模块：/ZBReport/ZReport/process/BReport ...
2017-07-31 11:44:45 加载模块：/ZBReport/ZReport/logic/action ...
2017-07-31 11:44:45 action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/ZBReport/ZReport/process/BReport/bReportProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="BReportAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"/></parameters></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select Demo_products.* from Demo_products Demo_products
--> sql: SELECT  Demo_products.fProductID AS Demo_products, Demo_products.VERSION AS version, Demo_products.FPRODUCTNAME AS fProductName, Demo_products.FSUPPLIERID AS fSupplierID, Demo_products.FCATEGORYID AS fCategoryID, Demo_products.FQUANTITYPERUNIT AS fQuantityPerUnit, Demo_products.FUNITPRICE AS fUnitPrice, Demo_products.FUNITSINSTOCK AS fUnitsinstock FROM demo_products Demo_products
--> 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  Demo_products.fProductID AS Demo_products, Demo_products.VERSION AS version, Demo_products.FPRODUCTNAME AS fProductName, Demo_products.FSUPPLIERID AS fSupplierID, Demo_products.FCATEGORYID AS fCategoryID, Demo_products.FQUANTITYPERUNIT AS fQuantityPerUnit, Demo_products.FUNITPRICE AS fUnitPrice, Demo_products.FUNITSINSTOCK AS fUnitsinstock FROM demo_products Demo_products, binds: []出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 32 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'x5sys.demo_products' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.Util.getInstance(Util.java:383)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 33 more
[ERROR] 2017-07-31 11:44:45,807 com.justep.report.controller.DataController - 报表数据获取失败
执行KSQL出错, KSQL: select Demo_products.* from Demo_products Demo_products
--> sql: SELECT  Demo_products.fProductID AS Demo_products, Demo_products.VERSION AS version, Demo_products.FPRODUCTNAME AS fProductName, Demo_products.FSUPPLIERID AS fSupplierID, Demo_products.FCATEGORYID AS fCategoryID, Demo_products.FQUANTITYPERUNIT AS fQuantityPerUnit, Demo_products.FUNITPRICE AS fUnitPrice, Demo_products.FUNITSINSTOCK AS fUnitsinstock FROM demo_products Demo_products
--> binds: []
com.justep.report.exception.ReportServerException: 报表数据获取失败
        at com.justep.report.controller.DataController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.InitController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.Servlet.a(Unknown Source)
        at com.justep.report.Servlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.report.exception.ReportServerException: 执行KSQL出错, KSQL: select Demo_products.* from Demo_products Demo_products
--> sql: SELECT  Demo_products.fProductID AS Demo_products, Demo_products.VERSION AS version, Demo_products.FPRODUCTNAME AS fProductName, Demo_products.FSUPPLIERID AS fSupplierID, Demo_products.FCATEGORYID AS fCategoryID, Demo_products.FQUANTITYPERUNIT AS fQuantityPerUnit, Demo_products.FUNITPRICE AS fUnitPrice, Demo_products.FUNITSINSTOCK AS fUnitsinstock FROM demo_products Demo_products
--> binds: []
        at com.justep.report.controller.DataController.a(Unknown Source)
        at com.justep.report.controller.DataController.a(Unknown Source)
        ... 20 more
Caused by: java.lang.Exception
        ... 22 more
2017-07-31 11:44:46 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2017-07-31 11:44:46 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2017-07-31 11:44:47 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w

fwdfn

因为字数原因这个是头部
2017-07-31 11:44:32 开始-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2017-07-31 11:44:32 结束-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2017-07-31 11:44:32 开始-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2017-07-31 11:44:34 结束-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2017-07-31 11:44:34 卸载模块 /ZBReport/ZReport/logic/action ....
2017-07-31 11:44:34 卸载模块 /ZBReport/ZReport/logic/action 结束
2017-07-31 11:44:35 开始-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2017-07-31 11:44:36 结束-WINDOW生成中间文件: /UI2/portal/pc3/login/login.w
2017-07-31 11:44:36 开始-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2017-07-31 11:44:37 结束-中间文件生成缓存文件: /UI2/portal/pc3/login/login.w
2017-07-31 11:44:39 开始-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2017-07-31 11:44:39 结束-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2017-07-31 11:44:39 开始-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2017-07-31 11:44:40 结束-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2017-07-31 11:44:41 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2017-07-31 11:44:42 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2017-07-31 11:44:42 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2017-07-31 11:44:43 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2017-07-31 11:44:43 开始-WINDOW生成中间文件: /UI2/ZBReport/ZReport/process/BReport/mainActivity.w
2017-07-31 11:44:43 结束-WINDOW生成中间文件: /UI2/ZBReport/ZReport/process/BReport/mainActivity.w
2017-07-31 11:44:43 开始-中间文件生成缓存文件: /UI2/ZBReport/ZReport/process/BReport/mainActivity.w
2017-07-31 11:44:45 结束-中间文件生成缓存文件: /UI2/ZBReport/ZReport/process/BReport/mainActivity.w

hdkj

建立数据库表的时候要有两个字段,fid和version字段,没有这俩字段就会报错.