Download in .xlsx results in error. Excelt cannot open the file because the file format or file extension is not valid

1

So whenever I tried to download data, it results in data not being in the proper format. And sometimes there's actually no data.

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.12+7",
    "java.vendor": "Eclipse Foundation",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.12",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.12+7",
    "os.name": "Linux",
    "os.version": "5.4.109+",
    "user.language": "en",
    "user.timezone": "UTC"
  },
  "metabase-info": {
    "databases": [
      "mysql",
      "bigquery",
      "bigquery-cloud-sdk"
    ],
    "hosting-env": "unknown",
    "application-database": "mysql",
    "application-database-details": {
      "database": {
        "name": "MySQL",
        "version": "5.7.34-google-log"
      },
      "jdbc-driver": {
        "name": "MariaDB Connector/J",
        "version": "2.6.2"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-10-06",
      "tag": "v0.41.0",
      "branch": "release-x.41.x",
      "hash": "c529fe2"
    },
    "settings": {
      "report-timezone": "UTC"
    }
  }
}

Here's the result of the .xlsx file

24%20PM
24%20PM2772×244 32.4 KB

2

Hi @yhatch315
Upgrade to 0.41.2: https://github.com/metabase/metabase/releases/latest

3

Hello,

I have the same issue in 0.41.2. :frowning:

{
  "browser-info": {
    "language": "fr",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.55 Safari/537.36 Edg/96.0.1054.34",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.12+7-LTS",
    "java.vendor": "Red Hat, Inc.",
    "java.vendor.url": "https://www.redhat.com/",
    "java.version": "11.0.12",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.12+7-LTS",
    "os.name": "Linux",
    "os.version": "3.10.0-1160.45.1.el7.x86_64",
    "user.language": "en",
    "user.timezone": "Europe/Paris"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "12.1"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.23"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-11-09",
      "tag": "v0.41.2",
      "branch": "release-x.41.x",
      "hash": "ad599fd"
    },
    "settings": {
      "report-timezone": "Europe/Paris"
    }
  }
}

The .xlsx content is :

{
  "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",
      "<init>",
      "SunFontManager.java",
      324
    ],
    [
      "sun.awt.FcFontManager",
      "<init>",
      "FcFontManager.java",
      35
    ],
    [
      "sun.awt.X11FontManager",
      "<init>",
      "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",
      "<init>",
      "TextLayout.java",
      530
    ],
    [
      "org.apache.poi.ss.util.SheetUtil",
      "getDefaultCharWidth",
      "SheetUtil.java",
      285
    ],
    [
      "org.apache.poi.xssf.streaming.AutoSizeColumnTracker",
      "<init>",
      "AutoSizeColumnTracker.java",
      117
    ],
    [
      "org.apache.poi.xssf.streaming.SXSSFSheet",
      "<init>",
      "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__37911",
      "invokeStatic",
      "xlsx.clj",
      455
    ],
    [
      "metabase.query_processor.streaming.xlsx$fn__37911",
      "invoke",
      "xlsx.clj",
      452
    ],
    [
      "clojure.lang.MultiFn",
      "invoke",
      "MultiFn.java",
      234
    ],
    [
      "metabase.query_processor.streaming$streaming_context",
      "invokeStatic",
      "streaming.clj",
      128
    ],
    [
      "metabase.query_processor.streaming$streaming_context",
      "invoke",
      "streaming.clj",
      121
    ],
    [
      "metabase.query_processor.streaming$streaming_context",
      "invokeStatic",
      "streaming.clj",
      133
    ],
    [
      "metabase.query_processor.streaming$streaming_context",
      "invoke",
      "streaming.clj",
      121
    ],
    [
      "metabase.query_processor.streaming$streaming_response_STAR_$fn__38057$fn__38058",
      "invoke",
      "streaming.clj",
      148
    ],
    [
      "metabase.query_processor.streaming$streaming_response_STAR_$fn__38057",
      "invoke",
      "streaming.clj",
      147
    ],
    [
      "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__25228",
      "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
}

Have any idea ?

4

Hi @gmil
That's not the same problem.
The stacktrace seems to indicate that it might be a Java or environment problem.
Can you download as CSV?
Include the stacktrace from Admin > Troubleshooting > Logs.

5

Yes I can export as CSV.

Here's the log

