Re: Poi thread running since a long time
Which version of POI are you using? That line # is not in that method in the latest version. Many performance and bug fixes have gone into releases over the last couple years. If you have a file we can examine/test, or even better a unit test that shows the issue against the latest release, that would be the best way for us to help. Testing against the latest release is the best first step, to see if the issue has already been fixed in a newer version. Secondly, which specific Sheet implementation are you using - HSSF, XSSF, or SXSSF? They all have their own implementations of row.removeCell() which is where the manipulation of the CT* row and cell objects takes place. On Thu, Feb 14, 2019 at 5:53 AM smitha wrote: > > Hi , > > We have a import excel functionality where the user uploads a file with data > to import.For few of the files (we do not have those samples) , the thread > is running since a long time (252 + minutes ) at the following line where > we check to see if there are empty rows : > > java.lang.Thread.State: RUNNABLE > at org.apache.xmlbeans.impl.store.Xobj.remove_element(Xobj.java:2232) > at > org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTSheetDataImpl.removeRow(Unknown > Source) > - locked <0x0006d6e764f8> (a > org.apache.xmlbeans.impl.store.Locale) > at > org.apache.poi.xssf.usermodel.XSSFSheet.removeRow(XSSFSheet.java:1990) > at > com.razor.app.ra.common.importer.factory.impl.XlsxExcelImporter.deleteEmptyRows(XlsxExcelImporter.java:240) > > Any help would be appreciated . > > Thanks ! > > > > > -- > Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html > > - > To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org > For additional commands, e-mail: dev-h...@poi.apache.org > - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
Re: References to org.apache.poi.POIXMLTypeLoader in ooxml-security-1.1.jar: NoClassDefFoundError
Hi Thomas, the ooxml-security-1.1.jar is not compatible with poi-*-4.0.1.jar and this is my fault, as I haven't updated the ooxml-security release. The original reason are changes #60226 and #62355. I assumed everything for encryption and signing should be provided by poi-ooxml-schemas. Which class/es do you miss? ... or even better, do you have junit test for it? ... so we can include the necessary classes automatically on the OOXMLLite run My temporary workaround would be, to compile the ooxml-security-1.* from the source, but that will lead to duplicated classpath entries with poi-ooxml-schemas - I'm not sure which side effects this will have. Best wishes, Andi -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
References to org.apache.poi.POIXMLTypeLoader in ooxml-security-1.1.jar: NoClassDefFoundError
Hi,
in ooxml-security-1.1.jar in class
"com.microsoft.schemas.office.x2006.encryption.EncryptionDocument" (in the
inner class "Factory") there are references to the class
"org.apache.poi.POIXMLTypeLoader" - which breaks at runtime with a
NoClassDefFoundError, because the class is in package
"org.apache.poi.ooxml.POIXMLTypeLoader" in poi-ooxml-4.0.1.jar.
I'm uncertain what I can do to clear this issue. In the class
EncryptionDocument in poi-ooxml-schemas-4.0.1.jar the references are correct,
but I cannot use this lib because it does not contain everything I need.
I cannot disclose the test document (it belongs to our customer), so here some
more info about the error:
This is the method the error occurs in:
public static com.microsoft.schemas.office.x2006.encryption.EncryptionDocument
parse(java.io.InputStream is, org.apache.xmlbeans.XmlOptions options) throws
org.apache.xmlbeans.XmlException, java.io.IOException {
return
(com.microsoft.schemas.office.x2006.encryption.EncryptionDocument)
org.apache.poi.POIXMLTypeLoader.parse( is, type, options ); }
Some way back on the stack:
[cid:image001.png@01D4CD1F.AE5567E0]
This is what the stacktrace could look like (I had to reconstruct it by hand,
because the lib was compiled without debug infos):
java.lang.NoClassDefFoundError: org/apache/poi/POIXMLTypeLoader
at
com.microsoft.schemas.office.x2006.encryption.EncryptionDocument.Factory.parse(EncryptionDocument:73)
at
org.apache.poi.poifs.crypt.agile.AgileEncryptionInfoBuilder.parseDescriptor(AgileEncryptionInfoBuilder.java:104)
at
org.apache.poi.poifs.crypt.agile.AgileEncryptionInfoBuilder.initialize(AgileEncryptionInfoBuilder.java:40)
at
org.apache.poi.poifs.crypt.EncryptionInfo.(EncryptionInfo.java:139)
at
org.apache.poi.poifs.crypt.EncryptionInfo.(EncryptionInfo.java:88)
at
org.apache.poi.poifs.crypt.EncryptionInfo.(EncryptionInfo.java:81)
at
org.apache.poi.ooxml.extractor.ExtractorFactory.createEncryptedOOXMLExtractor(ExtractorFactory.java:391)
at
org.apache.poi.ooxml.extractor.ExtractorFactory.createExtractor(ExtractorFactory.java:134)
Thank you and best regards,
Tobias Fink
Software Development
Fasihi GmbH - Donnersbergweg 4 - 67059 Ludwigshafen - Germany
Geschäftsführer Saeid Fasihi, Rolf Lutzer - Firmensitz Ludwigshafen a. Rh.
Amtsgericht Ludwigshafen - HRB 60601
