紧急错误：columns中的列eX3URL必须包含在select查出列中

cgb0510

一直oa用的正常，昨天开始，突然出现如下错误：
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException 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:662) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25 at java.lang.reflect.Method.invoke(Method.java:597) at com.justep.system.action.Engine.invokeActions(Native Method) ... 21 more Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT SA_OPOrg.* FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sOrgKindID='dpt' AND SA_OPOrg.sValidState=1 and (SA_OPOrg.sFName like '/中山完美%' or SA_OPOrg.sFName like '/分公司%'))) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, -1时出错！ 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 com.justep.system.opm.OrgQuery.query(Unknown Source) at OPMProcedure.query(OPMProcedure.java:79) ... 26 more Caused by: com.justep.model.exception.ModelException: columns中的列eX3URL必须包含在select查出列中！ at com.justep.util.Utils.check(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.handleColumns(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source) at com.justep.system.ksql.parser.QueryParser.start(Unknown Source) at com.justep.system.ksql.parser.QueryParser.start(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source) ... 32 more url:/UI/system/service/common/bizAction.j param:{"process":"/OA/zccp/process/ysxm/ysxmProcess","activity":"ysbmkz","actionFlag":"__action_0__","executor":"","executeContext":"","action":"queryOrgAction","parameters":{"variables":{},"filter":"(SA_OPOrg.sOrgKindID='dpt' AND SA_OPOrg.sValidState=1 and (SA_OPOrg.sFName like '/中山完美%' or SA_OPOrg.sFName like '/分公司%'))","offset":0,"limit":-1,"columns":"sName,sCode,sLongName,sFName,sFCode,sFID,sOrgKindID,sSequence,sValidState,sParent,sLevel,sPhone,sFax,sAddress,sZip,sDescription,sPersonID,sNodeKind,version,eX3URL,eX3DptID,eX3PosID,eX3PsnID,SA_OPOrg"},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"SA_OPOrg","sequence":"sName,sFName,sCode,sLongName,sFCode,sFID,sOrgKindID,sSequence,sValidState,sParent,sLevel,sPhone,sFax,sAddress,sZip,sDescription,sPersonID,sNodeKind,version,eX3URL,eX3DptID,eX3PosID,eX3PsnID"}}}

fpj

着重检查你的KSQL语句，
1、注意概念与关系的大小写
2、把  概念.* 部分 换成   概念.* 和 概念.eX3URL  试试

以上两个还不行，那么把你的KSQL与SQL打印出来看一下，是否正常。
打印KSQL与SQL需要修改配置文件，可参考下面的贴子；7楼
http://bbs.justep.com/forum.php? ... &extra=page%3D1

cgb0510

重新编译一下ui，ok了