报表数据量大于1万时报错，8000多行加载要30秒左右不报错

crazyz · 发表于 2017-5-11 15:55:33

报表数据量大于1万时报错，8000多行加载要30秒左右不报错，报表中就6列

序号

姓名

身份证号

银行名称

账号

金额

，无计算。UIServer错误URI：/x5/UI2/v_f57b334720d24df6836343fd250b7de1l_zh_CNs_compactd_pc/system/service/report/reportBrowse.j错误码：500错误信息：javax.servlet.ServletException: 报表服务请求失败
[url=]隐藏错误详细[/url]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: javax.servlet.ServletException: 报表服务请求失败 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 moreCaused by: java.lang.UnsupportedOperationException: 请求报表服务器失败[http://localhost:8080/ReportServer/reportservice?bsessionid=163E8F1FF66FFD9CD4A8EDE7814ECA10]:<html><head><title>Apache Tomcat/6.0.41 - Error report</title><style></style> </head><body><h1>HTTP Status 500 - Servlet execution threw an exception</h1><HR size="1" noshade="noshade">type Exception reportmessage Servlet execution threw an exceptiondescription The server encountered an internal error that prevented it from fulfilling this request.exception <pre>javax.servlet.ServletException: Servlet execution threw an exception</pre>root cause <pre>java.lang.OutOfMemoryError: Java heap space</pre>note The full stack trace of the root cause is available in the Apache Tomcat/6.0.41 logs.<HR size="1" noshade="noshade"><h3>Apache Tomcat/6.0.41</h3></body></html> ... 24 more

jishuang · 发表于 2017-5-11 16:29:26

把tomcat控制台的完整错误信息发一下，数据量大应该是慢，不应该报请求失败

crazyz · 发表于 2017-5-11 16:54:29

慢倒没事，只要能出来10分钟都行啊。Sql 查询不到0.01秒。报表加载不到1分钟的时候就报错。
五月 11, 2017 4:53:06 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet reportServerServlet threw exception
java.lang.OutOfMemoryError: Java heap space

2017-05-11 16:53:06 报表服务请求失败
javax.servlet.ServletException: javax.servlet.ServletException: 报表服务请求失败
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: 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)
... 17 more
Caused by: javax.servlet.ServletException: 报表服务请求失败
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
Caused by: java.lang.UnsupportedOperationException: 请求报表服务器失败[http://localhost:8080/ReportServer/reportservice?bsessionid=163E8F1FF66FFD9CD4A8EDE7814ECA10]:<html><head><title>Apache Tomcat/6.0.41 - Error report</title><style></style> </head><body><h1>HTTP Status 500 - Servlet execution threw an exception</h1><HR size="1" noshade="noshade">type Exception reportmessage Servlet execution threw an exceptiondescription The server encountered an internal error that prevented it from fulfilling this request.exception <pre>javax.servlet.ServletException: Servlet execution threw an exception
</pre>root cause <pre>java.lang.OutOfMemoryError: Java heap space
</pre>note The full stack trace of the root cause is available in the Apache Tomcat/6.0.41 logs.<HR size="1" noshade="noshade"><h3>Apache Tomcat/6.0.41</h3></body></html>
... 24 more
五月 11, 2017 4:53:06 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
java.lang.UnsupportedOperationException: 请求报表服务器失败[http://localhost:8080/ReportServer/reportservice?bsessionid=163E8F1FF66FFD9CD4A8EDE7814ECA10]:<html><head><title>Apache Tomcat/6.0.41 - Error report</title><style></style> </head><body><h1>HTTP Status 500 - Servlet execution threw an exception</h1><HR size="1" noshade="noshade">type Exception reportmessage Servlet execution threw an exceptiondescription The server encountered an internal error that prevented it from fulfilling this request.exception <pre>javax.servlet.ServletException: Servlet execution threw an exception
</pre>root cause <pre>java.lang.OutOfMemoryError: Java heap space
</pre>note The full stack trace of the root cause is available in the Apache Tomcat/6.0.41 logs.<HR size="1" noshade="noshade"><h3>Apache Tomcat/6.0.41</h3></body></html>
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)
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)

jishuang · 发表于 2017-5-11 17:21:26

java.lang.OutOfMemoryError: Java heap space
内存溢出了

jdk用的是64位的吗？把tomcat中jvm的内存配置调大点看看

crazyz · 发表于 2017-5-11 17:46:09

这应该是64位的吧

jishuang · 发表于 2017-5-11 17:53:07

是64

crazyz · 发表于 2017-5-11 17:58:55

我将原来的256 改为 512，512改为了1024

jishuang · 发表于 2017-5-12 09:01:08

直接到tomcat的bin目录下用startup.bat启动服务器
apache-tomcat\bin目录下的catalina.bat文件，修改JAVA_OPTS中的配置
64位操作JDK内存系统：所有服务的最大内存累加的和不大于物理内存的60%到80%。

crazyz · 发表于 2017-5-13 13:02:47

8G内存，最大改为4096了，还是不行，原来是1024，改大了这么多，好几G，一个报表怎么会耗这多么内存呢
set JAVA_OPTS=-Xms512m -Xmx4096m -XX

ermSize=256M -XX:MaxNewSize=512m -XX:MaxPermSize=512m -Dcom.sun.management.jmxremote -Djava.awt.headless=true

tiger_lixy · 发表于 2017-5-13 13:49:44

8000多条出报表本身业务设计有问题吧？sql能查出来但他不是全塞内存了只是显示一些数据。推荐修改下业务设计

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

[结贴] 报表数据量大于1万时报错，8000多行加载要30秒左右不报错