Broken pipe error

anahoz · July 9, 2008

Hi,

I hope somebody can help because I can't solve this issue.

I explain a bit the scenario in case it's useful: I have designed a report in ireport which does a lot of calculations (it's an accounting report for the company) and I launch this from my web application programmed in php. So we use web services to launch the pdf generated by ireport. Depending on the parameters passed to ireport the query to our mysql database is different, bigger or smaller.

I have no problem if we filter (through a select element) to show the report of a fixed department but if there's no selection made (we want to show the calculations for every department), this broken pipe error occurs. I assume this is due to the query is much bigger and the connection is broken but I'm not sure what can be the exact problem. Is something I must configure in mysql? In ireport? Where should I start to look out?

Please, any help or hint would be much appreciated! Thanks in advance.

BTW, this is the error shown in tomcat:

03:12:05,846 ERROR MimeUtils,http-8080-Processor25:206 - java.io.IOException:

ClientAbortException: java.net.SocketException: Broken pipe

at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:366)

at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:433)

at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:348)

at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:392)

at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:381)

at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:88)

at javax.activation.DataHandler.writeTo(DataHandler.java:308)

at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:1350)

at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:845)

at javax.mail.internet.MimeMultipart.writeTo(MimeMultipart.java:361)

at com.sun.mail.handlers.multipart_mixed.writeTo(multipart_mixed.java:85)

at javax.activation.ObjectDataContentHandler.writeTo(DataHandler.java:883)

at javax.activation.DataHandler.writeTo(DataHandler.java:316)

at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:1350)

at javax.mail.internet.MimeMessage.writeTo(MimeMessage.java:1683)

at org.apache.axis.attachments.MimeUtils.writeToMultiPartStream(MimeUtils.java:202)

at org.apache.axis.attachments.AttachmentsImpl.writeContentToStream(AttachmentsImpl.java:493)

at org.apache.axis.Message.writeTo(Message.java:545)

at org.apache.axis.transport.http.AxisServlet.sendResponse(AxisServlet.java:902)

at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:777)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)

at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)