起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步，快速开始

起步软件技术论坛»论坛 › 开发者论坛 › BeX5开发者论坛 › 初学报表问题
返回列表 发新帖
查看: 2041|回复: 4

[结贴] 初学报表问题

[复制链接]

133

主题

496

帖子

931

积分

高级会员

Rank: 4

积分
931
QQ
发表于 2014-5-15 13:58:32 | 显示全部楼层 |阅读模式
版本: X5.2.5 小版本号: 2393
数据库: MySQL 服务器操作系统: 应用服务器:
客户端操作系统: 浏览器:
第一次做报表，现有这几个问题：
1.创建报表Action时 ksql使用占位符模糊查询的写法  select * from from SA_CeyuWorkTask SA_CeyuWorkTask where SA_CeyuWorkTask.fManager like concat('%', :id, '%')对不对？
2.如何给Action传参？
  1. var id = justep.Context.getCurrentPersonID();
  2.         var rep = justep.xbl('ds1');
  3.         alert("curID==="+id);
  4.         rep.setStringVar('id', id);
  5.         justep.xbl('groupReport').refresh();
复制代码
是否正确？
3.控制台报错
  1. 2014-05-15 13:48:41 开始-WINDOW生成中间文件: /UI/SA/zhigao/process/CeyuWorkTask/taskReportActivity.w
  2. 2014-05-15 13:48:41 结束-WINDOW生成中间文件: /UI/SA/zhigao/process/CeyuWorkTask/taskReportActivity.w
  3. 2014-05-15 13:48:41 开始-中间文件生成缓存文件: /UI/SA/zhigao/process/CeyuWorkTask/taskReportActivity.w
  4. 2014-05-15 13:48:41 结束-中间文件生成缓存文件: /UI/SA/zhigao/process/CeyuWorkTask/taskReportActivity.w
  5. 2014-05-15 13:48:41 卸载模块 /SA/zhigao/logic/code ....
  6. 2014-05-15 13:48:41 模块卸载结束.
  7. 2014-05-15 13:48:41 加载模块：/SA/zhigao/process/CeyuWorkTask ...
  8. 2014-05-15 13:48:41 加载模块：/SA/zhigao/logic/code ...
  9. 2014-05-15 13:48:41 加载模块：/SA/zhigao/logic/action ...
  10. 2014-05-15 13:48:41 加载模块：/SA/userDefineWidget/logic/action ...
  11. 2014-05-15 13:48:42 加载模块：/SA/userDefineWidget/logic/code ...
  12. ksql:
  13. select SA_CeyuWorkTask.fManager as fManager,SA_CeyuWorkTask.fCeyuWorkTaskName as fCeyuWorkTaskName,SA_CeyuWorkTask.fCeyuWorkTaskDeadline as fCeyuWorkTaskDeadline,SA_CeyuWorkTask.fEndDate as fEndDate,SA_CeyuWorkTask.fKF as fKF,SA_CeyuWorkTask.fKFBFB as fKFBFB from SA_CeyuWorkTask SA_CeyuWorkTask where SA_CeyuWorkTask.fManager like concat('%', :id, '%') or SA_CeyuWorkTask.fTJRID like concat('%', :id, '%') or SA_CeyuWorkTask.fCeyuWorkTaskRecipientFIDs like concat('%', :id, '%') or SA_CeyuWorkTask.fYSRFID like concat('%', :id, '%') or SA_CeyuWorkTask.fRLZYFID like concat('%', :id, '%')
  14. 2014-05-15 13:48:45 invokeActions error！
  15. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
  16.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
  17.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
  18.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
  19.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  20.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
  21.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
  22.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  23.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
  24.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  25.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  26.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  27.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  28.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  29.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  30.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  31.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  32.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  33.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  34.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  35.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  36.         at java.lang.Thread.run(Thread.java:595)
  37. Caused by: java.lang.reflect.InvocationTargetException
  38.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  39.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  40.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  41.         at java.lang.reflect.Method.invoke(Method.java:592)
  42.         at com.justep.system.action.Engine.invokeActions(Native Method)
  43.         ... 21 more
  44. Caused by: com.justep.model.exception.ModelException: 执行ksql:select SA_CeyuWorkTask.fManager as fManager,SA_CeyuWorkTask.fCeyuWorkTaskName as fCeyuWorkTaskName,SA_CeyuWorkTask.fCeyuWorkTaskDeadline as fCeyuWorkTaskDeadline,SA_CeyuWorkTask.fEndDate as fEndDate,SA_CeyuWorkTask.fKF as fKF,SA_CeyuWorkTask.fKFBFB as fKFBFB from SA_CeyuWorkTask SA_CeyuWorkTask where SA_CeyuWorkTask.fManager like concat('%', :id, '%') or SA_CeyuWorkTask.fTJRID like concat('%', :id, '%') or SA_CeyuWorkTask.fCeyuWorkTaskRecipientFIDs like concat('%', :id, '%') or SA_CeyuWorkTask.fYSRFID like concat('%', :id, '%') or SA_CeyuWorkTask.fRLZYFID like concat('%', :id, '%')时出错！
  45.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  46.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  47.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  48.         at com.justep.system.data.KSQL.select(Unknown Source)
  49.         at Zhigao.taskReport(Zhigao.java:200)
  50.         ... 26 more
  51. Caused by: com.justep.model.exception.ModelException: 找不到变量：id对应的值！
  52.         at com.justep.util.Utils.check(Unknown Source)
  53.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  54.         at com.justep.system.ksql.node.VariableNode.accept(Unknown Source)
  55.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  56.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  57.         at com.justep.system.ksql.node.FunctionNode.accept(Unknown Source)
  58.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  59.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  60.         at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
  61.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  62.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  63.         at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
  64.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  65.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  66.         at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
  67.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  68.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  69.         at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
  70.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  71.         at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
  72.         at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
  73.         ... 31 more
  74. 2014-05-15 13:48:45 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
  75. <action direct-execute="true" process="/SA/zhigao/process/CeyuWorkTask/ceyuWorkTaskProcess" activity="taskReportActivity" action-flag="__action_0__" executor="" execute-context="" name="taskReportAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"/></parameters></action>
  76. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
  77.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
  78.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
  79.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
  80.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  81.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
  82.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
  83.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  84.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
  85.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  86.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  87.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  88.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  89.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  90.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  91.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  92.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  93.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  94.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  95.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  96.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  97.         at java.lang.Thread.run(Thread.java:595)
  98. Caused by: java.lang.reflect.InvocationTargetException
  99.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  100.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  101.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  102.         at java.lang.reflect.Method.invoke(Method.java:592)
  103.         at com.justep.system.action.Engine.invokeActions(Native Method)
  104.         ... 21 more
  105. Caused by: com.justep.model.exception.ModelException: 执行ksql:select SA_CeyuWorkTask.fManager as fManager,SA_CeyuWorkTask.fCeyuWorkTaskName as fCeyuWorkTaskName,SA_CeyuWorkTask.fCeyuWorkTaskDeadline as fCeyuWorkTaskDeadline,SA_CeyuWorkTask.fEndDate as fEndDate,SA_CeyuWorkTask.fKF as fKF,SA_CeyuWorkTask.fKFBFB as fKFBFB from SA_CeyuWorkTask SA_CeyuWorkTask where SA_CeyuWorkTask.fManager like concat('%', :id, '%') or SA_CeyuWorkTask.fTJRID like concat('%', :id, '%') or SA_CeyuWorkTask.fCeyuWorkTaskRecipientFIDs like concat('%', :id, '%') or SA_CeyuWorkTask.fYSRFID like concat('%', :id, '%') or SA_CeyuWorkTask.fRLZYFID like concat('%', :id, '%')时出错！
  106.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  107.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  108.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  109.         at com.justep.system.data.KSQL.select(Unknown Source)
  110.         at Zhigao.taskReport(Zhigao.java:200)
  111.         ... 26 more
  112. Caused by: com.justep.model.exception.ModelException: 找不到变量：id对应的值！
  113.         at com.justep.util.Utils.check(Unknown Source)
  114.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  115.         at com.justep.system.ksql.node.VariableNode.accept(Unknown Source)
  116.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  117.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  118.         at com.justep.system.ksql.node.FunctionNode.accept(Unknown Source)
  119.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  120.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  121.         at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
  122.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  123.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  124.         at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
  125.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  126.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  127.         at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
  128.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  129.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  130.         at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
  131.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  132.         at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
  133.         at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
  134.         ... 31 more
  135. [ERROR] 2014-05-15 13:48:45,421 com.justep.report.controller.DataController - 报表数据获取失败
  136. 执行ksql:select SA_CeyuWorkTask.fManager as fManager,SA_CeyuWorkTask.fCeyuWorkTaskName as fCeyuWorkTaskName,SA_CeyuWorkTask.fCeyuWorkTaskDeadline as fCeyuWorkTaskDeadline,SA_CeyuWorkTask.fEndDate as fEndDate,SA_CeyuWorkTask.fKF as fKF,SA_CeyuWorkTask.fKFBFB as fKFBFB from SA_CeyuWorkTask SA_CeyuWorkTask where SA_CeyuWorkTask.fManager like concat('%', :id, '%') or SA_CeyuWorkTask.fTJRID like concat('%', :id, '%') or SA_CeyuWorkTask.fCeyuWorkTaskRecipientFIDs like concat('%', :id, '%') or SA_CeyuWorkTask.fYSRFID like concat('%', :id, '%') or SA_CeyuWorkTask.fRLZYFID like concat('%', :id, '%')时出错！
  137. com.justep.report.exception.ReportServerException: 报表数据获取失败
  138.         at com.justep.report.controller.DataController.execute(Unknown Source)
  139.         at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
  140.         at com.justep.report.controller.InitController.execute(Unknown Source)
  141.         at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
  142.         at com.justep.report.Servlet.a(Unknown Source)
  143.         at com.justep.report.Servlet.doPost(Unknown Source)
  144.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
  145.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  146.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  147.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  148.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  149.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  150.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  151.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  152.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  153.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  154.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  155.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  156.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  157.         at java.lang.Thread.run(Thread.java:595)
  158. Caused by: com.justep.report.exception.ReportServerException: 执行ksql:select SA_CeyuWorkTask.fManager as fManager,SA_CeyuWorkTask.fCeyuWorkTaskName as fCeyuWorkTaskName,SA_CeyuWorkTask.fCeyuWorkTaskDeadline as fCeyuWorkTaskDeadline,SA_CeyuWorkTask.fEndDate as fEndDate,SA_CeyuWorkTask.fKF as fKF,SA_CeyuWorkTask.fKFBFB as fKFBFB from SA_CeyuWorkTask SA_CeyuWorkTask where SA_CeyuWorkTask.fManager like concat('%', :id, '%') or SA_CeyuWorkTask.fTJRID like concat('%', :id, '%') or SA_CeyuWorkTask.fCeyuWorkTaskRecipientFIDs like concat('%', :id, '%') or SA_CeyuWorkTask.fYSRFID like concat('%', :id, '%') or SA_CeyuWorkTask.fRLZYFID like concat('%', :id, '%')时出错！
  159.         at com.justep.report.controller.DataController.a(Unknown Source)
  160.         at com.justep.report.controller.DataController.a(Unknown Source)
  161.         ... 20 more
  162. Caused by: java.lang.Exception
  163.         ... 22 more
  164. ksql:
  165. select SA_CeyuWorkTask.fManager as fManager,SA_CeyuWorkTask.fCeyuWorkTaskName as fCeyuWorkTaskName,SA_CeyuWorkTask.fCeyuWorkTaskDeadline as fCeyuWorkTaskDeadline,SA_CeyuWorkTask.fEndDate as fEndDate,SA_CeyuWorkTask.fKF as fKF,SA_CeyuWorkTask.fKFBFB as fKFBFB from SA_CeyuWorkTask SA_CeyuWorkTask where SA_CeyuWorkTask.fManager like concat('%', :id, '%') or SA_CeyuWorkTask.fTJRID like concat('%', :id, '%') or SA_CeyuWorkTask.fCeyuWorkTaskRecipientFIDs like concat('%', :id, '%') or SA_CeyuWorkTask.fYSRFID like concat('%', :id, '%') or SA_CeyuWorkTask.fRLZYFID like concat('%', :id, '%')
  166. 2014-05-15 13:48:46 invokeActions error！
  167. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
  168.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
  169.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
  170.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
  171.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  172.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
  173.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
  174.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  175.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
  176.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  177.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  178.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  179.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  180.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  181.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  182.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  183.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  184.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  185.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  186.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  187.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  188.         at java.lang.Thread.run(Thread.java:595)
  189. Caused by: java.lang.reflect.InvocationTargetException
  190.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  191.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  192.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  193.         at java.lang.reflect.Method.invoke(Method.java:592)
  194.         at com.justep.system.action.Engine.invokeActions(Native Method)
  195.         ... 21 more
  196. Caused by: com.justep.model.exception.ModelException: 执行ksql:select SA_CeyuWorkTask.fManager as fManager,SA_CeyuWorkTask.fCeyuWorkTaskName as fCeyuWorkTaskName,SA_CeyuWorkTask.fCeyuWorkTaskDeadline as fCeyuWorkTaskDeadline,SA_CeyuWorkTask.fEndDate as fEndDate,SA_CeyuWorkTask.fKF as fKF,SA_CeyuWorkTask.fKFBFB as fKFBFB from SA_CeyuWorkTask SA_CeyuWorkTask where SA_CeyuWorkTask.fManager like concat('%', :id, '%') or SA_CeyuWorkTask.fTJRID like concat('%', :id, '%') or SA_CeyuWorkTask.fCeyuWorkTaskRecipientFIDs like concat('%', :id, '%') or SA_CeyuWorkTask.fYSRFID like concat('%', :id, '%') or SA_CeyuWorkTask.fRLZYFID like concat('%', :id, '%')时出错！
  197.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  198.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  199.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  200.         at com.justep.system.data.KSQL.select(Unknown Source)
  201.         at Zhigao.taskReport(Zhigao.java:200)
  202.         ... 26 more
  203. Caused by: com.justep.model.exception.ModelException: 找不到变量：id对应的值！
  204.         at com.justep.util.Utils.check(Unknown Source)
  205.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  206.         at com.justep.system.ksql.node.VariableNode.accept(Unknown Source)
  207.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  208.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  209.         at com.justep.system.ksql.node.FunctionNode.accept(Unknown Source)
  210.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  211.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  212.         at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
  213.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  214.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  215.         at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
  216.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  217.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  218.         at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
  219.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  220.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  221.         at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
  222.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  223.         at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
  224.         at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
  225.         ... 31 more
  226. 2014-05-15 13:48:46 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
  227. <action direct-execute="true" process="/SA/zhigao/process/CeyuWorkTask/ceyuWorkTaskProcess" activity="taskReportActivity" action-flag="__action_0__" executor="" execute-context="" name="taskReportAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"><xbiz:map><item key="id"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">95D9B45628CA43DE9C3C0E626E20BB19</xbiz:simple></item></xbiz:map></parameter></parameters></action>
  228. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
  229.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
  230.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
  231.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
  232.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  233.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
  234.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
  235.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  236.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
  237.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  238.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  239.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  240.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  241.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  242.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  243.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  244.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  245.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  246.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  247.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  248.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  249.         at java.lang.Thread.run(Thread.java:595)
  250. Caused by: java.lang.reflect.InvocationTargetException
  251.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  252.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  253.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  254.         at java.lang.reflect.Method.invoke(Method.java:592)
  255.         at com.justep.system.action.Engine.invokeActions(Native Method)
  256.         ... 21 more
  257. Caused by: com.justep.model.exception.ModelException: 执行ksql:select SA_CeyuWorkTask.fManager as fManager,SA_CeyuWorkTask.fCeyuWorkTaskName as fCeyuWorkTaskName,SA_CeyuWorkTask.fCeyuWorkTaskDeadline as fCeyuWorkTaskDeadline,SA_CeyuWorkTask.fEndDate as fEndDate,SA_CeyuWorkTask.fKF as fKF,SA_CeyuWorkTask.fKFBFB as fKFBFB from SA_CeyuWorkTask SA_CeyuWorkTask where SA_CeyuWorkTask.fManager like concat('%', :id, '%') or SA_CeyuWorkTask.fTJRID like concat('%', :id, '%') or SA_CeyuWorkTask.fCeyuWorkTaskRecipientFIDs like concat('%', :id, '%') or SA_CeyuWorkTask.fYSRFID like concat('%', :id, '%') or SA_CeyuWorkTask.fRLZYFID like concat('%', :id, '%')时出错！
  258.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  259.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  260.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  261.         at com.justep.system.data.KSQL.select(Unknown Source)
  262.         at Zhigao.taskReport(Zhigao.java:200)
  263.         ... 26 more
  264. Caused by: com.justep.model.exception.ModelException: 找不到变量：id对应的值！
  265.         at com.justep.util.Utils.check(Unknown Source)
  266.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  267.         at com.justep.system.ksql.node.VariableNode.accept(Unknown Source)
  268.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  269.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  270.         at com.justep.system.ksql.node.FunctionNode.accept(Unknown Source)
  271.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  272.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  273.         at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
  274.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  275.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  276.         at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
  277.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  278.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  279.         at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
  280.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  281.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
  282.         at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
  283.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
  284.         at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
  285.         at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
  286.         ... 31 more
  287. [ERROR] 2014-05-15 13:48:46,609 com.justep.report.controller.DataController - 报表数据获取失败
  288. 执行ksql:select SA_CeyuWorkTask.fManager as fManager,SA_CeyuWorkTask.fCeyuWorkTaskName as fCeyuWorkTaskName,SA_CeyuWorkTask.fCeyuWorkTaskDeadline as fCeyuWorkTaskDeadline,SA_CeyuWorkTask.fEndDate as fEndDate,SA_CeyuWorkTask.fKF as fKF,SA_CeyuWorkTask.fKFBFB as fKFBFB from SA_CeyuWorkTask SA_CeyuWorkTask where SA_CeyuWorkTask.fManager like concat('%', :id, '%') or SA_CeyuWorkTask.fTJRID like concat('%', :id, '%') or SA_CeyuWorkTask.fCeyuWorkTaskRecipientFIDs like concat('%', :id, '%') or SA_CeyuWorkTask.fYSRFID like concat('%', :id, '%') or SA_CeyuWorkTask.fRLZYFID like concat('%', :id, '%')时出错！
  289. com.justep.report.exception.ReportServerException: 报表数据获取失败
  290.         at com.justep.report.controller.DataController.execute(Unknown Source)
  291.         at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
  292.         at com.justep.report.controller.InitController.execute(Unknown Source)
  293.         at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
  294.         at com.justep.report.Servlet.a(Unknown Source)
  295.         at com.justep.report.Servlet.doPost(Unknown Source)
  296.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
  297.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  298.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  299.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  300.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  301.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  302.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  303.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  304.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  305.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  306.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  307.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  308.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  309.         at java.lang.Thread.run(Thread.java:595)
  310. Caused by: com.justep.report.exception.ReportServerException: 执行ksql:select SA_CeyuWorkTask.fManager as fManager,SA_CeyuWorkTask.fCeyuWorkTaskName as fCeyuWorkTaskName,SA_CeyuWorkTask.fCeyuWorkTaskDeadline as fCeyuWorkTaskDeadline,SA_CeyuWorkTask.fEndDate as fEndDate,SA_CeyuWorkTask.fKF as fKF,SA_CeyuWorkTask.fKFBFB as fKFBFB from SA_CeyuWorkTask SA_CeyuWorkTask where SA_CeyuWorkTask.fManager like concat('%', :id, '%') or SA_CeyuWorkTask.fTJRID like concat('%', :id, '%') or SA_CeyuWorkTask.fCeyuWorkTaskRecipientFIDs like concat('%', :id, '%') or SA_CeyuWorkTask.fYSRFID like concat('%', :id, '%') or SA_CeyuWorkTask.fRLZYFID like concat('%', :id, '%')时出错！
  311.         at com.justep.report.controller.DataController.a(Unknown Source)
  312.         at com.justep.report.controller.DataController.a(Unknown Source)
  313.         ... 20 more
  314. Caused by: java.lang.Exception
  315.         ... 22 more
