V. Dillibabu
> 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]
>
>
>
V. Dillibabu
Locked
Error.txt (6K)