使用 sqlAction 多租户主从报表查询报错

jishuang · 发表于 2016-2-29 14:44:14

在action对应的java的table返回前用下面的输出把table内容输出出来
System.out.println(new com.justep.system.transform.Table2Row().transform(table,null).asXML());

然后把excel文件和输出的内容都发一下

southpine · 发表于 2016-2-29 16:15:22

不知道什么原因，控制台根本没有输出。可能是不有执行java方法。

jishuang · 发表于 2016-2-29 17:55:09

平台的主从案例也是报的你8楼发的错误吗？

southpine · 发表于 2016-3-1 08:04:01

平台的主从案例不报错，只有表格，没有数据。

southpine · 发表于 2016-3-1 09:06:31

隐藏错误详细

javax.servlet.ServletException: 报表服务请求失败
at ReportBrowse.doPost(ReportBrowse.java:23)
at com.justep.ui.impl.JProcessorImpl.execute(Unknown Source)
at com.justep.ui.JavaServer.runJava(Unknown Source)
at com.justep.ui.JavaServer.doJ(Unknown Source)
at com.justep.ui.JavaServer.service(Native Method)
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: org.dom4j.DocumentException: Error on line 1 of document : 前言中不允许有内容。 Nested exception: 前言中不允许有内容。
at org.dom4j.io.SAXReader.read(SAXReader.java:482)
at org.dom4j.io.SAXReader.read(SAXReader.java:365)
at com.justep.ui.system.service.report.ReportJSONHelper.getElementFromCacheFile(Unknown Source)
at com.justep.ui.system.service.report.ReportJSONHelper.execute(Unknown Source)
at com.justep.ui.system.service.report.ReportHelper.call(Unknown Source)
at com.justep.ui.system.service.report.ReportHelper.service(Unknown Source)
at ReportBrowse.doPost(ReportBrowse.java:21)
... 21 more

jishuang · 发表于 2016-3-1 09:57:56

把excel文件和xml文件发一下

southpine · 发表于 2016-3-1 10:45:28

print.rar (7.07 KB, 下载次数: 101)

southpine · 发表于 2016-3-1 10:56:41

我看了一下案例java代码，一次请求，运行了4次。不知为什么？

southpine · 发表于 2016-3-1 11:01:34

本帖最后由 southpine 于 2016-3-1 11:02 编辑

这是案例控制台输出的（结果数据还是没有）：
这个主表的条件，我去掉了2个ID，只保留DEMO_REPORTORDERDETAILS.RORDERID ='10590'。

