Focal Point
[SOLVED] PCHOLD FORMAT EXL07 - corrupt file generated - Java error

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9737078786

September 27, 2017, 01:05 PM
Francis Mariani
[SOLVED] PCHOLD FORMAT EXL07 - corrupt file generated - Java error
I am debugging a program that generates an Excel 2007 report. The file it creates cannot open in Excel 2007 or 2016. Examining the generated file in a text editor revealed a Java error: it appears the error is a “Java heap space” memory error on the WebSphere server – perhaps the “maximum heap size” can be increased. If I reduce the number of rows to around 750, the program generates the Excel file properly.

I want to make sure that WebFOCUS is not causing the Java error - that it truly is a Java heap space error.

<H1>Error Page Exception</H1>
<H4>SRVE0260E: The server cannot use the error page specified for your application to handle the Original Exception printed below.</H4>
<BR><H3>Original Exception: </H3>
[b]Error Message: [/b]java.lang.OutOfMemoryError: Java heap space<BR>
[b]Error Code: [/b]500<BR>
[b]Target Servlet: [/b]<BR>
[b]Error Stack: [/b]<BR>java.lang.OutOfMemoryError: Java heap space
<BR> at java.lang.String.<init>(String.java:304)
<BR> at com.ibm.wsspi.webcontainer.util.RequestUtils.parseName(RequestUtils.java:377)
<BR> at com.ibm.wsspi.webcontainer.util.RequestUtils.parseQueryString(RequestUtils.java:215)
<BR> at com.ibm.ws.webcontainer.servlet.RequestUtils.parsePostData(RequestUtils.java:356)
<BR> at com.ibm.ws.webcontainer.srt.SRTServletRequest.parseParameters(SRTServletRequest.java:2052)
<BR> at com.ibm.ws.webcontainer.srt.SRTServletRequest.getParameter(SRTServletRequest.java:1652)
<BR> at com.ibi.srv.excel.ExcelZipServlet.doGet(ExcelZipServlet.java:73)
<BR> at com.ibi.srv.excel.ExcelZipServlet.doPost(ExcelZipServlet.java:119)
<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1661)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1602)
<BR> at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:149)
<BR> at com.ibi.filters.PKIFilter.doFilter(PKIFilter.java:94)
<BR> at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
<BR> at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:125)
<BR> at com.ibi.monitor.URLFilter.doFilter(URLFilter.java:80)
<BR> at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
<BR> at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:125)
<BR> at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:80)
<BR> at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)
<BR> at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
<BR> at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:878)
<BR> at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)
<BR> at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191)
<BR> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453)
<BR> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)
<BR> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306)
<BR> at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:84)
<BR> at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
<BR> at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
<BR> at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
<BR> at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
<BR> at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
<BR> at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
<BR> at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
<BR> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1656)
<BR>
<BR>
<BR><BR><H3>Error Page Exception: </H3>
[b]Error Message: [/b]java.lang.IllegalStateException: SRVE0199E: OutputStream already obtained<BR>
[b]Error Code: [/b]0<BR>
[b]Target Servlet: [/b]<BR>
[b]Error Stack: [/b]<BR>java.lang.IllegalStateException: SRVE0199E: OutputStream already obtained
<BR> at com.ibm.ws.webcontainer.srt.SRTServletResponse.getWriter(SRTServletResponse.java:744)
<BR> at org.apache.jasper.runtime.JspWriterImpl.initOut(JspWriterImpl.java:201)
<BR> at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(JspWriterImpl.java:189)
<BR> at org.apache.jasper.runtime.PageContextImpl.release(PageContextImpl.java:262)
<BR> at org.apache.jasper.runtime.JspFactoryImpl.internalReleasePageContext(JspFactoryImpl.java:177)
<BR> at org.apache.jasper.runtime.JspFactoryImpl.releasePageContext(JspFactoryImpl.java:144)
<BR> at com.ibm._jsp._applicationErrorPage._jspService(_applicationErrorPage.java:113)
<BR> at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:99)
<BR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1661)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1602)
<BR> at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:113)
<BR> at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:80)
<BR> at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)
<BR> at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:121)
<BR> at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:259)
<BR> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:374)
<BR> at com.ibm.ws.webcontainer.webapp.WebApp.sendError(WebApp.java:3388)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:1108)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507)
<BR> at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)
<BR> at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
<BR> at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:878)
<BR> at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)
<BR> at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191)
<BR> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453)
<BR> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)
<BR> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306)
<BR> at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:84)
<BR> at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
<BR> at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
<BR> at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
<BR> at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
<BR> at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
<BR> at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
<BR> at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
<BR> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1656)

This message has been edited. Last edited by: Francis Mariani,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
September 27, 2017, 01:15 PM
Mike Williams
Hi Francis,

I'm assuming you might have already checked this, but this thread seems similar to your issue:

http://forums.informationbuild...137063576#4137063576


WF Version 8105
September 27, 2017, 02:09 PM
Francis Mariani
Thank Mike - I did come across a couple of posts, including your suggestion.

It seems restarting either the WebFOCUS Client server or the WebSphere server solved the problem - the admin is unfortunately short on details.

Cheers.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
September 27, 2017, 02:48 PM
Francis Mariani
Since the WebFOCUS Client server and the WebSphere server are on the same machine (which I find surprising) the machine reboot restarted both servers, so I can't tell which one was the culprit, but I think it was IBM WebSphere.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server