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. Regards, V. Dillibabu --------------------------------------------------------------------- To unsubscribe, e-mail: [hidden email] For additional commands, e-mail: [hidden email] |
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: [hidden email] > For additional commands, e-mail: [hidden email] |
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 <[hidden email]> wrote: Good Morning, Regards,
V. Dillibabu --------------------------------------------------------------------- To unsubscribe, e-mail: [hidden email] For additional commands, e-mail: [hidden email] |
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 < > [hidden email]> 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: [hidden email] > > > > > For additional commands, e-mail: [hidden email] > > > > > > > > > > > > > ------------------------------------------------------------------- > --To unsubscribe, e-mail: [hidden email] > For additional commands, e-mail: [hidden email] |
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 < [hidden email]> 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 < > > [hidden email]> 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: [hidden email] > > > > > > > For additional commands, e-mail: [hidden email] > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------- > > --To unsubscribe, e-mail: [hidden email] > > For additional commands, e-mail: [hidden email] > > > -- Regards, V. Dillibabu |
Hi ,
The issue we have faced is already reported by us as a bug in apache bugzilla, ref -61832. And team is suggesting us to use Shared Strings instead of Inline strings. And we have used the POI-Shared Strings jar (1.0.x) along with Apache POI 4.x and it didn’t help us out because performance of the application came down considerably high and for larger reports Heap memory was running out of space. Is there any way we can tackle the issue without going for Shared strings approach and by using the default Inline string method for SXSSF. Thank you. Regards, V. Dillibabu On Fri, Dec 21, 2018 at 11:01 AM dillibabu venugopal <[hidden email]> wrote: > 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 < > [hidden email]> 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 < >> > [hidden email]> 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: [hidden email] >> > > >> > > > For additional commands, e-mail: [hidden email] >> > > >> > > >> > > >> > > >> > > >> > >> > >> > ------------------------------------------------------------------- >> > --To unsubscribe, e-mail: [hidden email] >> > For additional commands, e-mail: [hidden email] >> >> >> > > -- > Regards, > V. Dillibabu > -- Regards, V. Dillibabu |
Free forum by Nabble | Edit this page |