Download XLSX error

Bug reports
1

Hi,

We just updated our instance to v32.5 yesterday. Now when we tried to download result to xlsx file, it gives the error message below.

{“message”:“java.io.FileNotFoundException: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.201.b09-2.el7_6.x86_64/jre/lib/resources.jar”,“type”:“class java.lang.InternalError”,“stacktrace”:[“sun.misc.URLClassPath$JarLoader.getResource(URLClassPath.java:1052)”,“sun.misc.URLClassPath.getResource(URLClassPath.java:249)”,“sun.misc.URLClassPath.getResource(URLClassPath.java:302)”,“java.lang.ClassLoader.getBootstrapResource(ClassLoader.java:1264)”,“java.lang.ClassLoader.getResource(ClassLoader.java:1093)”,“java.lang.ClassLoader.getResource(ClassLoader.java:1091)”,“java.lang.ClassLoader.getSystemResource(ClassLoader.java:1226)”,“java.lang.ClassLoader.getSystemResourceAsStream(ClassLoader.java:1329)”,“java.lang.Class.getResourceAsStream(Class.java:2221)”,“com.sun.org.apache.xml.internal.serializer.OutputPropertiesFactory$1.run(OutputPropertiesFactory.java:392)”,“java.security.AccessController.doPrivileged(Native Method)”,“com.sun.org.apache.xml.internal.serializer.OutputPropertiesFactory.loadPropertiesFile(OutputPropertiesFactory.java:388)”,“com.sun.org.apache.xml.internal.serializer.OutputPropertiesFactory.getDefaultMethodProperties(OutputPropertiesFactory.java:288)”,“com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.setDefaults(TransformerImpl.java:1132)”,“com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.createOutputProperties(TransformerImpl.java:1092)”,“com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.(TransformerImpl.java:254)”,“com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.(TransformerImpl.java:245)”,“com.sun.org.apache.xalan.internal.xsltc.trax.TransformerFactoryImpl.newTransformer(TransformerFactoryImpl.java:735)”,“org.apache.poi.openxml4j.opc.StreamHelper.getIdentityTransformer(StreamHelper.java:45)”,“org.apache.poi.openxml4j.opc.StreamHelper.saveXmlInStream(StreamHelper.java:61)”,“org.apache.poi.openxml4j.opc.internal.marshallers.ZipPartMarshaller.marshallRelationshipPart(ZipPartMarshaller.java:180)”,“org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:559)”,“org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1539)”,“org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:227)”,“dk.ative.docjure.spreadsheet$save_workbook_into_stream_BANG_.invokeStatic(spreadsheet.clj:96)”,“dk.ative.docjure.spreadsheet$save_workbook_into_stream_BANG_.invoke(spreadsheet.clj:91)”,“dk.ative.docjure.spreadsheet$fn__27274.invokeStatic(spreadsheet.clj:113)”,“dk.ative.docjure.spreadsheet$fn__27274.invoke(spreadsheet.clj:111)”,“clojure.lang.MultiFn.invoke(MultiFn.java:234)”,"–> util.export$export_to_xlsx.invokeStatic(export.clj:31)",“util.export$export_to_xlsx.invoke(export.clj:27)”,“api.dataset$as_format_response.invokeStatic(dataset.clj:107)”,“api.dataset$as_format_response.invoke(dataset.clj:99)”,“api.dataset$fn__44275$as_format_async__44280$fn__44281$fn__44346$state_machine__8574__auto____44375$fn__44378.invoke(dataset.clj:124)”,“api.dataset$fn__44275$as_format_async__44280$fn__44281$fn__44346$state_machine__8574__auto____44375.invoke(dataset.clj:119)”]}

Downloading to csv works fine.So does downloading to json. Only downloading to xlsx file doesnt work.

Please help…

2

Hi @cehau37
Which version did you upgrade from?
Are you running docker or JAR-file or …? Custom reverse proxy?
Which database are you trying to download from?
Does it happen to all questions or only specific like Native Query or Nested Question?

3

Hi,

Thank you for your response.

We upgraded from versoin 32.4. We’re running jar file. Reverse proxy using NGINX.

We are downloading from MS SQL database.

It happens to all questions.

Please help…

4

Do you see any other errors before the stacktrace?

Currently, the only issue I know of with 0.32.5 is related to downloads being limited to 2000 rows, but that affects all types of downloads - issue #9831.

I haven’t seen anyone having issues with XLSX - and I’ve just now tried to download multiple questions from MSSQL with 0.32.5 behind Nginx, but I’m using OpenJDK 8u191.
Which OS are you running Metabase on - it looks like CentOS?

Since I’m not sure what’s going on, I would suggest that you open an issue and provide as many details as possible:
https://github.com/metabase/metabase/issues/new

You can downgrade to 0.32.4, since there’s no changes to the database, but then you’ll likely be having the async-issue, which was fixed in 0.32.5. If you downgrade, always make a backup.

5

Hi,

I’m using CentOS 7.