复制代码
创建action.jpg
action代码.jpg
回复

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35949
发表于 2014-5-15 14:34:43 | 显示全部楼层
ksql整个语句都是前台传过来的？不推荐在前台写sql
远程的联系方法QQ1392416607,添加好友时，需在备注里注明其论坛名字及ID，公司等信息
发远程时同时也发一下帖子地址，方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决，请及时跟帖，便于版主结贴
回复 支持 反对

使用道具 举报

133

主题

496

帖子

931

积分

高级会员

Rank: 4

积分
931
QQ
 楼主| 发表于 2014-5-15 14:40:40 | 显示全部楼层
jishuang 发表于 2014-5-15 14:34
ksql整个语句都是前台传过来的？不推荐在前台写sql

不是前台传的，创建action 的时候 ksql是默认值
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35949
发表于 2014-5-15 15:38:02 | 显示全部楼层
参考如下：
  1. public static Table parameter(String p) {

  3. String ksql = "select rq.fName as test from AP_RQ rq where rq.fRQ >:firstDateOfMonth(:toDate(:p))";

  5. HashMap<String, Object> params = new HashMap<String, Object>();
  6. params.put("p", p);
  7. Table table = KSQL.select(ksql, params, "/appdemo/test/data", null);
  8. return table;
  9. }
复制代码
action.png
远程的联系方法QQ1392416607,添加好友时，需在备注里注明其论坛名字及ID，公司等信息
发远程时同时也发一下帖子地址，方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决，请及时跟帖，便于版主结贴
回复 支持 反对

使用道具 举报

133

主题

496

帖子

931

积分

高级会员

Rank: 4

积分
931
QQ
 楼主| 发表于 2014-5-15 16:23:16 | 显示全部楼层
本帖最后由 mj19881029 于 2014-5-15 16:26 编辑
jishuang 发表于 2014-5-15 15:38
参考如下：

结贴吧

补充：可以从页面传参数到Action，根据参数是否为空，来动态生成条件，不使用占位符了~~搞不懂
参考例子：/UI/demo/report/process/property/parameterFilterReport.w
回复 支持 反对

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-5-24 15:06 , Processed in 0.084880 second(s), 28 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表