We have integrated Mondrian (Version: 2.3.2.8944) and JPivot for our client application and currently having problem in generating Excel report from current cube view. The problem occurs mainly when the cube is expanded for all dimensions and then clicked on Excel Icon (JPivot menu bar). The process takes too log to generate the Excel file and then in the middle, it fails.
When I checked the application log (Weblogic Server), it reported following error.
ERROR (RendererTag.java:159) - trouble rendering table01
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at weblogic.servlet.internal.ChunkOutput.writeChunkTransfer(ChunkOutput.java:525)
at weblogic.servlet.internal.ChunkOutput.writeChunks(ChunkOutput.java:504)
at weblogic.servlet.internal.ChunkOutput.flush(ChunkOutput.java:382)
at weblogic.servlet.internal.ChunkOutput.checkForFlush(ChunkOutput.java:469)
at weblogic.servlet.internal.ChunkOutput.write(ChunkOutput.java:304)
at weblogic.servlet.internal.ChunkOutputWrapper.write(ChunkOutputWrapper.java:133)
at weblogic.servlet.internal.ServletOutputStreamImpl.write(ServletOutputStreamImpl.java:168)
at weblogic.servlet.internal.WLOutputStreamWriter.writeBytes(WLOutputStreamWriter.java:168)
at weblogic.servlet.internal.WLOutputStreamWriter.write(WLOutputStreamWriter.java:129)
at weblogic.servlet.internal.WLOutputStreamWriter.write(WLOutputStreamWriter.java:113)
at weblogic.servlet.internal.DelegateChunkWriter.print(DelegateChunkWriter.java:118)
at weblogic.servlet.internal.ChunkOutputWrapper.print(ChunkOutputWrapper.java:146)
at weblogic.servlet.jsp.JspWriterImpl.write(JspWriterImpl.java:233)
at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:153)
at jsp_servlet.__olap_jpivot_page._jsp__tag58(__olap_jpivot_page.java:2961)
We also noticed that if we connect to application locally (In the same network where application web server resides), mostly it works. The problem occurs mainly for remote web user.
I also wants to ask that when I click on Excel icon, is it transferring data over the network from server to client while writing to the excel file OR it generates Excel file on the server first and then asks user to either open or save the file?
Please help us ASAP. Thanks in advance.
Kuldip
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
That 'broken pipe' error is expected behavior from a web server whenever the web client aborts its HTTP request. I presume that the client is timing out. I don't think there's a bug in jpivot - you need a faster network or perhaps a longer timeout.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We have integrated Mondrian (Version: 2.3.2.8944) and JPivot for our client application and currently having problem in generating Excel report from current cube view. The problem occurs mainly when the cube is expanded for all dimensions and then clicked on Excel Icon (JPivot menu bar). The process takes too log to generate the Excel file and then in the middle, it fails.
When I checked the application log (Weblogic Server), it reported following error.
ERROR (RendererTag.java:159) - trouble rendering table01
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at weblogic.servlet.internal.ChunkOutput.writeChunkTransfer(ChunkOutput.java:525)
at weblogic.servlet.internal.ChunkOutput.writeChunks(ChunkOutput.java:504)
at weblogic.servlet.internal.ChunkOutput.flush(ChunkOutput.java:382)
at weblogic.servlet.internal.ChunkOutput.checkForFlush(ChunkOutput.java:469)
at weblogic.servlet.internal.ChunkOutput.write(ChunkOutput.java:304)
at weblogic.servlet.internal.ChunkOutputWrapper.write(ChunkOutputWrapper.java:133)
at weblogic.servlet.internal.ServletOutputStreamImpl.write(ServletOutputStreamImpl.java:168)
at weblogic.servlet.internal.WLOutputStreamWriter.writeBytes(WLOutputStreamWriter.java:168)
at weblogic.servlet.internal.WLOutputStreamWriter.write(WLOutputStreamWriter.java:129)
at weblogic.servlet.internal.WLOutputStreamWriter.write(WLOutputStreamWriter.java:113)
at weblogic.servlet.internal.DelegateChunkWriter.print(DelegateChunkWriter.java:118)
at weblogic.servlet.internal.ChunkOutputWrapper.print(ChunkOutputWrapper.java:146)
at weblogic.servlet.jsp.JspWriterImpl.write(JspWriterImpl.java:233)
at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:153)
at jsp_servlet.__olap_jpivot_page._jsp__tag58(__olap_jpivot_page.java:2961)
We also noticed that if we connect to application locally (In the same network where application web server resides), mostly it works. The problem occurs mainly for remote web user.
I also wants to ask that when I click on Excel icon, is it transferring data over the network from server to client while writing to the excel file OR it generates Excel file on the server first and then asks user to either open or save the file?
Please help us ASAP. Thanks in advance.
Kuldip
That 'broken pipe' error is expected behavior from a web server whenever the web client aborts its HTTP request. I presume that the client is timing out. I don't think there's a bug in jpivot - you need a faster network or perhaps a longer timeout.