JUSTEP150210, 执行KSQL出错

binyueye@qq.com

这个问题我查过了论坛，但是我看不出来论坛里是怎么看出哪个字段有问题的
另外，我修改的时候，把datetime 都改成了date，不知道是不是这个原因


JUSTEP150210, 执行KSQL出错, KSQL: SELECT KY_Project.*  FROM KY_Project KY_Project LIMIT 0, 20,刷新数据失败！

编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT KY_Project.*  FROM KY_Project KY_Project LIMIT 0, 20
编码: JUSTEP150039; 提示: 执行sql: (SELECT  KY_Project.VERSION AS version, KY_Project.FSEQUENCE AS fsequence, KY_Project.FPROJECTINNO AS fProjectInNO, KY_Project.FPROJECTCONTRACTNO AS fProjectContractNo, KY_Project.FPROJECTLEVEL AS fProjectLevel, KY_Project.FPROJECTSOURCE AS fProjectSource, KY_Project.FPROJECTTYPE AS fProjectType, KY_Project.FPROJECTNAME AS fProjectName, KY_Project.FENDNAME AS fendName, KY_Project.FKAITITIME AS fKaiTiTime, KY_Project.FPROJECTBEGINTIME AS fProjectBeginTime, KY_Project.FJIETITIME AS fJieTiTime, KY_Project.FPROJECTENDTIME AS fProjectEndTime, KY_Project.FACCEPTANCELEVEL AS fAcceptanceLevel, KY_Project.FPROJECTLEADERID AS fProjectLeaderID, KY_Project.FPROJECTLEADER AS fProjectLeader, KY_Project.FPROJECTRESEARCHERS AS fProjectResearchers, KY_Project.FSTATUS AS fStatus, KY_Project.FCHARGEDEPT AS fChargeDept, KY_Project.FCOOPERATIONDEPT AS fcooperationDept, KY_Project.FARCHIVINGPROVE AS fArchivingProve, KY_Project.FCONCLUDINGREPORT AS fConcludingReport, KY_Project.FOPENINGREPORT AS fOpeningReport, KY_Project.fID AS KY_Project FROM KY_PROJECT KY_Project), binds: []出错
Unknown column 'KY_Project.FPROJECTTYPE' in 'field list'

---

java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        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.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT KY_Project.*  FROM KY_Project KY_Project LIMIT 0, 20
        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.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:12)
        ... 25 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: (SELECT  KY_Project.VERSION AS version, KY_Project.FSEQUENCE AS fsequence, KY_Project.FPROJECTINNO AS fProjectInNO, KY_Project.FPROJECTCONTRACTNO AS fProjectContractNo, KY_Project.FPROJECTLEVEL AS fProjectLevel, KY_Project.FPROJECTSOURCE AS fProjectSource, KY_Project.FPROJECTTYPE AS fProjectType, KY_Project.FPROJECTNAME AS fProjectName, KY_Project.FENDNAME AS fendName, KY_Project.FKAITITIME AS fKaiTiTime, KY_Project.FPROJECTBEGINTIME AS fProjectBeginTime, KY_Project.FJIETITIME AS fJieTiTime, KY_Project.FPROJECTENDTIME AS fProjectEndTime, KY_Project.FACCEPTANCELEVEL AS fAcceptanceLevel, KY_Project.FPROJECTLEADERID AS fProjectLeaderID, KY_Project.FPROJECTLEADER AS fProjectLeader, KY_Project.FPROJECTRESEARCHERS AS fProjectResearchers, KY_Project.FSTATUS AS fStatus, KY_Project.FCHARGEDEPT AS fChargeDept, KY_Project.FCOOPERATIONDEPT AS fcooperationDept, KY_Project.FARCHIVINGPROVE AS fArchivingProve, KY_Project.FCONCLUDINGREPORT AS fConcludingReport, KY_Project.FOPENINGREPORT AS fOpeningReport, KY_Project.fID AS KY_Project FROM KY_PROJECT KY_Project), binds: []出错
at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 30 more
Caused by: java.sql.SQLException: Unknown column 'KY_Project.FPROJECTTYPE' in 'field list'
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 31 more