[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:38:14+01:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 8.9 ms (3 appels de DB) Connexions App DB : 2/13 Threads Jetty : 4/50 (3 inactif, 0 en file dattente) (64 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:38:14+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 8.0 ms (2 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (3 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:38:14+01:00 DEBUG metabase.server.middleware.log GET /api/database 200 17.1 ms (4 appels de DB) Connexions App DB : 1/13 Threads Jetty : 3/50 (3 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:38:14+01:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 18.1 ms (4 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (4 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:38:14+01:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 10.2 ms (2 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (4 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:38:14+01:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 15.0 ms (4 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (4 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:38:17+01:00 DEBUG metabase.server.middleware.log GET /api/setting 200 2.1 ms (0 appels de DB) Connexions App DB : 2/13 Threads Jetty : 4/50 (3 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:38:17+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 28.7 ms (2 appels de DB) Connexions App DB : 0/13 Threads Jetty : 4/50 (3 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:38:17+01:00 ERROR metabase.util.i18n.impl Unable to translate string "User lookup filter. The placeholder '{login}' will be replaced by the user supplied login." to fr
java.lang.IllegalArgumentException: can't parse argument number: login
	at java.base/java.text.MessageFormat.makeFormat(MessageFormat.java:1451)
	at java.base/java.text.MessageFormat.applyPattern(MessageFormat.java:491)
	at java.base/java.text.MessageFormat.<init>(MessageFormat.java:390)
	at metabase.util.i18n.impl$message_format.invokeStatic(impl.clj:147)
	at metabase.util.i18n.impl$message_format.invoke(impl.clj:145)
	at metabase.util.i18n.impl$translate.invokeStatic(impl.clj:167)
	at metabase.util.i18n.impl$translate.doInvoke(impl.clj:151)
	at clojure.lang.RestFn.invoke(RestFn.java:425)
	at clojure.lang.AFn.applyToHelper(AFn.java:156)
	at clojure.lang.RestFn.applyTo(RestFn.java:132)
	at clojure.core$apply.invokeStatic(core.clj:671)
	at clojure.core$apply.invoke(core.clj:662)
	at metabase.util.i18n$translate_user_locale.invokeStatic(i18n.clj:60)
	at metabase.util.i18n$translate_user_locale.doInvoke(i18n.clj:57)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at clojure.lang.AFn.applyToHelper(AFn.java:154)
	at clojure.lang.RestFn.applyTo(RestFn.java:132)
	at clojure.core$apply.invokeStatic(core.clj:669)
	at clojure.core$apply.invoke(core.clj:662)
	at metabase.util.i18n.UserLocalizedString.toString(i18n.clj:68)
	at clojure.core$str.invokeStatic(core.clj:555)
	at clojure.core$str.invoke(core.clj:546)
	at metabase.models.setting$user_facing_info.invokeStatic(setting.clj:796)
	at metabase.models.setting$user_facing_info.doInvoke(setting.clj:786)
	at clojure.lang.RestFn.invoke(RestFn.java:410)
	at clojure.lang.AFn.applyToHelper(AFn.java:154)
	at clojure.lang.RestFn.applyTo(RestFn.java:132)
	at clojure.core$apply.invokeStatic(core.clj:669)
	at clojure.core$apply.invoke(core.clj:662)
	at medley.core$mapply.invokeStatic(core.cljc:243)
	at medley.core$mapply.doInvoke(core.cljc:236)
	at clojure.lang.RestFn.invoke(RestFn.java:442)
	at metabase.models.setting$all$iter__21709__21713$fn__21714.invoke(setting.clj:809)
	at clojure.lang.LazySeq.sval(LazySeq.java:42)
	at clojure.lang.LazySeq.seq(LazySeq.java:51)
	at clojure.lang.Cons.next(Cons.java:39)
	at clojure.lang.RT.next(RT.java:713)
	at clojure.core$next__5403.invokeStatic(core.clj:64)
	at clojure.core.protocols$fn__8181.invokeStatic(protocols.clj:169)
	at clojure.core.protocols$fn__8181.invoke(protocols.clj:124)
	at clojure.core.protocols$fn__8136$G__8131__8145.invoke(protocols.clj:19)
	at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31)
	at clojure.core.protocols$fn__8168.invokeStatic(protocols.clj:75)
	at clojure.core.protocols$fn__8168.invoke(protocols.clj:75)
	at clojure.core.protocols$fn__8110$G__8105__8123.invoke(protocols.clj:13)
	at clojure.core$reduce.invokeStatic(core.clj:6830)
	at clojure.core$reduce.invoke(core.clj:6812)
	at cheshire.generate$generate.invokeStatic(generate.clj:133)
	at cheshire.generate$generate.invoke(generate.clj:119)
	at cheshire.core$generate_stream.invokeStatic(core.clj:106)
	at cheshire.core$generate_stream.invoke(core.clj:81)
	at metabase.server.middleware.json$streamed_json_response$fn__82702.invoke(json.clj:78)
	at ring.util.io$piped_input_stream$fn__4401.invoke(io.clj:28)
	at clojure.core$binding_conveyor_fn$fn__5772.invoke(core.clj:2034)
	at clojure.lang.AFn.call(AFn.java:18)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.lang.NumberFormatException: For input string: "login"
	at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
	at java.base/java.lang.Integer.parseInt(Integer.java:652)
	at java.base/java.lang.Integer.parseInt(Integer.java:770)
	at java.base/java.text.MessageFormat.makeFormat(MessageFormat.java:1449)
	... 58 more
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:38:18+01:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 30.4 ms (13 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (4 inactif, 0 en file dattente) (67 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:38:19+01:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 4.6 ms (1 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (4 inactif, 0 en file dattente) (67 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:39:01+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 11.9 ms (2 appels de DB) Connexions App DB : 1/13 Threads Jetty : 4/50 (3 inactif, 0 en file dattente) (67 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:39:01+01:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 10.4 ms (3 appels de DB) Connexions App DB : 1/13 Threads Jetty : 4/50 (3 inactif, 0 en file dattente) (67 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:39:02+01:00 DEBUG metabase.server.middleware.log GET /api/database 200 6.0 ms (3 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (5 inactif, 0 en file dattente) (68 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:39:26+01:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 9.7 ms (3 appels de DB) Connexions App DB : 1/13 Threads Jetty : 4/50 (4 inactif, 0 en file dattente) (68 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:39:26+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 13.3 ms (2 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (4 inactif, 0 en file dattente) (68 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:39:26+01:00 DEBUG metabase.server.middleware.log GET /api/database 200 8.4 ms (3 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (5 inactif, 0 en file dattente) (68 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:39:26+01:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 16.4 ms (4 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (5 inactif, 0 en file dattente) (68 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:39:26+01:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 5.0 ms (2 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (5 inactif, 0 en file dattente) (68 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:39:26+01:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 11.0 ms (4 appels de DB) Connexions App DB : 1/13 Threads Jetty : 3/50 (4 inactif, 0 en file dattente) (68 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:37+01:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 22.8 ms (2 appels de DB) Connexions App DB : 2/13 Threads Jetty : 6/50 (1 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:37+01:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 29.3 ms (3 appels de DB) Connexions App DB : 2/13 Threads Jetty : 5/50 (1 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:37+01:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 30.7 ms (5 appels de DB) Connexions App DB : 1/13 Threads Jetty : 4/50 (2 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:37+01:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 39.5 ms (4 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (3 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:40+01:00 DEBUG metabase.server.middleware.log GET /api/collection/1 200 9.4 ms (3 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (4 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:40+01:00 DEBUG metabase.server.middleware.log GET /api/collection/1/items 200 27.6 ms (5 appels de DB) Connexions App DB : 1/13 Threads Jetty : 4/50 (3 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:40+01:00 DEBUG metabase.server.middleware.log GET /api/collection/1/items 200 28.5 ms (6 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (3 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:41+01:00 DEBUG metabase.server.middleware.log GET /api/card/17 200 49.5 ms (10 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (4 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:41+01:00 DEBUG metabase.server.middleware.log GET /api/alert/question/17 200 4.0 ms (1 appels de DB) Connexions App DB : 2/13 Threads Jetty : 4/50 (3 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:41+01:00 DEBUG metabase.server.middleware.log GET /api/table/17/query_metadata 200 43.0 ms (11 appels de DB) Connexions App DB : 3/13 Threads Jetty : 5/50 (2 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:41+01:00 DEBUG metabase.server.middleware.log GET /api/table/154/query_metadata 200 43.5 ms (10 appels de DB) Connexions App DB : 1/13 Threads Jetty : 4/50 (2 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:41+01:00 DEBUG metabase.server.middleware.log GET /api/table/26/query_metadata 200 53.8 ms (10 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (3 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:41+01:00 DEBUG metabase.server.middleware.log GET /api/table/96/query_metadata 200 33.8 ms (8 appels de DB) Connexions App DB : 2/13 Threads Jetty : 5/50 (2 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:41+01:00 DEBUG metabase.server.middleware.log GET /api/table/268/query_metadata 200 28.9 ms (10 appels de DB) Connexions App DB : 2/13 Threads Jetty : 5/50 (2 inactif, 0 en file dattente) (65 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:41+01:00 DEBUG metabase.server.middleware.log GET /api/table/291/query_metadata 200 43.3 ms (10 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (3 inactif, 0 en file dattente) (66 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/17/query 202 [ASYNC: completed] 273.1 ms (20 appels de DB) Connexions App DB : 2/13 Threads Jetty : 2/50 (4 inactif, 0 en file dattente) (67 total de threads actifs) Requêtes en cours : 0 (0 en file dattente); postgres DB 2 connections: 0/1 (0 threads blocked)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:46+01:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 7.9 ms (3 appels de DB) Connexions App DB : 2/13 Threads Jetty : 5/50 (2 inactif, 0 en file dattente) (67 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:46+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 13.1 ms (2 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (3 inactif, 0 en file dattente) (67 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:40:46+01:00 DEBUG metabase.server.middleware.log GET /api/database 200 8.4 ms (3 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (4 inactif, 0 en file dattente) (67 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.task.sync-databases Lancement de la tâche de synchronisation pour la base de données 1.
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util STARTING: Sync metadata for h2 Base de données 1 'Sample Dataset'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util STARTING: étape 'sync-timezone' pour h2 Base de données 1 'Sample Dataset'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util FINISHED: étape 'sync-timezone' pour h2 Base de données 1 'Sample Dataset' (6.8 ms)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util STARTING: étape 'sync-tables' pour h2 Base de données 1 'Sample Dataset'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util FINISHED: étape 'sync-tables' pour h2 Base de données 1 'Sample Dataset' (6.7 ms)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.sync-metadata.tables Mise à jour de la description des tables: (Table  'PUBLIC.PEOPLE' Table  'PUBLIC.REVIEWS' Table  'PUBLIC.ORDERS' Table  'PUBLIC.PRODUCTS')
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util STARTING: étape 'sync-fields' pour h2 Base de données 1 'Sample Dataset'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util FINISHED: étape 'sync-fields' pour h2 Base de données 1 'Sample Dataset' (63.9 ms)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util STARTING: étape 'sync-fks' pour h2 Base de données 1 'Sample Dataset'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util FINISHED: étape 'sync-fks' pour h2 Base de données 1 'Sample Dataset' (11.9 ms)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util STARTING: étape 'sync-metabase-metadata' pour h2 Base de données 1 'Sample Dataset'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util FINISHED: étape 'sync-metabase-metadata' pour h2 Base de données 1 'Sample Dataset' (540.6 ms)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util FINISHED: Sync metadata for h2 Base de données 1 'Sample Dataset' (679.7 ms)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util STARTING: Analyze data for h2 Base de données 1 'Sample Dataset'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util STARTING: étape 'fingerprint-fields' pour h2 Base de données 1 'Sample Dataset'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [*******···········································]    15% Table 1 'PUBLIC.PRODUCTS'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [***************···································]    31% Table 4 'PUBLIC.REVIEWS'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util FINISHED: étape 'fingerprint-fields' pour h2 Base de données 1 'Sample Dataset' (21.4 ms)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util STARTING: étape 'classify-fields' pour h2 Base de données 1 'Sample Dataset'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.analyze classify-fields Analyzed [***********************···························]    46% Table 1 'PUBLIC.PRODUCTS'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.analyze classify-fields Analyzed [******************************····················]    62% Table 4 'PUBLIC.REVIEWS'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.analyze classify-tables Analyzed [**************************************············]    77% Table 1 'PUBLIC.PRODUCTS'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util FINISHED: étape 'classify-fields' pour h2 Base de données 1 'Sample Dataset' (13.2 ms)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util STARTING: étape 'classify-tables' pour h2 Base de données 1 'Sample Dataset'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.analyze classify-tables Analyzed [**********************************************····]    92% Table 4 'PUBLIC.REVIEWS'
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util FINISHED: étape 'classify-tables' pour h2 Base de données 1 'Sample Dataset' (3.1 ms)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 INFO metabase.sync.util FINISHED: Analyze data for h2 Base de données 1 'Sample Dataset' (80.7 ms)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:00+01:00 DEBUG metabase.server.middleware.log POST /api/card/17/query/xlsx 202 [ASYNC: completed] 28.7 ms (5 appels de DB) Connexions App DB : 1/13 Threads Jetty : 2/50 (4 inactif, 0 en file dattente) (68 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:04+01:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 15.1 ms (3 appels de DB) Connexions App DB : 2/13 Threads Jetty : 6/50 (0 inactif, 0 en file dattente) (68 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:04+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 20.6 ms (2 appels de DB) Connexions App DB : 1/13 Threads Jetty : 5/50 (1 inactif, 0 en file dattente) (68 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
[449ecc69-e0ea-47b6-a1d7-3892ef111b49] 2021-12-02T17:41:04+01:00 DEBUG metabase.server.middleware.log GET /api/database 200 9.3 ms (3 appels de DB) Connexions App DB : 0/13 Threads Jetty : 3/50 (4 inactif, 0 en file dattente) (68 total de threads actifs) Requêtes en cours : 0 (0 en file dattente)
6

@gmil So there's no stacktrace in Metabase. I'm 95% sure it's a problem in your Java environment.
Try updating to latest Java 11: https://www.metabase.com/docs/latest/operations-guide/java-versions.html
Or try using Docker.

7

@flamber
You're right. It comes from my system environment. Dependencies were missing.
Here's the fix, in my case on RHEL/CENTOS, see the source for the others system environment :

yum install freetype fontconfig dejavu-sans-fonts

source

Thanks for your help :slight_smile:

1 Like
8

I have exactly the same problem in v 0.41.5 and 0.41.4

Here is the content of the resulting file:
{"database_id":2,"started_at":"2022-01-19T16:14:59.866785Z","via":[{"status":"failed","class":"class clojure.lang.ExceptionInfo","error":"Error al reducir las filas de resultados","stacktrace":["--> query_processor.context.default$default_reducef$fn__42412.invoke(default.clj:60)","query_processor.context.default$default_reducef.invokeStatic(default.clj:57)","query_processor.context.default$default_reducef.invoke(default.clj:48)","query_processor.context$reducef.invokeStatic(context.clj:69)","query_processor.context$reducef.invoke(context.clj:62)","query_processor.context.default$default_runf$respond_STAR___42416.invoke(default.clj:69)","driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:509)","driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)","driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)","driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)","driver.sql_jdbc$fn__85172.invokeStatic(sql_jdbc.clj:54)","driver.sql_jdbc$fn__85172.invoke(sql_jdbc.clj:52)","query_processor.context$executef.invokeStatic(context.clj:59)","query_processor.context$executef.invoke(context.clj:48)","query_processor.context.default$default_runf.invokeStatic(default.clj:68)","query_processor.context.default$default_runf.invoke(default.clj:66)","query_processor.context$runf.invokeStatic(context.clj:45)","query_processor.context$runf.invoke(context.clj:39)","query_processor.reducible$pivot.invokeStatic(reducible.clj:34)","query_processor.reducible$pivot.invoke(reducible.clj:31)","query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49144.invoke(mbql_to_native.clj:25)","query_processor.middleware.check_features$check_features$fn__49630.invoke(check_features.clj:39)","query_processor.middleware.limit$limit$fn__47517.invoke(limit.clj:37)","query_processor.middleware.cache$maybe_return_cached_results$fn__50004.invoke(cache.clj:204)","query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__50997.invoke(optimize_temporal_filters.clj:204)","query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51041.invoke(validate_temporal_bucketing.clj:50)","query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49201.invoke(auto_parse_filter_values.clj:43)","query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39249.invoke(wrap_value_literals.clj:161)","query_processor.middleware.annotate$add_column_info$fn__43680.invoke(annotate.clj:620)","query_processor.middleware.permissions$check_query_permissions$fn__45618.invoke(permissions.clj:108)","query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__50181.invoke(pre_alias_aggregations.clj:40)","query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46016.invoke(cumulative_aggregations.clj:60)","query_processor.middleware.visualization_settings$update_viz_settings$fn__45954.invoke(visualization_settings.clj:62)","query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47115.invoke(resolve_joined_fields.clj:102)","query_processor.middleware.resolve_joins$resolve_joins$fn__50767.invoke(resolve_joins.clj:171)","query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__50303.invoke(add_implicit_joins.clj:190)","query_processor.middleware.large_int_id$convert_id_to_string$fn__47134.invoke(large_int_id.clj:59)","query_processor.middleware.format_rows$format_rows$fn__50355.invoke(format_rows.clj:74)","query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46506.invoke(add_default_temporal_unit.clj:23)","query_processor.middleware.desugar$desugar$fn__45927.invoke(desugar.clj:21)","query_processor.middleware.binning$update_binning_strategy$fn__39149.invoke(binning.clj:229)","query_processor.middleware.resolve_fields$resolve_fields$fn__45261.invoke(resolve_fields.clj:34)","query_processor.middleware.add_dimension_projections$add_remapping$fn__49556.invoke(add_dimension_projections.clj:314)","query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__49853.invoke(add_implicit_clauses.clj:147)","query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47502.invoke(upgrade_field_literals.clj:40)","query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__46883.invoke(add_source_metadata.clj:123)","query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50103.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)","query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48453.invoke(auto_bucket_datetimes.clj:147)","query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45242.invoke(resolve_source_table.clj:45)","query_processor.middleware.parameters$substitute_parameters$fn__48107.invoke(parameters.clj:111)","query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45315.invoke(resolve_referenced.clj:79)","query_processor.middleware.expand_macros$expand_macros$fn__51425.invoke(expand_macros.clj:184)","query_processor.middleware.add_timezone_info$add_timezone_info$fn__47886.invoke(add_timezone_info.clj:15)","query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50370.invoke(splice_params_in_response.clj:32)","query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49864$fn__49868.invoke(resolve_database_and_driver.clj:31)","driver$do_with_driver.invokeStatic(driver.clj:60)","driver$do_with_driver.invoke(driver.clj:56)","query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49864.invoke(resolve_database_and_driver.clj:25)","query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45865.invoke(fetch_source_query.clj:274)","query_processor.middleware.store$initialize_store$fn__46053$fn__46054.invoke(store.clj:11)","query_processor.store$do_with_store.invokeStatic(store.clj:44)","query_processor.store$do_with_store.invoke(store.clj:38)","query_processor.middleware.store$initialize_store$fn__46053.invoke(store.clj:10)","query_processor.middleware.validate$validate_query$fn__50153.invoke(validate.clj:10)","query_processor.middleware.normalize_query$normalize$fn__50160.invoke(normalize_query.clj:22)","query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47832.invoke(add_rows_truncated.clj:35)","query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49130.invoke(results_metadata.clj:143)","query_processor.middleware.constraints$add_default_userland_constraints$fn__47850.invoke(constraints.clj:42)","query_processor.middleware.process_userland_query$process_userland_query$fn__50139.invoke(process_userland_query.clj:146)","query_processor.middleware.catch_exceptions$catch_exceptions$fn__50450.invoke(catch_exceptions.clj:169)","query_processor.reducible$async_qp$qp_STAR___42500$thunk__42501.invoke(reducible.clj:103)","query_processor.reducible$async_qp$qp_STAR___42500$fn__42503.invoke(reducible.clj:108)"],"error_type":"qp","ex-data":{"type":"qp"}}],"error_type":"qp","json_query":{"type":"query","query":{"source-table":8,"joins":[{"fields":[["field",175,{"join-alias":"users_user - user1_id"}]],"source-table":23,"condition":["=",["field",60,null],["field",179,{"join-alias":"users_user - user1_id"}]],"alias":"users_user - user1_id"},{"fields":[["field",175,{"join-alias":"users_user - user2_id"}],["field",165,{"join-alias":"users_user - user2_id"}]],"source-table":23,"condition":["=",["field",64,null],["field",179,{"join-alias":"users_user - user2_id"}]],"alias":"users_user - user2_id"},{"fields":[["field",219,{"join-alias":"chatmessages_chatmessage","temporal-unit":"default"}],["field",214,{"join-alias":"chatmessages_chatmessage"}],["field",215,{"join-alias":"chatmessages_chatmessage"}]],"source-table":26,"condition":["=",["field",59,null],["field",220,{"join-alias":"chatmessages_chatmessage"}]],"alias":"chatmessages_chatmessage"}],"fields":[["field",59,null]],"order-by":[["desc",["field",219,{"join-alias":"chatmessages_chatmessage"}]]],"filter":["=",["field",214,{"join-alias":"chatmessages_chatmessage"}],"unread"]},"database":2,"middleware":{"process-viz-settings?":true,"skip-results-metadata?":true,"format-rows?":false},"async?":true,"viz-settings":{"table.pivot":false,"metabase.shared.models.visualization-settings/table-columns":[{"metabase.shared.models.visualization-settings/table-column-name":"id","metabase.shared.models.visualization-settings/table-column-field-ref":["field",59,null],"metabase.shared.models.visualization-settings/table-column-enabled":true},{"metabase.shared.models.visualization-settings/table-column-name":"created","metabase.shared.models.visualization-settings/table-column-field-ref":["field",219,{"join-alias":"chatmessages_chatmessage","temporal-unit":"default"}],"metabase.shared.models.visualization-settings/table-column-enabled":true},{"metabase.shared.models.visualization-settings/table-column-name":"status","metabase.shared.models.visualization-settings/table-column-field-ref":["field",214,{"join-alias":"chatmessages_chatmessage"}],"metabase.shared.models.visualization-settings/table-column-enabled":true},{"metabase.shared.models.visualization-settings/table-column-name":"first_name","metabase.shared.models.visualization-settings/table-column-field-ref":["field",175,{"join-alias":"users_user - user1_id"}],"metabase.shared.models.visualization-settings/table-column-enabled":true},{"metabase.shared.models.visualization-settings/table-column-name":"first_name_2","metabase.shared.models.visualization-settings/table-column-field-ref":["field",175,{"join-alias":"users_user - user2_id"}],"metabase.shared.models.visualization-settings/table-column-enabled":true},{"metabase.shared.models.visualization-settings/table-column-name":"email","metabase.shared.models.visualization-settings/table-column-field-ref":["field",165,{"join-alias":"users_user - user2_id"}],"metabase.shared.models.visualization-settings/table-column-enabled":true},{"metabase.shared.models.visualization-settings/table-column-name":"message","metabase.shared.models.visualization-settings/table-column-field-ref":["field",215,{"join-alias":"chatmessages_chatmessage"}],"metabase.shared.models.visualization-settings/table-column-enabled":true}],"metabase.shared.models.visualization-settings/column-settings":{},"table.cell_column":"message","card.title":"Conversaciones","table.column_formatting":[],"card.description":null,"table.pivot_column":"status"}},"native":{"query":"SELECT "public"."conversations_conversation"."id" AS "id", "users_user - user1_id"."first_name" AS "users_user - user1_id__first_name", "users_user - user2_id"."first_name" AS "users_user - user2_id__first_name", "users_user - user2_id"."email" AS "users_user - user2_id__email", "chatmessages_chatmessage"."created" AS "chatmessages_chatmessage__created", "chatmessages_chatmessage"."status" AS "chatmessages_chatmessage__status", "chatmessages_chatmessage"."message" AS "chatmessages_chatmessage__message" FROM "public"."conversations_conversation" LEFT JOIN "public"."users_user" "users_user - user1_id" ON "public"."conversations_conversation"."user1_id" = "users_user - user1_id"."id" LEFT JOIN "public"."users_user" "users_user - user2_id" ON "public"."conversations_conversation"."user2_id" = "users_user - user2_id"."id" LEFT JOIN "public"."chatmessages_chatmessage" "chatmessages_chatmessage" ON "public"."conversations_conversation"."id" = "chatmessages_chatmessage"."conversation_id" WHERE "chatmessages_chatmessage"."status" = ? ORDER BY "chatmessages_chatmessage"."created" DESC LIMIT 1048575","params":["unread"]},"status":"failed","class":"class java.lang.IllegalArgumentException","stacktrace":["org.apache.poi.ss.usermodel.CellBase.checkLength(CellBase.java:293)","org.apache.poi.ss.usermodel.CellBase.setCellValue(CellBase.java:274)","--> query_processor.streaming.xlsx$fn__37840.invokeStatic(xlsx.clj:349)","query_processor.streaming.xlsx$fn__37840.invoke(xlsx.clj:347)","query_processor.streaming.xlsx$add_row_BANG_.invokeStatic(xlsx.clj:406)","query_processor.streaming.xlsx$add_row_BANG_.invoke(xlsx.clj:383)","query_processor.streaming.xlsx$fn$reify__37917$fn__37939.invoke(xlsx.clj:478)","query_processor.streaming.xlsx$fn$reify__37917.write_row_BANG_(xlsx.clj:477)","query_processor.streaming$streaming_rff$fn__37999$fn__38004.invoke(streaming.clj:110)","query_processor.middleware.process_userland_query$add_and_save_execution_info_xform_BANG_$execution_info_rf_STAR___50130.invoke(process_userland_query.clj:101)","query_processor.middleware.add_rows_truncated$add_rows_truncated_xform$fn__47827.invoke(add_rows_truncated.clj:27)","query_processor.middleware.limit$limit_xform$fn__47514.invoke(limit.clj:24)","query_processor.reducible$reducible_rows$reify__42516.reduce(reducible.clj:159)","query_processor.context.default$default_reducef$fn__42412.invoke(default.clj:58)","query_processor.context.default$default_reducef.invokeStatic(default.clj:57)","query_processor.context.default$default_reducef.invoke(default.clj:48)","query_processor.context$reducef.invokeStatic(context.clj:69)","query_processor.context$reducef.invoke(context.clj:62)","query_processor.context.default$default_runf$respond_STAR___42416.invoke(default.clj:69)","driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:509)","driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)","driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)","driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)","driver.sql_jdbc$fn__85172.invokeStatic(sql_jdbc.clj:54)","driver.sql_jdbc$fn__85172.invoke(sql_jdbc.clj:52)","query_processor.context$executef.invokeStatic(context.clj:59)","query_processor.context$executef.invoke(context.clj:48)","query_processor.context.default$default_runf.invokeStatic(default.clj:68)","query_processor.context.default$default_runf.invoke(default.clj:66)","query_processor.context$runf.invokeStatic(context.clj:45)","query_processor.context$runf.invoke(context.clj:39)","query_processor.reducible$pivot.invokeStatic(reducible.clj:34)","query_processor.reducible$pivot.invoke(reducible.clj:31)","query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49144.invoke(mbql_to_native.clj:25)","query_processor.middleware.check_features$check_features$fn__49630.invoke(check_features.clj:39)","query_processor.middleware.limit$limit$fn__47517.invoke(limit.clj:37)","query_processor.middleware.cache$maybe_return_cached_results$fn__50004.invoke(cache.clj:204)","query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__50997.invoke(optimize_temporal_filters.clj:204)","query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51041.invoke(validate_temporal_bucketing.clj:50)","query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49201.invoke(auto_parse_filter_values.clj:43)","query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39249.invoke(wrap_value_literals.clj:161)","query_processor.middleware.annotate$add_column_info$fn__43680.invoke(annotate.clj:620)","query_processor.middleware.permissions$check_query_permissions$fn__45618.invoke(permissions.clj:108)","query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__50181.invoke(pre_alias_aggregations.clj:40)","query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46016.invoke(cumulative_aggregations.clj:60)","query_processor.middleware.visualization_settings$update_viz_settings$fn__45954.invoke(visualization_settings.clj:62)","query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47115.invoke(resolve_joined_fields.clj:102)","query_processor.middleware.resolve_joins$resolve_joins$fn__50767.invoke(resolve_joins.clj:171)","query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__50303.invoke(add_implicit_joins.clj:190)","query_processor.middleware.large_int_id$convert_id_to_string$fn__47134.invoke(large_int_id.clj:59)","query_processor.middleware.format_rows$format_rows$fn__50355.invoke(format_rows.clj:74)","query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46506.invoke(add_default_temporal_unit.clj:23)","query_processor.middleware.desugar$desugar$fn__45927.invoke(desugar.clj:21)","query_processor.middleware.binning$update_binning_strategy$fn__39149.invoke(binning.clj:229)","query_processor.middleware.resolve_fields$resolve_fields$fn__45261.invoke(resolve_fields.clj:34)","query_processor.middleware.add_dimension_projections$add_remapping$fn__49556.invoke(add_dimension_projections.clj:314)","query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__49853.invoke(add_implicit_clauses.clj:147)","query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47502.invoke(upgrade_field_literals.clj:40)","query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__46883.invoke(add_source_metadata.clj:123)","query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50103.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)","query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48453.invoke(auto_bucket_datetimes.clj:147)","query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45242.invoke(resolve_source_table.clj:45)","query_processor.middleware.parameters$substitute_parameters$fn__48107.invoke(parameters.clj:111)","query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45315.invoke(resolve_referenced.clj:79)","query_processor.middleware.expand_macros$expand_macros$fn__51425.invoke(expand_macros.clj:184)","query_processor.middleware.add_timezone_info$add_timezone_info$fn__47886.invoke(add_timezone_info.clj:15)","query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50370.invoke(splice_params_in_response.clj:32)","query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49864$fn__49868.invoke(resolve_database_and_driver.clj:31)","driver$do_with_driver.invokeStatic(driver.clj:60)","driver$do_with_driver.invoke(driver.clj:56)","query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49864.invoke(resolve_database_and_driver.clj:25)","query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45865.invoke(fetch_source_query.clj:274)","query_processor.middleware.store$initialize_store$fn__46053$fn__46054.invoke(store.clj:11)","query_processor.store$do_with_store.invokeStatic(store.clj:44)","query_processor.store$do_with_store.invoke(store.clj:38)","query_processor.middleware.store$initialize_store$fn__46053.invoke(store.clj:10)","query_processor.middleware.validate$validate_query$fn__50153.invoke(validate.clj:10)","query_processor.middleware.normalize_query$normalize$fn__50160.invoke(normalize_query.clj:22)","query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47832.invoke(add_rows_truncated.clj:35)","query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49130.invoke(results_metadata.clj:143)","query_processor.middleware.constraints$add_default_userland_constraints$fn__47850.invoke(constraints.clj:42)","query_processor.middleware.process_userland_query$process_userland_query$fn__50139.invoke(process_userland_query.clj:146)","query_processor.middleware.catch_exceptions$catch_exceptions$fn__50450.invoke(catch_exceptions.clj:169)","query_processor.reducible$async_qp$qp_STAR___42500$thunk__42501.invoke(reducible.clj:103)","query_processor.reducible$async_qp$qp_STAR___42500$fn__42503.invoke(reducible.clj:108)"],"card_id":null,"context":"xlsx-download","error":"The maximum length of cell contents (text) is 32767 characters","row_count":0,"running_time":0,"preprocessed":{"type":"query","query":{"source-table":8,"fields":[["field",59,null],["field",175,{"join-alias":"users_user - user1_id"}],["field",175,{"join-alias":"users_user - user2_id"}],["field",165,{"join-alias":"users_user - user2_id"}],["field",219,{"join-alias":"chatmessages_chatmessage","temporal-unit":"default"}],["field",214,{"join-alias":"chatmessages_chatmessage"}],["field",215,{"join-alias":"chatmessages_chatmessage"}]],"order-by":[["desc",["field",219,{"join-alias":"chatmessages_chatmessage","temporal-unit":"default"}]]],"filter":["=",["field",214,{"join-alias":"chatmessages_chatmessage"}],["value","unread",{"base_type":"type/Text","effective_type":"type/Text","coercion_strategy":null,"semantic_type":"type/Category","database_type":"varchar","name":"status"}]],"joins":[{"strategy":"left-join","source-table":23,"condition":["=",["field",60,null],["field",179,{"join-alias":"users_user - user1_id"}]],"alias":"users_user - user1_id"},{"strategy":"left-join","source-table":23,"condition":["=",["field",64,null],["field",179,{"join-alias":"users_user - user2_id"}]],"alias":"users_user - user2_id"},{"strategy":"left-join","source-table":26,"condition":["=",["field",59,null],["field",220,{"join-alias":"chatmessages_chatmessage"}]],"alias":"chatmessages_chatmessage"}],"limit":1048575},"database":2,"middleware":{"process-viz-settings?":true,"skip-results-metadata?":true,"format-rows?":false},"async?":true,"info":{"executed-by":1,"context":"xlsx-download","nested?":false,"query-hash":"0x72B3F548"}},"data":{"rows":[],"cols":[]}}

9

@cdiaz Completely different error you are seeing: The maximum length of cell contents (text) is 32767 characters
That's a limitation of XLSX format, so you should truncate your columns to shorter length.
https://www.metabase.com/docs/latest/users-guide/expressions-list.html#substring

10

anyone seen this? when I download excel file, I see this:

{"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.GeneratedConstructorAccessor237","newInstance",null,-1]},{"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",10
[details="Summary"]
This text will be hidden
[/details]
7],["sun.awt.X11FontManager","createFontConfiguration","X11FontManager.java",719],["sun.font.SunFontManager$2","run","SunFontManager.java",367],["java.security.AccessController","doPrivileged","AccessController.java",-2],["sun.font.SunFontManager","<init>","SunFontManager.java",312],["sun.awt.FcFontManager","<init>","FcFontManager.java",35],["sun.awt.X11FontManager","<init>","X11FontManager.java",56],["jdk.internal.reflect.GeneratedConstructorAccessor237","newInstance",null,-1],["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",2246],["java.awt.font.TextLayout","singleFont","TextLayout.java",469],["java.awt.font.TextLayout","<init>","TextLayout.java",530],["org.apache.poi.ss.util.SheetUtil","getDefaultCharWidth","SheetUtil.java",301],["org.apache.poi.xssf.streaming.AutoSizeColumnTracker","<init>","AutoSizeColumnTracker.java",117],["org.apache.poi.xssf.streaming.SXSSFSheet","<init>","SXSSFSheet.java",95],["org.apache.poi.xssf.streaming.SXSSFWorkbook","createAndRegisterSXSSFSheet","SXSSFWorkbook.java",726],["org.apache.poi.xssf.streaming.SXSSFWorkbook","createSheet","SXSSFWorkbook.java",745],["org.apache.poi.xssf.streaming.SXSSFWorkbook","createSheet","SXSSFWorkbook.java",102],["dk.ative.docjure.spreadsheet$add_sheet_BANG_","invokeStatic","spreadsheet.clj",351],["dk.ative.docjure.spreadsheet$add_sheet_BANG_","invoke","spreadsheet.clj",347],["metabase.query_processor.streaming.xlsx$fn__54155","invokeStatic","xlsx.clj",496],["metabase.query_processor.streaming.xlsx$fn__54155","invoke","xlsx.clj",493],["clojure.lang.MultiFn","invoke","MultiFn.java",234],["metabase.query_processor.streaming$streaming_context","invokeStatic","streaming.clj",145],["metabase.query_processor.streaming$streaming_context","invoke","streaming.clj",138],["metabase.query_processor.streaming$streaming_context","invokeStatic","streaming.clj",151],["metabase.query_processor.streaming$streaming_context","invoke","streaming.clj",138],["metabase.query_processor.streaming$streaming_response_STAR_$fn__54305$fn__54306","invoke","streaming.clj",166],["metabase.query_processor.streaming$streaming_response_STAR_$fn__54305","invoke","streaming.clj",165],["clojure.lang.AFn","applyToHelper","AFn.java",156],["clojure.lang.AFn","applyTo","AFn.java",144],["clojure.core$apply","invokeStatic","core.clj",667],["clojure.core$with_bindings_STAR_","invokeStatic","core.clj",1990],["clojure.core$with_bindings_STAR_","doInvoke","core.clj",1990],["clojure.lang.RestFn","applyTo","RestFn.java",142],["clojure.core$apply","invokeStatic","core.clj",671],["clojure.core$bound_fn_STAR_$fn__5818","doInvoke","core.clj",2020],["clojure.lang.RestFn","invoke","RestFn.java",421],["metabase.async.streaming_response$do_f_STAR_","invokeStatic","streaming_response.clj",69],["metabase.async.streaming_response$do_f_STAR_","invoke","streaming_response.clj",67],["metabase.async.streaming_response$do_f_async$task__36922","invoke","streaming_response.clj",88],["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",834]],"_status":500}
11

Post diagnostic info