Excel files not exporting properly

Excel files not exporting properly. Can you please review and suggest what we should be looking for to resolve?

Diagnostic Info

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.60 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "ANSI_X3.4-1968",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14+9",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14+9",
"os.name": "Linux",
"os.version": "5.10.93-87.444.amzn2.x86_64",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"h2",
"mysql"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2022-01-10",
"tag": "v0.41.6",
"branch": "release-x.41.x",
"hash": "296635f"
},
"settings": {
"report-timezone": null
}
}
}

Below is the data thats was in Excel.

{
"via": [{
"type": "java.lang.InternalError",
"message": "java.lang.reflect.InvocationTargetException",
"at": ["sun.font.FontManagerFactory$1", "run", "FontManagerFactory.java", 86]
}, {
"type": "java.lang.reflect.InvocationTargetException",
"at": ["jdk.internal.reflect.NativeConstructorAccessorImpl", "newInstance0", "NativeConstructorAccessorImpl.java", -2]
}, {
"type": "java.lang.NullPointerException",
"at": ["sun.awt.FontConfiguration", "getVersion", "FontConfiguration.java", 1262]
}
],
"trace": [["sun.awt.FontConfiguration", "getVersion", "FontConfiguration.java", 1262],
["sun.awt.FontConfiguration", "readFontConfigFile", "FontConfiguration.java", 225],
["sun.awt.FontConfiguration", "init", "FontConfiguration.java", 107],
["sun.awt.X11FontManager", "createFontConfiguration", "X11FontManager.java", 719],
["sun.font.SunFontManager$2", "run", "SunFontManager.java", 379],
["java.security.AccessController", "doPrivileged", "AccessController.java", -2],
["sun.font.SunFontManager", "", "SunFontManager.java", 324],
["sun.awt.FcFontManager", "", "FcFontManager.java", 35],
["sun.awt.X11FontManager", "", "X11FontManager.java", 56],
["jdk.internal.reflect.NativeConstructorAccessorImpl", "newInstance0", "NativeConstructorAccessorImpl.java", -2],
["jdk.internal.reflect.NativeConstructorAccessorImpl", "newInstance", "NativeConstructorAccessorImpl.java", 62],
["jdk.internal.reflect.DelegatingConstructorAccessorImpl", "newInstance", "DelegatingConstructorAccessorImpl.java", 45],
["java.lang.reflect.Constructor", "newInstance", "Constructor.java", 490],
["sun.font.FontManagerFactory$1", "run", "FontManagerFactory.java", 84],
["java.security.AccessController", "doPrivileged", "AccessController.java", -2],
["sun.font.FontManagerFactory", "getInstance", "FontManagerFactory.java", 74],
["java.awt.Font", "getFont2D", "Font.java", 497],
["java.awt.Font", "canDisplayUpTo", "Font.java", 2250],
["java.awt.font.TextLayout", "singleFont", "TextLayout.java", 469],
["java.awt.font.TextLayout", "", "TextLayout.java", 530],
["org.apache.poi.ss.util.SheetUtil", "getDefaultCharWidth", "SheetUtil.java", 285],
["org.apache.poi.xssf.streaming.AutoSizeColumnTracker", "", "AutoSizeColumnTracker.java", 117],
["org.apache.poi.xssf.streaming.SXSSFSheet", "", "SXSSFSheet.java", 89],
["org.apache.poi.xssf.streaming.SXSSFWorkbook", "createAndRegisterSXSSFSheet", "SXSSFWorkbook.java", 701],
["org.apache.poi.xssf.streaming.SXSSFWorkbook", "createSheet", "SXSSFWorkbook.java", 722],
["org.apache.poi.xssf.streaming.SXSSFWorkbook", "createSheet", "SXSSFWorkbook.java", 96],
["dk.ative.docjure.spreadsheet$add_sheet_BANG_", "invokeStatic", "spreadsheet.clj", 312],
["dk.ative.docjure.spreadsheet$add_sheet_BANG_", "invoke", "spreadsheet.clj", 308], [
"metabase.query_processor.streaming.xlsx$fn__37912", "invokeStatic", "xlsx.clj", 462],
["metabase.query_processor.streaming.xlsx$fn__37912", "invoke", "xlsx.clj", 459],
["clojure.lang.MultiFn", "invoke", "MultiFn.java", 234],
["metabase.query_processor.streaming$streaming_context", "invokeStatic", "streaming.clj", 139],
["metabase.query_processor.streaming$streaming_context", "invoke", "streaming.clj", 132], [
"metabase.query_processor.streaming$streaming_context", "invokeStatic", "streaming.clj", 144],
["metabase.query_processor.streaming$streaming_context", "invoke", "streaming.clj", 132],
["metabase.query_processor.streaming$streaming_response_STAR_$fn__38062$fn__38063", "invoke", "streaming.clj", 159],
["metabase.query_processor.streaming$streaming_response_STAR_$fn__38062", "invoke", "streaming.clj", 158],
["metabase.async.streaming_response$do_f_STAR_", "invokeStatic", "streaming_response.clj", 65],
["metabase.async.streaming_response$do_f_STAR_", "invoke", "streaming_response.clj", 63],
["metabase.async.streaming_response$do_f_async$fn__25229", "invoke", "streaming_response.clj", 84],
["clojure.lang.AFn", "applyToHelper", "AFn.java", 152],
["clojure.lang.AFn", "applyTo", "AFn.java", 144],
["clojure.core$apply", "invokeStatic", "core.clj", 667],
["clojure.core$with_bindings_STAR_", "invokeStatic", "core.clj", 1977],
["clojure.core$with_bindings_STAR_", "doInvoke", "core.clj", 1977],
["clojure.lang.RestFn", "invoke", "RestFn.java", 425],
["clojure.lang.AFn", "applyToHelper", "AFn.java", 156],
["clojure.lang.RestFn", "applyTo", "RestFn.java", 132],
["clojure.core$apply", "invokeStatic", "core.clj", 671],
["clojure.core$bound_fn_STAR_$fn__5767", "doInvoke", "core.clj", 2007],
["clojure.lang.RestFn", "invoke", "RestFn.java", 397],
["clojure.lang.AFn", "run", "AFn.java", 22],
["java.util.concurrent.Executors$RunnableAdapter", "call", "Executors.java", 515],
["java.util.concurrent.FutureTask", "run", "FutureTask.java", 264],
["java.util.concurrent.ThreadPoolExecutor", "runWorker", "ThreadPoolExecutor.java", 1128],
["java.util.concurrent.ThreadPoolExecutor$Worker", "run", "ThreadPoolExecutor.java", 628],
["java.lang.Thread", "run", "Thread.java", 829]],
"_status": 500
}

Hi @jayv
It looks like you are missing the AWT in Java - likely because you didn't include it in headless mode:
https://www.metabase.com/docs/latest/operations-guide/java-versions.html
Have a look here: Dashboard Subscriptions Error Rending Card or Download in .xlsx results in error. Excelt cannot open the file because the file format or file extension is not valid

Thank You. We were able to resolve this