url:/UI/system/service/common/bizAction.j
param:{"process":"/kyms/projects/process/Project/projectProcess","activity":"staticActivity_New","actionFlag":"__action_0__","executor":"A2093474386A4311884A512FE008D956","executeContext":"","action":"queryKY_ProjectAction","parameters":{"variables":{},"offset":0,"limit":20,"columns":"version,fsequence,fProjectInNO,fProjectContractNo,fProjectLevel,fProjectSource,fProjectType,fProjectName,fendName,fKaiTiTime,fProjectBeginTime,fJieTiTime,fProjectEndTime,fAcceptanceLevel,fProjectLeaderID,fProjectLeader,fProjectResearchers,fStatus,fChargeDept,fcooperationDept,fArchivingProve,fConcludingReport,fOpeningReport,KY_Project"},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"KY_Project","sequence":"fsequence,fProjectInNO,fProjectContractNo,fProjectLevel,fProjectSource,fProjectType,fProjectName,fendName,fKaiTiTime,fProjectBeginTime,fJieTiTime,fProjectEndTime,fProjectLeader,fProjectResearchers,fStatus,fChargeDept,fcooperationDept,fAcceptanceLevel,space-column,version,fProjectLeaderID,fArchivingProve,fConcludingReport,fOpeningReport"}}}Error: {"message":"执行KSQL出错, KSQL: SELECT KY_Project.*  FROM KY_Project KY_Project LIMIT 0, 20,刷新数据失败！ ","reason":"","code":"JUSTEP150210","stack":"java.lang.reflect.InvocationTargetException\r\n\tat sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\r\n\tat java.lang.reflect.Method.invoke(Method.java:592)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)\r\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)\r\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)\r\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\r\n\tat java.lang.Thread.run(Thread.java:595)\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT KY_Project.*  FROM KY_Project KY_Project LIMIT 0, 20\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\r\n\tat com.justep.system.data.BizData.query(Unknown Source)\r\n\tat BizProcedure.query(BizProcedure.java:12)\r\n\t... 25 more\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: (SELECT  KY_Project.VERSION AS version, KY_Project.FSEQUENCE AS fsequence, KY_Project.FPROJECTINNO AS fProjectInNO, KY_Project.FPROJECTCONTRACTNO AS fProjectContractNo, KY_Project.FPROJECTLEVEL AS fProjectLevel, KY_Project.FPROJECTSOURCE AS fProjectSource, KY_Project.FPROJECTTYPE AS fProjectType, KY_Project.FPROJECTNAME AS fProjectName, KY_Project.FENDNAME AS fendName, KY_Project.FKAITITIME AS fKaiTiTime, KY_Project.FPROJECTBEGINTIME AS fProjectBeginTime, KY_Project.FJIETITIME AS fJieTiTime, KY_Project.FPROJECTENDTIME AS fProjectEndTime, KY_Project.FACCEPTANCELEVEL AS fAcceptanceLevel, KY_Project.FPROJECTLEADERID AS fProjectLeaderID, KY_Project.FPROJECTLEADER AS fProjectLeader, KY_Project.FPROJECTRESEARCHERS AS fProjectResearchers, KY_Project.FSTATUS AS fStatus, KY_Project.FCHARGEDEPT AS fChargeDept, KY_Project.FCOOPERATIONDEPT AS fcooperationDept, KY_Project.FARCHIVINGPROVE AS fArchivingProve, KY_Project.FCONCLUDINGREPORT AS fConcludingReport, KY_Project.FOPENINGREPORT AS fOpeningReport, KY_Project.fID AS KY_Project FROM KY_PROJECT KY_Project), binds: []出错\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)\r\n\t... 30 more\r\nCaused by: java.sql.SQLException: Unknown column 'KY_Project.FPROJECTTYPE' in 'field list'\r\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)\r\n\tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)\r\n\tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)\r\n\tat com.mysql.jdbc.Connection.execSQL(Connection.java:2994)\r\n\tat com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)\r\n\tat com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)\r\n\t... 31 more\r\n","messages":["编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT KY_Project.*  FROM KY_Project KY_Project LIMIT 0, 20","编码: JUSTEP150039; 提示: 执行sql: (SELECT  KY_Project.VERSION AS version, KY_Project.FSEQUENCE AS fsequence, KY_Project.FPROJECTINNO AS fProjectInNO, KY_Project.FPROJECTCONTRACTNO AS fProjectContractNo, KY_Project.FPROJECTLEVEL AS fProjectLevel, KY_Project.FPROJECTSOURCE AS fProjectSource, KY_Project.FPROJECTTYPE AS fProjectType, KY_Project.FPROJECTNAME AS fProjectName, KY_Project.FENDNAME AS fendName, KY_Project.FKAITITIME AS fKaiTiTime, KY_Project.FPROJECTBEGINTIME AS fProjectBeginTime, KY_Project.FJIETITIME AS fJieTiTime, KY_Project.FPROJECTENDTIME AS fProjectEndTime, KY_Project.FACCEPTANCELEVEL AS fAcceptanceLevel, KY_Project.FPROJECTLEADERID AS fProjectLeaderID, KY_Project.FPROJECTLEADER AS fProjectLeader, KY_Project.FPROJECTRESEARCHERS AS fProjectResearchers, KY_Project.FSTATUS AS fStatus, KY_Project.FCHARGEDEPT AS fChargeDept, KY_Project.FCOOPERATIONDEPT AS fcooperationDept, KY_Project.FARCHIVINGPROVE AS fArchivingProve, KY_Project.FCONCLUDINGREPORT AS fConcludingReport, KY_Project.FOPENINGREPORT AS fOpeningReport, KY_Project.fID AS KY_Project FROM KY_PROJECT KY_Project), binds: []出错","Unknown column 'KY_Project.FPROJECTTYPE' in 'field list'"],"url":"/UI/system/service/common/bizAction.j","param":"{\"process\":\"/kyms/projects/process/Project/projectProcess\",\"activity\":\"staticActivity_New\",\"actionFlag\":\"__action_0__\",\"executor\":\"A2093474386A4311884A512FE008D956\",\"executeContext\":\"\",\"action\":\"queryKY_ProjectAction\",\"parameters\":{\"variables\":{},\"offset\":0,\"limit\":20,\"columns\":\"version,fsequence,fProjectInNO,fProjectContractNo,fProjectLevel,fProjectSource,fProjectType,fProjectName,fendName,fKaiTiTime,fProjectBeginTime,fJieTiTime,fProjectEndTime,fAcceptanceLevel,fProjectLeaderID,fProjectLeader,fProjectResearchers,fStatus,fChargeDept,fcooperationDept,fArchivingProve,fConcludingReport,fOpeningReport,KY_Project\"},\"translateParameter\":{\"dataType\":\"row-list\",\"transformIdcolumn\":true,\"useNamespace\":true,\"cellnameByRelation\":false,\"rowsConfig\":{\"concept\":\"KY_Project\",\"sequence\":\"fsequence,fProjectInNO,fProjectContractNo,fProjectLevel,fProjectSource,fProjectType,fProjectName,fendName,fKaiTiTime,fProjectBeginTime,fJieTiTime,fProjectEndTime,fProjectLeader,fProjectResearchers,fStatus,fChargeDept,fcooperationDept,fAcceptanceLevel,space-column,version,fProjectLeaderID,fArchivingProve,fConcludingReport,fOpeningReport\"}}}"}
   at Anonymous function (http://10.18.138.77:8080/x5/$vebe5caac245b460d89406d181ed8dd60/base/base.js?language=zh_CN:1:75434)
   at callback (http://10.18.138.77:8080/x5/$v59f21689e1df46c3bdb52db9ca73a095/component/data/data.js?language=zh_CN:1:14204)
   at cbf (http://10.18.138.77:8080/x5/$vebe5caac245b460d89406d181ed8dd60/base/base.js?language=zh_CN:1:87260)
   at Anonymous function (http://10.18.138.77:8080/x5/$vebe5caac245b460d89406d181ed8dd60/base/base.js?language=zh_CN:1:87520)
   at Anonymous function (http://10.18.138.77:8080/x5/$vebe5caac245b460d89406d181ed8dd60/base/base.js?language=zh_CN:1:35403)
   at Anonymous function (http://10.18.138.77:8080/x5/$v59f21689e1df46c3bdb52db9ca73a095/component/data/data.js?language=zh_CN:1:13574)
   at Anonymous function (http://10.18.138.77:8080/x5/$v59f21689e1df46c3bdb52db9ca73a095/component/data/data.js?language=zh_CN:1:58396)
   at Anonymous function (http://10.18.138.77:8080/x5/$v59f21689e1df46c3bdb52db9ca73a095/component/data/data.js?language=zh_CN:1:5217)
   at Anonymous function (http://10.18.138.77:8080/x5/$v59f21689e1df46c3bdb52db9ca73a095/component/data/data.js?language=zh_CN:1:27019)
   at Anonymous function (http://10.18.138.77:8080/x5/$v59f21689e1df46c3bdb52db9ca73a095/component/data/data.js?language=zh_CN:1:59010)

zf_fz

重新生成下数据库表，估计你添加了概念新关系，没有重新生成数据库表。

lixin_justep

检查一下 'FPROJECTTYPE' 这个关系在概念‘KY_Project’中是否存在

fpj

TOMCAT中提示的信息都很明确了，
Unknown column 'KY_Project.FPROJECTTYPE'

你的这个关系找不到，检查一下概念与关系的大小写是否一致，KSQL概念与关系是区分大小写的。