主从从报表问题，请及时解答，谢谢！

Yawn

版本：BeX5_V3.3如题
问题描述：
当我设置rData3和rData5为主从表的时候，就会报错

浏览器界面错误提示：
加载text!/x5/UI2/v_f860badc29c14a2a8258aef76da0abefl_zh_CNs_desktopd_pc/xazx_project/GradeThree/process/allScoreStatic/mainActivity.w?$pageType=view出错
编码：JUSTEP230103
[url=]隐藏详细[/url]
Error: {"code":"JUSTEP230103","message":"加载text!/x5/UI2/v_f860badc29c14a2a8258aef76da0abefl_zh_CNs_desktopd_pc/xazx_project/GradeThree/process/allScoreStatic/mainActivity.w?$pageType=view出错"} at Object.l.create (http://127.0.0.1:8080/x5/UI2/v_4 ... re.min.js:65:215121) at Object.<anonymous> (http://127.0.0.1:8080/x5/UI2/v_4 ... re.min.js:65:276149) at f (http://127.0.0.1:8080/x5/UI2/v_4 ... ore.min.js:65:42352) at Object.l.fireWith (http://127.0.0.1:8080/x5/UI2/v_4 ... ore.min.js:65:43177) at Object.<anonymous> (http://127.0.0.1:8080/x5/UI2/v_4 ... ore.min.js:65:43858) at f (http://127.0.0.1:8080/x5/UI2/v_4 ... ore.min.js:65:42352) at Object.l.fireWith (http://127.0.0.1:8080/x5/UI2/v_4 ... ore.min.js:65:43177) at Object.i.(anonymous function) [as reject] (http://127.0.0.1:8080/x5/UI2/v_4 ... ore.min.js:65:44157) at Object.errback (http://127.0.0.1:8080/x5/UI2/v_4 ... re.min.js:65:274500) at http://127.0.0.1:8080/x5/UI2/v_a ... re.2.1.10.js:398:23


控制台错误提示：

javax.servlet.ServletException: java.lang.RuntimeException: Excel生成报表定义失败，文件名：D:/BeX5_V3/model/UI2/xazx_project/GradeThree/process/allScoreStatic/absentScore.xml
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: Excel生成报表定义失败，文件名：D:/BeX5_V3/model/UI2/xazx_project/GradeThree/process/allScoreStatic/absentScore.xml
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at Report.generateReportDoc(Report.java:339)
        at Report.generateReportDefine(Report.java:311)
        at Report.execute(Report.java:67)
        at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
        at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler2.compile(Unknown Source)
        at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
        at com.justep.ui.WindowServer2.service(Unknown Source)
        ... 17 more
Caused by: java.lang.RuntimeException: Excel生成报表定义失败
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        ... 29 more
Caused by: java.lang.IndexOutOfBoundsException: Index: 4, Size: 2
        at java.util.ArrayList.rangeCheck(ArrayList.java:635)
        at java.util.ArrayList.get(ArrayList.java:411)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.scanRows(Unknown Source)
        at com.justep.report.xls.XLSTransContent.transform(Unknown Source)
        ... 30 more
2016-05-07 17:35:15 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
五月 07, 2016 5:35:15 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
java.lang.IndexOutOfBoundsException: Index: 4, Size: 2
        at java.util.ArrayList.rangeCheck(ArrayList.java:635)
        at java.util.ArrayList.get(ArrayList.java:411)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.scanRows(Unknown Source)
        at com.justep.report.xls.XLSTransContent.transform(Unknown Source)
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at Report.generateReportDoc(Report.java:339)
        at Report.generateReportDefine(Report.java:311)
        at Report.execute(Report.java:67)
        at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
        at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler2.compile(Unknown Source)
        at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
        at com.justep.ui.WindowServer2.service(Unknown Source)
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)


已上传excel文件和Table打印

主从从报表问题.zip (6.63 KB, 下载次数: 280)

2016-5-7 17:28 上传

点击文件名下载附件
主从从报表问题

jishuang

先把下面的那个主从去掉看看，上面的那个是报错

报表中多个数据源的时候要注意，如果多个数据源中有相同名字的字段的时候，要在java的ksql或者sql中设置为不同的别名，不能有相同的出现

Yawn

jishuang 发表于 2016-5-9 11:10
先把下面的那个主从去掉看看，上面的那个是报错

报表中多个数据源的时候要注意，如果多个数据源中有相同名 ...

我把所有的重复字段都给改了，现在没有一条是重复字段了，但是还是报错

浏览器没有弹出报错了：界面只是提示
报表执行错误：转换数据失败

控制台报错：
Error at /xsl:stylesheet/xsl:template[1]/xsl:element[1]/xsl:element[1]/xsl:element[1]/xsl:for-each-group[1]/xsl:if[1]/xsl:element[1]/xsl:for-each-group[1]
  XPST0008: XPath syntax error at char 47 on line -1 in {...a2']/record[type=$rData4/ty...}:
    Variable $rData4 has not been declared
[ERROR] 2016-05-09 16:42:02,214 com.justep.report.controller.ReportController - 报表执行失败
转换数据失败
com.justep.report.exception.ReportServerException: 转换数据失败
        at com.justep.report.controller.ReportController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.DataController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.InitController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.Servlet.a(Unknown Source)
        at com.justep.report.Servlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.report.data.ReportDataTransformException: 转换数据失败
        at com.justep.report.data.ReportDataTransformer.a(Unknown Source)
        at com.justep.report.data.ReportDataTransformer.transform(Unknown Source)
        at com.justep.report.core.XReportHelper.executeXReport(Unknown Source)
        ... 22 more
Caused by: javax.xml.transform.TransformerConfigurationException: Failed to compile stylesheet. 1 error detected.
        at net.sf.saxon.PreparedStylesheet.prepare(PreparedStylesheet.java:176)
        at net.sf.saxon.TransformerFactoryImpl.newTemplates(TransformerFactoryImpl.java:139)
        ... 25 more
现在这种情况怎么处理？

jishuang

只留一个主从的也会报错？

Yawn

jishuang 发表于 2016-5-9 17:30
只留一个主从的也会报错？

设置一个主从不会啊，我设置了主从从的，目前怎么关联rData1、rData2、rData3直接的主从关系？
Data2能做到既能做主表又能做从表吗？

jishuang

可以，参考/UI2/demo/report/process/multidataset/masterDDDReport.w

Yawn

jishuang 发表于 2016-5-9 17:59
可以，参考/UI2/demo/report/process/multidataset/masterDDDReport.w

我这边本地再测一测，目前此功能我是用sql拼接好的

Yawn

没有成功，继续沿用sql拼接好的数据

jishuang

可以先一个一个单独设置测试成功后，在设置多个从的

Yawn

jishuang 发表于 2016-5-12 16:34
可以先一个一个单独设置测试成功后，在设置多个从的

一直都是这样，一个一个设置再测试的，卡在后面设置第二个和三个的主从关系上面