Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

strict ooxml format in xlsx spreadsheet returns generic error #33

Open
jdeck88 opened this issue Jun 19, 2020 · 1 comment
Open

strict ooxml format in xlsx spreadsheet returns generic error #33

jdeck88 opened this issue Jun 19, 2020 · 1 comment

Comments

@jdeck88
Copy link
Member

jdeck88 commented Jun 19, 2020

i'm not sure we can fix not being able to take strict ooxml format sheets due to Apache POI bug. (though we should check the bug referenced below to see if it is fixed). We should, however, return a more informative message to the user, rather than "server error".

java.util.concurrent.CompletionException: org.apache.poi.ooxml.POIXMLException: Strict OOXML isn't currently supported, please see bug #57699
    at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:314)
    at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:319)
    at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1702)
    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.apache.poi.ooxml.POIXMLException: Strict OOXML isn't currently supported, please see bug #57699
    at org.apache.poi.ooxml.POIXMLDocumentPart.getPartFromOPCPackage(POIXMLDocumentPart.java:741)
    at org.apache.poi.ooxml.POIXMLDocumentPart.<init>(POIXMLDocumentPart.java:147)
    at org.apache.poi.ooxml.POIXMLDocumentPart.<init>(POIXMLDocumentPart.java:137)
    at org.apache.poi.ooxml.POIXMLDocument.<init>(POIXMLDocument.java:61)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:280)
    at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:83)
    at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:111)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.apache.poi.ss.usermodel.WorkbookFactory.createWorkbook(WorkbookFactory.java:314)
    at org.apache.poi.ss.usermodel.WorkbookFactory.createXSSFWorkbook(WorkbookFactory.java:296)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:284)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:253)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:234)
    at biocode.fims.reader.plugins.ExcelReader.init(ExcelReader.java:72)
    at biocode.fims.reader.plugins.AbstractTabularDataReader.getRecordSets(AbstractTabularDataReader.java:52)
    at biocode.fims.reader.plugins.ExcelReader.getRecordSets(ExcelReader.java:37)
    at biocode.fims.run.DatasetBuilder.readData(DatasetBuilder.java:158)
    at biocode.fims.run.DatasetBuilder.instantiateWorkbookRecords(DatasetBuilder.java:150)
    at biocode.fims.run.DatasetBuilder.build(DatasetBuilder.java:125)
    at biocode.fims.run.DatasetProcessor.validate(DatasetProcessor.java:98)
    at biocode.fims.rest.services.DatasetController.lambda$validate$0(DatasetController.java:220)
    at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
    ... 1 more
@jdeck88
Copy link
Member Author

jdeck88 commented Jun 19, 2020

FuTRES_Puma_concolor_ODFW_OR_USA_Modern (1).xlsx
Here is a small sample file to test with saved in OOXML format for Futres project

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant