Downloading Error in .xslx Extension

Dua97 · August 1, 2022, 11:33am

Hi,

I am getting the following error when downloading results in the.xslx format:

Below is my diagnostic report:

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.15+10-Ubuntu-0ubuntu0.20.04.1",
"java.vendor": "Private Build",
"java.vendor.url": "Unknown",
"java.version": "11.0.15",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.15+10-Ubuntu-0ubuntu0.20.04.1",
"os.name": "Linux",
"os.version": "5.13.0-1014-aws",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"postgres",
"h2"
],
"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": "2021-03-17",
"tag": "v0.38.2",
"branch": "release-x.38.x",
"hash": "91f0ed6"
},
"settings": {
"report-timezone": null
}
}
}

flamber · August 1, 2022, 11:39am

Hi @Dua97
You should immediately upgrade to a newer release:
https://github.com/metabase/metabase/releases/latest
https://github.com/metabase/metabase/security/advisories/GHSA-vmm4-cwrm-38rj
And you should migrate away from H2 if you are using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html

Open the XLSX file in Notepad to see the stacktrace contents of the file, or look in Metabase > Admin > Troubleshooting > Logs.

Dua97 · August 1, 2022, 11:43am

Does the upgrade have some Metabase Downtime?

flamber · August 1, 2022, 11:53am

@Dua97 You should stop everything you are doing and upgrade immediately. Doesn't matter if there's downtime. In case you somehow never heard of Log4j vulnerability, then try searching the internet.
Just like upgrading anything, there is downtime while you are upgrading. Always backup first.

Timple · October 26, 2022, 4:08pm

@flamber - Need your help!
I do face the same issue. Here is the details:
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:106.0) Gecko/20100101 Firefox/106.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.13+8",
"os.name": "Linux",
"os.version": "4.14.252-131.483.amzn1.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.16"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2021-12-16",
"tag": "v0.41.5",
"branch": "release-x.41.x",
"hash": "fbfffc6"
},
"settings": {
"report-timezone": "US/Eastern"
}
}
}

Timple · October 26, 2022, 4:09pm

Here is the file error...

flamber · October 26, 2022, 5:58pm

@Timple

Upgrade Metabase: https://github.com/metabase/metabase/releases/latest
Make sure that Metabase is able to write files to the Java temp directory, by default /tmp

Timple · October 31, 2022, 7:10am

Thanks @flamber

Point # 2: Can you please elaborate more on this? Where and How?

flamber · October 31, 2022, 9:01am

@Timple Upgrade Metabase, then see which errors it produced (if any) and post the error in plain text (not as screenshot).

Timple · December 16, 2022, 5:36pm

Thank you so much! Upgrade worked