2016-03-01 10:49:45 开始-WINDOW生成中间文件: /UI2/portal/pc/index.w
2016-03-01 10:49:45 结束-WINDOW生成中间文件: /UI2/portal/pc/index.w
2016-03-01 10:49:45 开始-中间文件生成缓存文件: /UI2/portal/pc/index.w
2016-03-01 10:49:46 结束-中间文件生成缓存文件: /UI2/portal/pc/index.w
2016-03-01 10:49:48 开始-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2016-03-01 10:49:48 结束-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2016-03-01 10:49:48 开始-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2016-03-01 10:49:49 结束-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2016-03-01 10:49:50 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2016-03-01 10:49:50 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2016-03-01 10:49:50 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2016-03-01 10:49:51 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2016-03-01 10:49:51 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2016-03-01 10:49:52 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2016-03-01 10:49:52 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2016-03-01 10:49:53 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2016-03-01 10:49:56 开始-WINDOW生成中间文件: /UI2/demo/report/process/multidataset/masterDetailReport.w
2016-03-01 10:49:57 结束-WINDOW生成中间文件: /UI2/demo/report/process/multidataset/masterDetailReport.w
2016-03-01 10:49:57 开始-中间文件生成缓存文件: /UI2/demo/report/process/multidataset/masterDetailReport.w
2016-03-01 10:49:57 结束-中间文件生成缓存文件: /UI2/demo/report/process/multidataset/masterDetailReport.w
==================================masterDetailQuery2==========================
<rows><userdata name="model">/demo/report/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,Decimal,Integer,Decimal,String</userdata><userdata name="relation-alias">rOrderID,rUnitPrice,rQuantity,rDiscount,RPRODUCTNAME</userdata><row><userdata name="recordState"/><cell><![CDATA[10590]]></cell><cell><![CDATA[18.0000000000000]]></cell><cell><![CDATA[20]]></cell><cell><![CDATA[0E-13]]></cell><cell><![CDATA[苹果汁]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[10590]]></cell><cell><![CDATA[13.0000000000000]]></cell><cell><![CDATA[60]]></cell><cell><![CDATA[0.0500000010000]]></cell><cell><![CDATA[辣椒粉]]></cell></row></rows>
==================================masterDetailQuery1==========================
<rows><userdata name="model">/demo/report/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,String,String,String,String,String,String,String,String,String</userdata><userdata name="relation-alias">rOrderID,rShipName,RCONTACTNAME,RNAME,RORDERDATE,RREQUIREDDATE,RSHIPPEDDATE,rShipCountry,rShipCity,rShipPostalCode</userdata><row><userdata name="recordState"/><cell><![CDATA[10590]]></cell><cell><![CDATA[刘维国]]></cell><cell><![CDATA[吴小姐]]></cell><cell><![CDATA[郑建杰]]></cell><cell><![CDATA[1997-07-07]]></cell><cell><![CDATA[1997-08-04]]></cell><cell><![CDATA[1997-07-14]]></cell><cell><![CDATA[中国]]></cell><cell><![CDATA[天津]]></cell><cell><![CDATA[687574]]></cell></row></rows>
==================================masterDetailQuery2==========================
<rows><userdata name="model">/demo/report/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,Decimal,Integer,Decimal,String</userdata><userdata name="relation-alias">rOrderID,rUnitPrice,rQuantity,rDiscount,RPRODUCTNAME</userdata><row><userdata name="recordState"/><cell><![CDATA[10590]]></cell><cell><![CDATA[18.0000000000000]]></cell><cell><![CDATA[20]]></cell><cell><![CDATA[0E-13]]></cell><cell><![CDATA[苹果汁]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[10590]]></cell><cell><![CDATA[13.0000000000000]]></cell><cell><![CDATA[60]]></cell><cell><![CDATA[0.0500000010000]]></cell><cell><![CDATA[辣椒粉]]></cell></row></rows>
==================================masterDetailQuery1==========================
<rows><userdata name="model">/demo/report/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,String,String,String,String,String,String,String,String,String</userdata><userdata name="relation-alias">rOrderID,rShipName,RCONTACTNAME,RNAME,RORDERDATE,RREQUIREDDATE,RSHIPPEDDATE,rShipCountry,rShipCity,rShipPostalCode</userdata><row><userdata name="recordState"/><cell><![CDATA[10590]]></cell><cell><![CDATA[刘维国]]></cell><cell><![CDATA[吴小姐]]></cell><cell><![CDATA[郑建杰]]></cell><cell><![CDATA[1997-07-07]]></cell><cell><![CDATA[1997-08-04]]></cell><cell><![CDATA[1997-07-14]]></cell><cell><![CDATA[中国]]></cell><cell><![CDATA[天津]]></cell><cell><![CDATA[687574]]></cell></row></rows>
==================================masterDetailQuery2==========================
<rows><userdata name="model">/demo/report/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,Decimal,Integer,Decimal,String</userdata><userdata name="relation-alias">rOrderID,rUnitPrice,rQuantity,rDiscount,RPRODUCTNAME</userdata><row><userdata name="recordState"/><cell><![CDATA[10590]]></cell><cell><![CDATA[18.0000000000000]]></cell><cell><![CDATA[20]]></cell><cell><![CDATA[0E-13]]></cell><cell><![CDATA[苹果汁]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[10590]]></cell><cell><![CDATA[13.0000000000000]]></cell><cell><![CDATA[60]]></cell><cell><![CDATA[0.0500000010000]]></cell><cell><![CDATA[辣椒粉]]></cell></row></rows>
==================================masterDetailQuery1==========================
<rows><userdata name="model">/demo/report/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,String,String,String,String,String,String,String,String,String</userdata><userdata name="relation-alias">rOrderID,rShipName,RCONTACTNAME,RNAME,RORDERDATE,RREQUIREDDATE,RSHIPPEDDATE,rShipCountry,rShipCity,rShipPostalCode</userdata><row><userdata name="recordState"/><cell><![CDATA[10590]]></cell><cell><![CDATA[刘维国]]></cell><cell><![CDATA[吴小姐]]></cell><cell><![CDATA[郑建杰]]></cell><cell><![CDATA[1997-07-07]]></cell><cell><![CDATA[1997-08-04]]></cell><cell><![CDATA[1997-07-14]]></cell><cell><![CDATA[中国]]></cell><cell><![CDATA[天津]]></cell><cell><![CDATA[687574]]></cell></row></rows>
==================================masterDetailQuery2==========================
<rows><userdata name="model">/demo/report/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,Decimal,Integer,Decimal,String</userdata><userdata name="relation-alias">rOrderID,rUnitPrice,rQuantity,rDiscount,RPRODUCTNAME</userdata><row><userdata name="recordState"/><cell><![CDATA[10590]]></cell><cell><![CDATA[18.0000000000000]]></cell><cell><![CDATA[20]]></cell><cell><![CDATA[0E-13]]></cell><cell><![CDATA[苹果汁]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[10590]]></cell><cell><![CDATA[13.0000000000000]]></cell><cell><![CDATA[60]]></cell><cell><![CDATA[0.0500000010000]]></cell><cell><![CDATA[辣椒粉]]></cell></row></rows>
==================================masterDetailQuery1==========================
<rows><userdata name="model">/demo/report/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,String,String,String,String,String,String,String,String,String</userdata><userdata name="relation-alias">rOrderID,rShipName,RCONTACTNAME,RNAME,RORDERDATE,RREQUIREDDATE,RSHIPPEDDATE,rShipCountry,rShipCity,rShipPostalCode</userdata><row><userdata name="recordState"/><cell><![CDATA[10590]]></cell><cell><![CDATA[刘维国]]></cell><cell><![CDATA[吴小姐]]></cell><cell><![CDATA[郑建杰]]></cell><cell><![CDATA[1997-07-07]]></cell><cell><![CDATA[1997-08-04]]></cell><cell><![CDATA[1997-07-14]]></cell><cell><![CDATA[中国]]></cell><cell><![CDATA[天津]]></cell><cell><![CDATA[687574]]></cell></row></rows>

jishuang · 发表于 2016-3-1 14:21:10

把数据库的连接先用默认带的mysql，不设置多租户的正确吗？
用下面的excel和xml文件看看

		自动登录	找回密码
密码			注册

[结贴] 使用 sqlAction 多租户主从报表查询 报错

[结贴] 使用 sqlAction 多租户主从报表查询报错