KSQL语法错误, columns中的列ALERT_INPUT_MAN必须包含在select查出...

dwz

一个概念新加了一个字段，然后所有引用这个data的页面都报一个KSQL语法错误, columns中的列ALERT_INPUT_MAN必须包含在select查出列中的错误，下面的原因都排查过
1.全局搜索过没有data的关系别名columns绑定了ALERT_INPUT_MAN这个字段
2.data的queryAction中的select：select TSP_PROBLEMS.* from TSP_PROBLEMS TSP_PROBLEMS

dwz

下面是报错的信息
VM25 index.w:114 [Deprecation] Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help, check https://xhr.spec.whatwg.org/.
(anonymous) @ VM25 index.w:114
app.js:280 Error: the fixed layout requires the slimscroll plugin!
fixSidebar @ app.js:280
icon.css:1 Failed to load resource: the server responded with a status of 404 (Not Found)
core.min.js:71 Error: __justepServerErrorStart__{"message":"刷新数据失败！ , \n执行KSQL出错, KSQL: SELECT TSP_PROBLEMS.*  FROM TSP_PROBLEMS TSP_PROBLEMS WHERE ((FROM_TYPE_CODE='MAN' or PROBLEM_FROM_TYPE='人工填报')) ORDER BY FIND_TIME DESC LIMIT 0, 20\n --> sql: \n --> binds: []","reason":"","code":"JUSTEP150210","stack":"java.lang.reflect.InvocationTargetException\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:497)\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.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:723)\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\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:103)\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:610)\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:503)\n\tat java.lang.Thread.run(Thread.java:745)\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT TSP_PROBLEMS.*  FROM TSP_PROBLEMS TSP_PROBLEMS WHERE ((FROM_TYPE_CODE='MAN' or PROBLEM_FROM_TYPE='人工填报')) ORDER BY FIND_TIME DESC LIMIT 0, 20\n --> sql: \n --> binds: []\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 BizProcedure.query(BizProcedure.java:12)\n\t... 27 more\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP154053; 提示: KSQL语法错误, columns中的列ALERT_INPUT_MAN必须包含在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... 32 more\n","messages":["编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT TSP_PROBLEMS.*  FROM TSP_PROBLEMS TSP_PROBLEMS WHERE ((FROM_TYPE_CODE='MAN' or PROBLEM_FROM_TYPE='人工填报')) ORDER BY FIND_TIME DESC LIMIT 0, 20\n --> sql: \n --> binds: []","编码: JUSTEP154053; 提示: KSQL语法错误, columns中的列ALERT_INPUT_MAN必须包含在select查出列中"],"url":"http://tsp.csass.crpower.com.cn/BusinessServer/business-action","param":{"contentType":"json","accept":"application/json","process":"/TSP/ProblemManage/process/ArtificialFillFroblem/artificialFillFroblemProcess","activity":"ArtificialFillFroblemBrowse","actionFlag":"__action_0__","executor":"","executeContext":"","action":"queryTSP_PROBLEMSAction","parameters":{"variables":{},"filter":"(FROM_TYPE_CODE='MAN' or PROBLEM_FROM_TYPE='人工填报')","offset":0,"limit":20,"columns":"ACTUAL_FINISH_DATE,AFFIX_ID,ALARMRESULT_ID,ALERT_INPUT_MAN,APPLICANT,APPROVE_DELAY,APP_DATE,APP_DEPT,APP_EXPLAIN,CANCEL_APPLICANT,CANCEL_APPROVER,CANCEL_APPROVER_DATE,CANCEL_APPROVER_DEPT,CANCEL_APP_DATE,CANCEL_REASON,CHARGE_DEP_ID,CHARGE_DEP_INAME,CHARGE_USER_ID,CHARGE_USER_NAME,CHECK_ADVISE,CHECK_MAN,CHECK_MAN_DEPT,CHECK_MAN_ID,CHECK_TIME,CHECK_TYPE,CHECK_TYPE_CODE,COMPLETE_TIME,CREATE_BY,CREATE_DT,CREATE_USER_ID,CREATOR_ID,CRITERIA_ID,CUR_DO,CUSTOMWNAME,DELAY_APPLICANT,DELAY_APPROVER,DELAY_APPROVER_DATE,DELAY_APPROVER_DEPT,DELAY_APPR_ID,DELAY_APP_DATE,DELAY_ID,DELAY_REASON,DELAY_TIME,DELAY_TO,DODESC,EQUIPMENT_DESC,EQUIPMENT_ID,EXECUTIVE,EXEC_TIME,FIND_TIME,FLOW_ID,FROM_TYPE_CODE,GQ_CANCEL_APPLICANT,GQ_CANCEL_APPROVER,GQ_CANCEL_APPR_DATE,GQ_CANCEL_APPR_DEPT,GQ_CANCEL_APP_DATE,GQ_CANCEL_REASON,HOUR_AVG,INPUT_COMPANY_CODE,INPUT_MAN,INPUT_MAN_CODE,ISNEED_HELP,IS_CREAT_PROB,IS_DEFECT,IS_DEL,IS_ENABLE,IS_FILL_QR,IS_TOEXPDB,MTCR,MTCR_ID,MTC_DATE,NUM,OGN_ID,OGN_NAME,OTH_DO,OTH_REASON_ALA,PLANNER,PLANNER_DEPT,PLAN_COMPLETE_TIME,POSITION_DESC,POSITION_ID,PROBLEM_CODE,PROBLEM_DESC,PROBLEM_FROM,PROBLEM_FROM_ID,PROBLEM_FROM_NAME,PROBLEM_FROM_TYPE,PROBLEM_ID,PROBLEM_LEVEL,PROBLEM_LEVEL_CODE,PROBLEM_LEVEL_ONE,PROBLEM_NAME,PROBLEM_RESON_EXP,PROCESS_END_TIME,PROCESS_STATE,PROJECT_FILE,PROJECT_FILE_CODE,PRO_AFFIX,PRO_COM_SFCODE,RD_AFFIX_ID,RD_AUX_DEPT,RD_COMP_DATE,RD_OPINION_PROG,RD_RESP_PERSON,RD_RESP_PERSON_DEPT,RECT_ADV,RESOLVE_TIME,RESP_AFFIX_ID,RG_CODE,RG_ID,SITE_ID,SKILL_ID,SKILL_NAME,SPECIAL,SPECIAL_CODE,STATUS,STATUS_CODE,TEAM_ALARM_RULE,TEAM_ALARM_TIMES,TEAM_ALARM_VALUE,TIME_LENGTH,TSP_PROBLEMS,TSP_STD_ID,TSP_STD_NAME,UPDATE_BY,UPDATE_DT,UPDATOR_ID,WARN_END_TIME,WARN_START_TIME,version","orderBy":"FIND_TIME DESC"},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"includeState":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"TSP_PROBLEMS","sequence":"ACTUAL_FINISH_DATE,AFFIX_ID,ALARMRESULT_ID,ALERT_INPUT_MAN,APPLICANT,APPROVE_DELAY,APP_DATE,APP_DEPT,APP_EXPLAIN,CANCEL_APPLICANT,CANCEL_APPROVER,CANCEL_APPROVER_DATE,CANCEL_APPROVER_DEPT,CANCEL_APP_DATE,CANCEL_REASON,CHARGE_DEP_ID,CHARGE_DEP_INAME,CHARGE_USER_ID,CHARGE_USER_NAME,CHECK_ADVISE,CHECK_MAN,CHECK_MAN_DEPT,CHECK_MAN_ID,CHECK_TIME,CHECK_TYPE,CHECK_TYPE_CODE,COMPLETE_TIME,CREATE_BY,CREATE_DT,CREATE_USER_ID,CREATOR_ID,CRITERIA_ID,CUR_DO,CUSTOMWNAME,DELAY_APPLICANT,DELAY_APPROVER,DELAY_APPROVER_DATE,DELAY_APPROVER_DEPT,DELAY_APPR_ID,DELAY_APP_DATE,DELAY_ID,DELAY_REASON,DELAY_TIME,DELAY_TO,DODESC,EQUIPMENT_DESC,EQUIPMENT_ID,EXECUTIVE,EXEC_TIME,FIND_TIME,FLOW_ID,FROM_TYPE_CODE,GQ_CANCEL_APPLICANT,GQ_CANCEL_APPROVER,GQ_CANCEL_APPR_DATE,GQ_CANCEL_APPR_DEPT,GQ_CANCEL_APP_DATE,GQ_CANCEL_REASON,HOUR_AVG,INPUT_COMPANY_CODE,INPUT_MAN,INPUT_MAN_CODE,ISNEED_HELP,IS_CREAT_PROB,IS_DEFECT,IS_DEL,IS_ENABLE,IS_FILL_QR,IS_TOEXPDB,MTCR,MTCR_ID,MTC_DATE,NUM,OGN_ID,OGN_NAME,OTH_DO,OTH_REASON_ALA,PLANNER,PLANNER_DEPT,PLAN_COMPLETE_TIME,POSITION_DESC,POSITION_ID,PROBLEM_CODE,PROBLEM_DESC,PROBLEM_FROM,PROBLEM_FROM_ID,PROBLEM_FROM_NAME,PROBLEM_FROM_TYPE,PROBLEM_ID,PROBLEM_LEVEL,PROBLEM_LEVEL_CODE,PROBLEM_LEVEL_ONE,PROBLEM_NAME,PROBLEM_RESON_EXP,PROCESS_END_TIME,PROCESS_STATE,PROJECT_FILE,PROJECT_FILE_CODE,PRO_AFFIX,PRO_COM_SFCODE,RD_AFFIX_ID,RD_AUX_DEPT,RD_COMP_DATE,RD_OPINION_PROG,RD_RESP_PERSON,RD_RESP_PERSON_DEPT,RECT_ADV,RESOLVE_TIME,RESP_AFFIX_ID,RG_CODE,RG_ID,SITE_ID,SKILL_ID,SKILL_NAME,SPECIAL,SPECIAL_CODE,STATUS,STATUS_CODE,TEAM_ALARM_RULE,TEAM_ALARM_TIMES,TEAM_ALARM_VALUE,TIME_LENGTH,TSP_PROBLEMS,TSP_STD_ID,TSP_STD_NAME,UPDATE_BY,UPDATE_DT,UPDATOR_ID,WARN_END_TIME,WARN_START_TIME,rowNo,version"}}}}__justepServerErrorEnd__
    at Object.create (core.min.js:71)
    at Object.Request.errorMessage (biz.common.min.js:12)
    at Object.callback (biz.common.min.js:12)
    at Object.h (biz.common.min.js:12)
    at f (core.min.js:71)
    at Object.add (core.min.js:71)
    at _sendRequest (biz.common.min.js:12)
    at Object.Request.sendRequest (biz.common.min.js:12)
    at Object.$var._sendBizRequest (eval at __actionFinish (biz.common.min.js:12), <anonymous>:1:577)
    at Object.Request.sendBizRequest (biz.common.min.js:12)

jishuang

tomcat重启看看

dwz

jishuang 发表于 2019-7-5 11:13
tomcat重启看看

重启了十几遍了

jishuang

把BIZ和UI2的资源发一下

honeyscj

请问这个问题解决了吗，我也遇到了类似的问题

jishuang

在queryAction的select编辑框中测试看看查出的字段有新添加的吗？