You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by "Banerjee, Tapas" <Ta...@fmr.com> on 2014/10/01 19:37:11 UTC
RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the
api to dump large xml file at /tmp dir. Also does not compress & cleanup up
causing the /tmp/ disk space full
Nick or any one,
Is there way I can find which version of POI library (e.g. 3.10 or 3.11..) my build is linking programmatically?
The issue is: we have multiple poi jar fiels in our lib dir. I want to make sure our code is linking proper (3.11) jar.
For example:
For xerces - looking into org.apache.xerces.impl.Version - indicates what version the code is using.
Are there similar thing for poi?
I googled org.apache.poi.Impl.Version - but looks like no such thing
-----Original Message-----
From: Banerjee, Tapas
Sent: Monday, September 29, 2014 1:50 PM
To: POI Developers List
Subject: RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the api to dump large xml file at /tmp dir. Also does not compress & cleanup up causing the /tmp/ disk space full
Yes, we tried 3.11 beta 2 - no luck.
Some question:
- Does the complexity/memory intensive of database query (e.g. Union, join) to get data and produce excel sheet cause any issue?
- Why does not the xml file did not get compressed although we set called workbook.setCompressTempFiles(true);
- Why the xml files are not cleaned up - even if we set workbook.displose()
- Can we change the location file dump programmatically in a different place in place of /tmp?
- Any other ideas, we can try?
-----Original Message-----
From: bugzilla@apache.org [mailto:bugzilla@apache.org]
Sent: Monday, September 29, 2014 1:39 PM
To: dev@poi.apache.org
Subject: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the api to dump large xml file at /tmp dir. Also does not compress & cleanup up causing the /tmp/ disk space full
https://issues.apache.org/bugzilla/show_bug.cgi?id=57042
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
Please try with 3.11 beta 2 - does that help?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
B�KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKCB�� [��X��ܚX�KK[XZ[
�]�][��X��ܚX�P �K�\X�K�ܙ�B��܈Y][ۘ[��[X[� �K[XZ[
�]�Z[ �K�\X�K�ܙ�B�B
RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the
api to dump large xml file at /tmp dir. Also does not compress & cleanup up
causing the /tmp/ disk space full
Posted by Nick Burch <ap...@gagravarr.org>.
On Thu, 16 Oct 2014, Banerjee, Tapas wrote:
> Understood. I tried with intension some calls may be supported by older
> version of jar, which are deprecated in newer version. Also after
> googling, I saw someone else also had the same issue, solved by changing
> jar file.
> http://stackoverflow.com/questions/26298654/read-and-write-excel-file-using-apache-poi-in-java
>From the looks of it, they solved it by upgrading to a newer version of
POI and adding all the jars
> Interesting is - this works in my local Window machine. However, when I
> deploy to Linux server problem appears.
Sounds like you don't actually have the same jars in use on the two
machines. Check what else is on your classpath, especially what else
might've been snuck away on the classpath by something else (eg
application server)
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the
api to dump large xml file at /tmp dir. Also does not compress & cleanup up
causing the /tmp/ disk space full
Posted by "Banerjee, Tapas" <Ta...@fmr.com>.
> After the error, I've added below jar files to see if it solves the error, still no luck.
> jar poi-ooxml-3.9-20121203.jar poi-3.6-20091214.jar
>>> That will never ever work. In no situation is it ever supported to mix and
match POI jars from different versions. You must *always* ensure that all
your POI jars are from the same version
Understood. I tried with intension some calls may be supported by older version of jar, which are deprecated in newer version.
Also after googling, I saw someone else also had the same issue, solved by changing jar file.
http://stackoverflow.com/questions/26298654/read-and-write-excel-file-using-apache-poi-in-java
Is there an way to find out which jar (e.g. xml_api.jar...) causing this error?
Interesting is - this works in my local Window machine. However, when I deploy to Linux server problem appears.
Not sure if it is an JVM (Redhat vs Sun java) issue. I see a buglist here: https://bugzilla.redhat.com/show_bug.cgi?id=900105
Any other steps I can try?
Thanks in advance,
-----Original Message-----
From: Nick Burch [mailto:apache@gagravarr.org]
Sent: Thursday, October 16, 2014 6:18 PM
To: POI Developers List
Subject: RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the api to dump large xml file at /tmp dir. Also does not compress & cleanup up causing the /tmp/ disk space full
On Thu, 16 Oct 2014, Banerjee, Tapas wrote:
> FYI: We're using below poi jar files first
> poi-3.11-beta2-20140822. poi-ooxml-schemas-3.11-beta2-20140822.jar poi-ooxml-3.11-beta2-20140822.jar
>
> After the error, I've added below jar files to see if it solves the error, still no luck.
> jar poi-ooxml-3.9-20121203.jar poi-3.6-20091214.jar
That will never ever work. In no situation is it ever supported to mix and
match POI jars from different versions. You must *always* ensure that all
your POI jars are from the same version
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the
api to dump large xml file at /tmp dir. Also does not compress & cleanup up
causing the /tmp/ disk space full
Posted by Nick Burch <ap...@gagravarr.org>.
On Thu, 16 Oct 2014, Banerjee, Tapas wrote:
> FYI: We're using below poi jar files first
> poi-3.11-beta2-20140822. poi-ooxml-schemas-3.11-beta2-20140822.jar poi-ooxml-3.11-beta2-20140822.jar
>
> After the error, I've added below jar files to see if it solves the error, still no luck.
> jar poi-ooxml-3.9-20121203.jar poi-3.6-20091214.jar
That will never ever work. In no situation is it ever supported to mix and
match POI jars from different versions. You must *always* ensure that all
your POI jars are from the same version
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the
api to dump large xml file at /tmp dir. Also does not compress & cleanup up
causing the /tmp/ disk space full
Posted by "Banerjee, Tapas" <Ta...@fmr.com>.
OK, I used the below idea to change the default /tmp dir.
When I deploy the code at our Linux server, when I run the Excel operation, I get below exceptions.
It appears it is missing some jar file.
FYI: We're using below poi jar files first
poi-3.11-beta2-20140822. poi-ooxml-schemas-3.11-beta2-20140822.jar poi-ooxml-3.11-beta2-20140822.jar
After the error, I've added below jar files to see if it solves the error, still no luck.
jar poi-ooxml-3.9-20121203.jar poi-3.6-20091214.jar
Any clue?
Thanks,
[10/16/14 17:55:08:343 EDT] 0000001e servlet E com.ibm.ws.webcontainer.servlet.ServletWrapper service SRVE0068E: Uncaught exception created in one of the service methods of the servlet ExportExcelServlet in application ORWS_04_01_00_0007_war. Exception created : java.lang.NoSuchMethodError: javax/xml/stream/XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory;
at org.apache.poi.openxml4j.opc.internal.marshallers.PackagePropertiesMarshaller.<clinit>(PackagePropertiesMarshaller.java:45)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:200)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:167)
at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:161)
at org.apache.poi.openxml4j.opc.OPCPackage.<init>(OPCPackage.java:141)
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:65)
at org.apache.poi.openxml4j.opc.OPCPackage.create(OPCPackage.java:337)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.newPackage(XSSFWorkbook.java:406)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:213)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:216)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:185)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:160)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:255)
at com.fmr.orws.excel.SendXLS2GUI.doPost(Unknown Source)
at com.fmr.orws.excel.SendXLS2GUI.doGet(Unknown Source)
-----Original Message-----
From: Dominik Stadler [mailto:dominik.stadler@gmx.at]
Sent: Sunday, October 12, 2014 5:54 AM
To: POI Developers List
Subject: Re: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the api to dump large xml file at /tmp dir. Also does not compress & cleanup up causing the /tmp/ disk space full
Hi,
SXSSFWorkbook uses class TempFile, which uses
DefaultTempFileCreationStrategy which uses the system property
java.io.tmpdir by default. So one option is to set this property
differently, however this can affect other frameworks/libraries and
JDK functionality itself as well. Alternatively you can set a
different strategy/dir via
org.apache.poi.util.TempFile.setTempFileCreationStrategy(), e.g. you
can set a different directory via
org.apache.poi.util.TempFile.setTempFileCreationStrategy(new
org.apache.poi.util.TempFile.DefaultTempFileCreationStrategy(new
File("/var/tmp")))
Dominik.
On Mon, Oct 6, 2014 at 8:30 PM, Banerjee, Tapas <Ta...@fmr.com> wrote:
> As suggested below, removing old (2.6) xerces jar, and linking the latest 2.11 xercesImpl.jars, solved the exception issue.
> Now I can export files at my local PC environment. We'll test with bigger files by deploying the code to Unix server.
>
> Question: Is there a way (API call?) we can change location of dumping Xml file ( currently /tmp) by the POI - SXSSF api?
>
> Thanks,
>
>
> -----Original Message-----
> From: Dominik Stadler [mailto:dominik.stadler@gmx.at]
> Sent: Friday, October 03, 2014 5:03 PM
> To: POI Developers List
> Subject: RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the api to dump large xml file at /tmp dir. Also does not compress & cleanup up causing the /tmp/ disk space full
>
> the root cause is a very outdated xml parser implementation which you are
> loading via the classpath. Ideally you should try to upgrade or remove
> xerces jar files or other old xml implementation from your classpath, jdk
> comes with the same features since a long time, however unfortunately some
> 3rd party libs still hard-depend on these old libs.
>
> Alternatively you can try a nightly build where this error is prevented for
> backwards compatibility.
>
> Dominik
> Am 03.10.2014 17:29 schrieb "Banerjee, Tapas" <Ta...@fmr.com>:
>
>> Nick,
>>
>> I added code to print version. It shows it is pointing to 3/11 (dev)
>>
>> However, when I try to export to excel, I am getting below error.
>>
>>
>>
>> Core POI came from
>> file:/C:/ccrc/a475324_EBS_ORWS_UI_03.05.00_rtp_d/WFM/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/.../WEB-INF/lib/poi-3.11-beta2-20140822.jar!/org/apache/poi/poifs/filesystem/POIFSFileSystem.class
>>
>> Oct 3, 2014 11:18:59 AM org.apache.catalina.core.StandardWrapperValve
>> invoke
>>
>> SEVERE: Servlet.service() for servlet ExportExcelServlet threw exception
>>
>> java.lang.AbstractMethodError:
>> javax.xml.parsers.DocumentBuilderFactory.setFeature(Ljava/lang/String;Z)V
>>
>> at
>> org.apache.poi.util.DocumentHelper.trySetSAXFeature(DocumentHelper.java:62)
>>
>> at
>> org.apache.poi.util.DocumentHelper.<clinit>(DocumentHelper.java:56)
>>
>> at
>> org.apache.poi.openxml4j.opc.internal.marshallers.ZipPartMarshaller.marshallRelationshipPart(ZipPartMarshaller.java:120)
>>
>> at
>> org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:464)
>>
>> at
>> org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1425)
>>
>> at
>> org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:201)
>>
>> at
>> org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:830)
>>
>> at
>> com.fmr.orws.excel.SendXLS2GUI.doPost(SendXLS2GUI.java:55)
>>
>>
>>
>> I see this issue is listed in Poi dev mailing list.
>>
>> Any idea, how I can solve the issue?
>>
>>
>>
>>
>> http://mail-archives.apache.org/mod_mbox/poi-dev/201408.mbox/%3CCABdJj56oEQoAf7iCuoDL7e_1CGDQDQspEg+VksZudYrFoF16VA@mail.gmail.com%3E
>>
>>
>>
>> Thanks,
>>
>>
>>
>> -----Original Message-----
>> From: Nick Burch [mailto:apache@gagravarr.org]
>> Sent: Wednesday, October 01, 2014 1:41 PM
>> To: POI Developers List
>> Subject: RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing
>> the api to dump large xml file at /tmp dir. Also does not compress &
>> cleanup up causing the /tmp/ disk space full
>>
>>
>>
>> On Wed, 1 Oct 2014, Banerjee, Tapas wrote:
>>
>> > Is there way I can find which version of POI library (e.g. 3.10 or
>>
>> > 3.11..) my build is linking programmatically?
>>
>>
>>
>> Assuming you haven't renamed jars, try the code from the FAQ:
>>
>> http://poi.apache.org/faq.html#faq-N10006
>>
>>
>>
>> There's also org.apache.poi.Version
>>
>>
>>
>> Nick
>>
>>
>>
>> ---------------------------------------------------------------------
>>
>> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org<mailto:
>> dev-unsubscribe@poi.apache.org>
>>
>> For additional commands, e-mail: dev-help@poi.apache.org<mailto:
>> dev-help@poi.apache.org>
>>
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the
api to dump large xml file at /tmp dir. Also does not compress & cleanup up
causing the /tmp/ disk space full
Posted by Dominik Stadler <do...@gmx.at>.
Hi,
SXSSFWorkbook uses class TempFile, which uses
DefaultTempFileCreationStrategy which uses the system property
java.io.tmpdir by default. So one option is to set this property
differently, however this can affect other frameworks/libraries and
JDK functionality itself as well. Alternatively you can set a
different strategy/dir via
org.apache.poi.util.TempFile.setTempFileCreationStrategy(), e.g. you
can set a different directory via
org.apache.poi.util.TempFile.setTempFileCreationStrategy(new
org.apache.poi.util.TempFile.DefaultTempFileCreationStrategy(new
File("/var/tmp")))
Dominik.
On Mon, Oct 6, 2014 at 8:30 PM, Banerjee, Tapas <Ta...@fmr.com> wrote:
> As suggested below, removing old (2.6) xerces jar, and linking the latest 2.11 xercesImpl.jars, solved the exception issue.
> Now I can export files at my local PC environment. We'll test with bigger files by deploying the code to Unix server.
>
> Question: Is there a way (API call?) we can change location of dumping Xml file ( currently /tmp) by the POI - SXSSF api?
>
> Thanks,
>
>
> -----Original Message-----
> From: Dominik Stadler [mailto:dominik.stadler@gmx.at]
> Sent: Friday, October 03, 2014 5:03 PM
> To: POI Developers List
> Subject: RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the api to dump large xml file at /tmp dir. Also does not compress & cleanup up causing the /tmp/ disk space full
>
> the root cause is a very outdated xml parser implementation which you are
> loading via the classpath. Ideally you should try to upgrade or remove
> xerces jar files or other old xml implementation from your classpath, jdk
> comes with the same features since a long time, however unfortunately some
> 3rd party libs still hard-depend on these old libs.
>
> Alternatively you can try a nightly build where this error is prevented for
> backwards compatibility.
>
> Dominik
> Am 03.10.2014 17:29 schrieb "Banerjee, Tapas" <Ta...@fmr.com>:
>
>> Nick,
>>
>> I added code to print version. It shows it is pointing to 3/11 (dev)
>>
>> However, when I try to export to excel, I am getting below error.
>>
>>
>>
>> Core POI came from
>> file:/C:/ccrc/a475324_EBS_ORWS_UI_03.05.00_rtp_d/WFM/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/.../WEB-INF/lib/poi-3.11-beta2-20140822.jar!/org/apache/poi/poifs/filesystem/POIFSFileSystem.class
>>
>> Oct 3, 2014 11:18:59 AM org.apache.catalina.core.StandardWrapperValve
>> invoke
>>
>> SEVERE: Servlet.service() for servlet ExportExcelServlet threw exception
>>
>> java.lang.AbstractMethodError:
>> javax.xml.parsers.DocumentBuilderFactory.setFeature(Ljava/lang/String;Z)V
>>
>> at
>> org.apache.poi.util.DocumentHelper.trySetSAXFeature(DocumentHelper.java:62)
>>
>> at
>> org.apache.poi.util.DocumentHelper.<clinit>(DocumentHelper.java:56)
>>
>> at
>> org.apache.poi.openxml4j.opc.internal.marshallers.ZipPartMarshaller.marshallRelationshipPart(ZipPartMarshaller.java:120)
>>
>> at
>> org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:464)
>>
>> at
>> org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1425)
>>
>> at
>> org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:201)
>>
>> at
>> org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:830)
>>
>> at
>> com.fmr.orws.excel.SendXLS2GUI.doPost(SendXLS2GUI.java:55)
>>
>>
>>
>> I see this issue is listed in Poi dev mailing list.
>>
>> Any idea, how I can solve the issue?
>>
>>
>>
>>
>> http://mail-archives.apache.org/mod_mbox/poi-dev/201408.mbox/%3CCABdJj56oEQoAf7iCuoDL7e_1CGDQDQspEg+VksZudYrFoF16VA@mail.gmail.com%3E
>>
>>
>>
>> Thanks,
>>
>>
>>
>> -----Original Message-----
>> From: Nick Burch [mailto:apache@gagravarr.org]
>> Sent: Wednesday, October 01, 2014 1:41 PM
>> To: POI Developers List
>> Subject: RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing
>> the api to dump large xml file at /tmp dir. Also does not compress &
>> cleanup up causing the /tmp/ disk space full
>>
>>
>>
>> On Wed, 1 Oct 2014, Banerjee, Tapas wrote:
>>
>> > Is there way I can find which version of POI library (e.g. 3.10 or
>>
>> > 3.11..) my build is linking programmatically?
>>
>>
>>
>> Assuming you haven't renamed jars, try the code from the FAQ:
>>
>> http://poi.apache.org/faq.html#faq-N10006
>>
>>
>>
>> There's also org.apache.poi.Version
>>
>>
>>
>> Nick
>>
>>
>>
>> ---------------------------------------------------------------------
>>
>> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org<mailto:
>> dev-unsubscribe@poi.apache.org>
>>
>> For additional commands, e-mail: dev-help@poi.apache.org<mailto:
>> dev-help@poi.apache.org>
>>
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the
api to dump large xml file at /tmp dir. Also does not compress & cleanup up
causing the /tmp/ disk space full
Posted by "Banerjee, Tapas" <Ta...@fmr.com>.
As suggested below, removing old (2.6) xerces jar, and linking the latest 2.11 xercesImpl.jars, solved the exception issue.
Now I can export files at my local PC environment. We'll test with bigger files by deploying the code to Unix server.
Question: Is there a way (API call?) we can change location of dumping Xml file ( currently /tmp) by the POI - SXSSF api?
Thanks,
-----Original Message-----
From: Dominik Stadler [mailto:dominik.stadler@gmx.at]
Sent: Friday, October 03, 2014 5:03 PM
To: POI Developers List
Subject: RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the api to dump large xml file at /tmp dir. Also does not compress & cleanup up causing the /tmp/ disk space full
the root cause is a very outdated xml parser implementation which you are
loading via the classpath. Ideally you should try to upgrade or remove
xerces jar files or other old xml implementation from your classpath, jdk
comes with the same features since a long time, however unfortunately some
3rd party libs still hard-depend on these old libs.
Alternatively you can try a nightly build where this error is prevented for
backwards compatibility.
Dominik
Am 03.10.2014 17:29 schrieb "Banerjee, Tapas" <Ta...@fmr.com>:
> Nick,
>
> I added code to print version. It shows it is pointing to 3/11 (dev)
>
> However, when I try to export to excel, I am getting below error.
>
>
>
> Core POI came from
> file:/C:/ccrc/a475324_EBS_ORWS_UI_03.05.00_rtp_d/WFM/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/.../WEB-INF/lib/poi-3.11-beta2-20140822.jar!/org/apache/poi/poifs/filesystem/POIFSFileSystem.class
>
> Oct 3, 2014 11:18:59 AM org.apache.catalina.core.StandardWrapperValve
> invoke
>
> SEVERE: Servlet.service() for servlet ExportExcelServlet threw exception
>
> java.lang.AbstractMethodError:
> javax.xml.parsers.DocumentBuilderFactory.setFeature(Ljava/lang/String;Z)V
>
> at
> org.apache.poi.util.DocumentHelper.trySetSAXFeature(DocumentHelper.java:62)
>
> at
> org.apache.poi.util.DocumentHelper.<clinit>(DocumentHelper.java:56)
>
> at
> org.apache.poi.openxml4j.opc.internal.marshallers.ZipPartMarshaller.marshallRelationshipPart(ZipPartMarshaller.java:120)
>
> at
> org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:464)
>
> at
> org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1425)
>
> at
> org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:201)
>
> at
> org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:830)
>
> at
> com.fmr.orws.excel.SendXLS2GUI.doPost(SendXLS2GUI.java:55)
>
>
>
> I see this issue is listed in Poi dev mailing list.
>
> Any idea, how I can solve the issue?
>
>
>
>
> http://mail-archives.apache.org/mod_mbox/poi-dev/201408.mbox/%3CCABdJj56oEQoAf7iCuoDL7e_1CGDQDQspEg+VksZudYrFoF16VA@mail.gmail.com%3E
>
>
>
> Thanks,
>
>
>
> -----Original Message-----
> From: Nick Burch [mailto:apache@gagravarr.org]
> Sent: Wednesday, October 01, 2014 1:41 PM
> To: POI Developers List
> Subject: RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing
> the api to dump large xml file at /tmp dir. Also does not compress &
> cleanup up causing the /tmp/ disk space full
>
>
>
> On Wed, 1 Oct 2014, Banerjee, Tapas wrote:
>
> > Is there way I can find which version of POI library (e.g. 3.10 or
>
> > 3.11..) my build is linking programmatically?
>
>
>
> Assuming you haven't renamed jars, try the code from the FAQ:
>
> http://poi.apache.org/faq.html#faq-N10006
>
>
>
> There's also org.apache.poi.Version
>
>
>
> Nick
>
>
>
> ---------------------------------------------------------------------
>
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org<mailto:
> dev-unsubscribe@poi.apache.org>
>
> For additional commands, e-mail: dev-help@poi.apache.org<mailto:
> dev-help@poi.apache.org>
>
>
>
RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the
api to dump large xml file at /tmp dir. Also does not compress & cleanup up
causing the /tmp/ disk space full
Posted by Dominik Stadler <do...@gmx.at>.
the root cause is a very outdated xml parser implementation which you are
loading via the classpath. Ideally you should try to upgrade or remove
xerces jar files or other old xml implementation from your classpath, jdk
comes with the same features since a long time, however unfortunately some
3rd party libs still hard-depend on these old libs.
Alternatively you can try a nightly build where this error is prevented for
backwards compatibility.
Dominik
Am 03.10.2014 17:29 schrieb "Banerjee, Tapas" <Ta...@fmr.com>:
> Nick,
>
> I added code to print version. It shows it is pointing to 3/11 (dev)
>
> However, when I try to export to excel, I am getting below error.
>
>
>
> Core POI came from
> file:/C:/ccrc/a475324_EBS_ORWS_UI_03.05.00_rtp_d/WFM/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/.../WEB-INF/lib/poi-3.11-beta2-20140822.jar!/org/apache/poi/poifs/filesystem/POIFSFileSystem.class
>
> Oct 3, 2014 11:18:59 AM org.apache.catalina.core.StandardWrapperValve
> invoke
>
> SEVERE: Servlet.service() for servlet ExportExcelServlet threw exception
>
> java.lang.AbstractMethodError:
> javax.xml.parsers.DocumentBuilderFactory.setFeature(Ljava/lang/String;Z)V
>
> at
> org.apache.poi.util.DocumentHelper.trySetSAXFeature(DocumentHelper.java:62)
>
> at
> org.apache.poi.util.DocumentHelper.<clinit>(DocumentHelper.java:56)
>
> at
> org.apache.poi.openxml4j.opc.internal.marshallers.ZipPartMarshaller.marshallRelationshipPart(ZipPartMarshaller.java:120)
>
> at
> org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:464)
>
> at
> org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1425)
>
> at
> org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:201)
>
> at
> org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:830)
>
> at
> com.fmr.orws.excel.SendXLS2GUI.doPost(SendXLS2GUI.java:55)
>
>
>
> I see this issue is listed in Poi dev mailing list.
>
> Any idea, how I can solve the issue?
>
>
>
>
> http://mail-archives.apache.org/mod_mbox/poi-dev/201408.mbox/%3CCABdJj56oEQoAf7iCuoDL7e_1CGDQDQspEg+VksZudYrFoF16VA@mail.gmail.com%3E
>
>
>
> Thanks,
>
>
>
> -----Original Message-----
> From: Nick Burch [mailto:apache@gagravarr.org]
> Sent: Wednesday, October 01, 2014 1:41 PM
> To: POI Developers List
> Subject: RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing
> the api to dump large xml file at /tmp dir. Also does not compress &
> cleanup up causing the /tmp/ disk space full
>
>
>
> On Wed, 1 Oct 2014, Banerjee, Tapas wrote:
>
> > Is there way I can find which version of POI library (e.g. 3.10 or
>
> > 3.11..) my build is linking programmatically?
>
>
>
> Assuming you haven't renamed jars, try the code from the FAQ:
>
> http://poi.apache.org/faq.html#faq-N10006
>
>
>
> There's also org.apache.poi.Version
>
>
>
> Nick
>
>
>
> ---------------------------------------------------------------------
>
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org<mailto:
> dev-unsubscribe@poi.apache.org>
>
> For additional commands, e-mail: dev-help@poi.apache.org<mailto:
> dev-help@poi.apache.org>
>
>
>
RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the
api to dump large xml file at /tmp dir. Also does not compress & cleanup up
causing the /tmp/ disk space full
Posted by "Banerjee, Tapas" <Ta...@fmr.com>.
Nick,
I added code to print version. It shows it is pointing to 3/11 (dev)
However, when I try to export to excel, I am getting below error.
Core POI came from file:/C:/ccrc/a475324_EBS_ORWS_UI_03.05.00_rtp_d/WFM/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/.../WEB-INF/lib/poi-3.11-beta2-20140822.jar!/org/apache/poi/poifs/filesystem/POIFSFileSystem.class
Oct 3, 2014 11:18:59 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet ExportExcelServlet threw exception
java.lang.AbstractMethodError: javax.xml.parsers.DocumentBuilderFactory.setFeature(Ljava/lang/String;Z)V
at org.apache.poi.util.DocumentHelper.trySetSAXFeature(DocumentHelper.java:62)
at org.apache.poi.util.DocumentHelper.<clinit>(DocumentHelper.java:56)
at org.apache.poi.openxml4j.opc.internal.marshallers.ZipPartMarshaller.marshallRelationshipPart(ZipPartMarshaller.java:120)
at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:464)
at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1425)
at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:201)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:830)
at com.fmr.orws.excel.SendXLS2GUI.doPost(SendXLS2GUI.java:55)
I see this issue is listed in Poi dev mailing list.
Any idea, how I can solve the issue?
http://mail-archives.apache.org/mod_mbox/poi-dev/201408.mbox/%3CCABdJj56oEQoAf7iCuoDL7e_1CGDQDQspEg+VksZudYrFoF16VA@mail.gmail.com%3E
Thanks,
-----Original Message-----
From: Nick Burch [mailto:apache@gagravarr.org]
Sent: Wednesday, October 01, 2014 1:41 PM
To: POI Developers List
Subject: RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the api to dump large xml file at /tmp dir. Also does not compress & cleanup up causing the /tmp/ disk space full
On Wed, 1 Oct 2014, Banerjee, Tapas wrote:
> Is there way I can find which version of POI library (e.g. 3.10 or
> 3.11..) my build is linking programmatically?
Assuming you haven't renamed jars, try the code from the FAQ:
http://poi.apache.org/faq.html#faq-N10006
There's also org.apache.poi.Version
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org<ma...@poi.apache.org>
For additional commands, e-mail: dev-help@poi.apache.org<ma...@poi.apache.org>
RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the
api to dump large xml file at /tmp dir. Also does not compress & cleanup up
causing the /tmp/ disk space full
Posted by Nick Burch <ap...@gagravarr.org>.
On Wed, 1 Oct 2014, Banerjee, Tapas wrote:
> Is there way I can find which version of POI library (e.g. 3.10 or
> 3.11..) my build is linking programmatically?
Assuming you haven't renamed jars, try the code from the FAQ:
http://poi.apache.org/faq.html#faq-N10006
There's also org.apache.poi.Version
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org