Reg: POI-4.0 Issue

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Reg: POI-4.0 Issue

dillibabu venugopal

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]

Error.txt (6K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Reg: POI-4.0 Issue

Andreas Reichel
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]


Reply | Threaded
Open this post in threaded view
|

Re: Reg: POI-4.0 Issue

dillibabu venugopal
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]




--
Regards,
V. Dillibabu


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Error.txt (6K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Reg: POI-4.0 Issue

Andreas Reichel
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]


Reply | Threaded
Open this post in threaded view
|

Re: Reg: POI-4.0 Issue

dillibabu venugopal
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
Reply | Threaded
Open this post in threaded view
|

Re: Reg: POI-4.0 Issue

dillibabu venugopal
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