Hi , Thank you for your response,
I will try with your advice and come back to you if I need further assistance on this. Thank you Regards, V. Dillibabu On Thu, Dec 20, 2018 at 4:29 AM Andreas Reichel < [email protected]> wrote: > Good Morning again, > > it looks we are working on very similar stuff as we trigger the same > issues: > > java.lang.IllegalStateException: Chunk 204 no longer exists [1.4.197/9] > at > org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:870) > > The error message above is from H2 itself and (very likely) has nothing > to do with Apache POI in particular. > H2 1.4.197 is still under heavy development and it was quite unstable > for me until 1-2 months ago. I experienced lock-ups and error messages > like that. > > Although I compiled a snapshot of the GIT repository a few weeks ago > which seems to be fast and stable. So my advice is to pull a recent > snapshot and compile it yourself and then to try again with Apache POI. > > Best regards > Andreas > > On Thu, 2018-12-20 at 06:16 +0000, dillibabu venugopal wrote: > > 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] > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------- > > --To unsubscribe, e-mail: [email protected] > > For additional commands, e-mail: [email protected] > > > -- Regards, V. Dillibabu
