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
reports Heap memory was running out of space. Is there any way we can
V. Dillibabu
> 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
>
V. Dillibabu
Locked
Error.txt (6K)