Hi POI Support Team,
We are also looking support for the same issue, Our team member has raised
the below bug for the issue when we open huge size excel, the bug is
concluded that the fix would be available in POI-4.0.
So, we have upgraded from 3.9 to 4.0, but we are getting attached error
while generate huge size of file (0.5 million rows & 160 column).
The server is having sufficient memory to hold the data.
Heap memory - 6GB
RAM - 8 GB
So, we need your support to resolve this issue and can able to generate
huge size file.
Let me know if you need further detail on this.
Thank you.
Regards,
V. Dillibabu
On Thu, Dec 20, 2018 at 5:49 AM Andreas Reichel <
[email protected]> wrote:
> Good Morning,
>
> it is related to 4 GB size limits and the use of ZIP64, please see
> https://bz.apache.org/bugzilla/show_bug.cgi?id=62872
> My understanding is, that you can enforce the use of ZIP64 now although
> you have decide by yourself when to switch it on. Also ZIP64 is not
> supported by LibreOffice. Gnumeric works fine, I do not know about
> Excel.
>
> Best regards
> Andreas
>
>
> On Thu, 2018-12-20 at 05:30 +0000, dillibabu venugopal wrote:
> > Hi All,
> >
> >
> > We are upgrading poi version from 3.9 to 4.0 for fixing an
> > issue, which released in 4.0. The ticket details is given below for
> > your
> > reference.
> >
> >
> > Bug Request : https://bz.apache.org/bugzilla/show_bug.cgi?id=61832
> >
> >
> >
> > Before upgrade:
> >
> >
> > Jar: poi-ooxml-3.9
> >
> >
> > After Upgrade:
> >
> >
> > poi-4.0.0
> > poi-ooxml-4.0.0
> >
> >
> > xmlbeans-3.0.1
> >
> >
> > poi-shared-string-1.0.0
> >
> >
> > h2-1.4.197
> >
> >
> >
> >
> >
> > After upgraded POI
> > version to 4.0,we are able to generate excel report and download it
> > in browser
> > until 0.2 million rows with 160 columns. But it is not working when
> > we try for
> > 0.5 million rows with 160 columns and getting below h2 database
> > error. The
> > error file is attached along with this email.
> >
> >
> >
> >
> >
> > So, I request you this issue and help us to fix it in our
> > application.
> > Let me know if you need any further details on this.
> >
> >
> >
> > Thank you for your support.
> >
> > -------------------------------------------------------------------
> > --To unsubscribe, e-mail: [email protected]
> > For additional commands, e-mail: [email protected]
>
>
>
--
Regards,
V. Dillibabu
[2018-Dec-06 06:43:26.815] [ERROR]
[com.nissan.vinpipe.business.restimplementation.RestImplementation] [process]
[x367360] Exception : Chunk 204 no longer exists [1.4.197/9]
java.lang.IllegalStateException: Chunk 204 no longer exists [1.4.197/9]
at
org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:870)
at org.h2.mvstore.MVStore.getChunkIfFound(MVStore.java:919)
at org.h2.mvstore.MVStore.getChunk(MVStore.java:901)
at org.h2.mvstore.MVStore.readPage(MVStore.java:1927)
at org.h2.mvstore.MVMap.readPage(MVMap.java:698)
at org.h2.mvstore.Page.getChildPage(Page.java:208)
at org.h2.mvstore.Cursor.fetchNext(Cursor.java:150)
at org.h2.mvstore.Cursor.next(Cursor.java:50)
at org.h2.mvstore.MVMap$2$1.next(MVMap.java:841)
at org.h2.mvstore.MVMap$2$1.next(MVMap.java:832)
at java.util.AbstractMap$2$1.next(AbstractMap.java:418)
at
com.github.pjfanning.poi.xssf.streaming.TempFileSharedStringsTable.writeTo(TempFileSharedStringsTable.java:261)
at
org.apache.poi.xssf.model.SharedStringsTable.commit(SharedStringsTable.java:286)
at
org.apache.poi.ooxml.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:462)
at
org.apache.poi.ooxml.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:467)
at
org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:236)
at
org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:930)
at
com.nissan.vinpipe.business.restimplementation.RestImplementation.process(RestImplementation.java:176)
at
com.nissan.vinpipe.service.RsController.process(RsController.java:70)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168)
at
org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269)
at
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227)
at
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216)
at
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:560)
at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:542)
at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:130)
at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)
at
org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.event(JBossWebContext.java:91)
at
org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.invoke(JBossWebContext.java:72)
at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:559)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
at
org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:490)
at
org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:420)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926)
at java.lang.Thread.run(Thread.java:745)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
