poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Reichel <andr...@manticore-projects.com>
Subject Re: Reg: POI-4.0 Issue
Date Thu, 20 Dec 2018 06:29:33 GMT
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 <
> andreas@manticore-projects.com> 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: user-unsubscribe@poi.apache.org
> > 
> > > For additional commands, e-mail: user-help@poi.apache.org
> > 
> > 
> > 
> > 
> > 
> 
> 
> -------------------------------------------------------------------
> --To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message