|
楼主 |
发表于 2014-4-29 01:43:48
|
显示全部楼层
接上文30 more下,还有报错信息,应字数限制,所以发在这儿
url:/UI/system/service/common/bizAction.j
param:020trueError: {"message":"执行KSQL出错, KSQL: SELECT SA_OPOrg.*,SA_OPPerson as personID,SA_OPPerson.sName as personName,SA_OPPerson.sCode as personCode,SA_OPPerson.sNumb as personNumb,SA_OPPerson.sLoginName as personLoginName,SA_OPPerson.sPassword as personPassword,SA_OPPerson.sMainOrgID as personMainOrgID,SA_OPPerson.sIDCard as personIDCard,SA_OPPerson.sValidState as personValidState,SA_OPPerson.version as personVersion,SA_OPPerson.sSex as personSex,'' as ognName,'' as dptName,'' as posName FROM SA_OPOrg SA_OPOrg optional join SA_OPPerson SA_OPPerson on SA_OPOrg.sPersonID = SA_OPPerson WHERE ((1=0) AND (SA_OPOrg.sValidState = 1)) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, 20,刷新数据失败! ","reason":null,"code":"JUSTEP150210","stack":"java.lang.reflect.InvocationTargetException\n\tat sun.reflect.GeneratedMethodAccessor252.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n\tat java.lang.reflect.Method.invoke(Method.java:592)\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\n\tat java.lang.Thread.run(Thread.java:595)\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT SA_OPOrg.*,SA_OPPerson as personID,SA_OPPerson.sName as personName,SA_OPPerson.sCode as personCode,SA_OPPerson.sNumb as personNumb,SA_OPPerson.sLoginName as personLoginName,SA_OPPerson.sPassword as personPassword,SA_OPPerson.sMainOrgID as personMainOrgID,SA_OPPerson.sIDCard as personIDCard,SA_OPPerson.sValidState as personValidState,SA_OPPerson.version as personVersion,SA_OPPerson.sSex as personSex,'' as ognName,'' as dptName,'' as posName FROM SA_OPOrg SA_OPOrg optional join SA_OPPerson SA_OPPerson on SA_OPOrg.sPersonID = SA_OPPerson WHERE ((1=0) AND (SA_OPOrg.sValidState = 1)) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, 20\n\tat com.justep.exception.BusinessException.create(Unknown Source)\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)\n\tat com.justep.system.data.BizData.query(Unknown Source)\n\tat OrgProcedure.queryOPOrg(OrgProcedure.java:46)\n\t... 25 more\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP154053; 提示: KSQL语法错误, columns中的列sMail必须包含在select查出列中\n\tat com.justep.exception.BusinessException.create(Unknown Source)\n\tat com.justep.util.Utils.check(Unknown Source)\n\tat com.justep.system.ksql.parser.AbstractParser.handleColumns(Unknown Source)\n\tat com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)\n\tat com.justep.system.ksql.parser.QueryParser.start(Unknown Source)\n\tat com.justep.system.ksql.parser.QueryParser.start(Unknown Source)\n\tat com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)\n\t... 30 more\n","messages":["编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT SA_OPOrg.*,SA_OPPerson as personID,SA_OPPerson.sName as personName,SA_OPPerson.sCode as personCode,SA_OPPerson.sNumb as personNumb,SA_OPPerson.sLoginName as personLoginName,SA_OPPerson.sPassword as personPassword,SA_OPPerson.sMainOrgID as personMainOrgID,SA_OPPerson.sIDCard as personIDCard,SA_OPPerson.sValidState as personValidState,SA_OPPerson.version as personVersion,SA_OPPerson.sSex as personSex,'' as ognName,'' as dptName,'' as posName FROM SA_OPOrg SA_OPOrg optional join SA_OPPerson SA_OPPerson on SA_OPOrg.sPersonID = SA_OPPerson WHERE ((1=0) AND (SA_OPOrg.sValidState = 1)) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, 20","编码: JUSTEP154053; 提示: KSQL语法错误, columns中的列sMail必须包含在select查出列中"],"url":"/UI/system/service/common/bizAction.j","param":"020true"}
at Object.errorMessage (http://localhost:8080/x5/$v0edddae2cc934dc0a1b2cc55ca3663e0/base/base.js?language=zh_CN:1:44941)
at Object.justep.Request.sendBizRequest2.callback (http://localhost:8080/x5/$vfddc9e8d6cf14121989d775581217403/component/data/data.js?language=zh_CN:1:8040)
at cbf (http://localhost:8080/x5/$v0edddae2cc934dc0a1b2cc55ca3663e0/base/base.js?language=zh_CN:1:57159)
at Object.sendRequest2 (http://localhost:8080/x5/$v0edddae2cc934dc0a1b2cc55ca3663e0/base/base.js?language=zh_CN:1:57403)
at Object.sendBizRequest2 (http://localhost:8080/x5/$v0edddae2cc934dc0a1b2cc55ca3663e0/base/base.js?language=zh_CN:1:92181)
at null._doRefreshData (http://localhost:8080/x5/$vfddc9e8d6cf14121989d775581217403/component/data/data.js?language=zh_CN:1:7416)
at null.doRefreshData (http://localhost:8080/x5/$vfddc9e8d6cf14121989d775581217403/component/data/data.js?language=zh_CN:1:27486)
at null.refreshData (http://localhost:8080/x5/$vfddc9e8d6cf14121989d775581217403/component/data/data.js?language=zh_CN:1:14019)
at Object.mainActivity.refreshListData (http://localhost:8080/x5/$vf3e0675fd6dc44d790c4797cf40bc67c/UI/SA/OPM/organization/mainActivity.js?language=zh_CN:241:11)
at Object.mainActivity.refreshTreeData (http://localhost:8080/x5/$vf3e0675fd6dc44d790c4797cf40bc67c/UI/SA/OPM/organization/mainActivity.js?language=zh_CN:186:16) |
|