Hi,
I am getting error when trying to export an Excel file. The xlsx file exported is corrupted.
Please help us to resolve this issue asap.
Hi,
I am getting error when trying to export an Excel file. The xlsx file exported is corrupted.
Please help us to resolve this issue asap.
please post troubleshooting 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/113.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "11.0.5+10-LTS",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "11.0.5",
"java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version": "11.0.5+10-LTS",
"os.name": "Linux",
"os.version": "3.10.0-1062.9.1.el7.x86_64",
"user.language": "en",
"user.timezone": "Asia/Kolkata"
},
"metabase-info": {
"databases": [
"sqlserver",
"postgres",
"mysql",
"oracle",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.8"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.4"
}
},
"run-mode": "prod",
"version": {
"date": "2023-09-07",
"tag": "v0.47.1",
"branch": "release-x.47.x",
"hash": "bd278b9"
},
"settings": {
"report-timezone": "Asia/Calcutta"
}
}
}
Any luck solving this ? I'm having the exact same issue with the excel downloads since upgrading to v0.46.6.1
if the problem is that the file takes a lot of time and then it fails, we made a patch on 47.4
I'm frequently having hte same problem on v1.47.4. Normally it happens with tables with many rows/columns
Has there been any feedback on issues with exporting excel files that end in beiing corrupted?
My customer is on version 0.49.3 and still has the issue now and then.
Only solution is to restart the java application.
I've had the issue with this customer on different versions of Metabase where I initialy thought the update fixed it, but it was probably just the restart.
What is the error message that you are seeing?
Hello everyone,
I have the same problem. Is there a solution to this? The error means that dashboard emails with xlsx attachments are not sent.
Thank you for a quick reply!
If you open the file with a text editor instead of xlsx what error do you get prompted?
Hey ToniC,
{"via":[{"type":"java.lang.IllegalStateException","message":"java.nio.file.NoSuchFileException: C:\Users\Metabase-Server\AppData\Local\Temp\poifiles\poi-sxssf-sheet1009379297935900637.xml","at":["org.apache.poi.xssf.streaming.SXSSFWorkbook","createAndRegisterSXSSFSheet","SXSSFWorkbook.java",696]},{"type":"java.nio.file.NoSuchFileException","message":"C:\Users\Metabase-Server\AppData\Local\Temp\poifiles\poi-sxssf-sheet1009379297935900637.xml","at":["sun.nio.fs.WindowsException","translateToIOException",null,-1]}],"trace":[["sun.nio.fs.WindowsException","translateToIOException",null,-1],["sun.nio.fs.WindowsException","rethrowAsIOException",null,-1],["sun.nio.fs.WindowsException","rethrowAsIOException",null,-1],["sun.nio.fs.WindowsFileSystemProvider","newByteChannel",null,-1],["java.nio.file.Files","newByteChannel",null,-1],["java.nio.file.Files","createFile",null,-1],["java.nio.file.TempFileHelper","create",null,-1],["java.nio.file.TempFileHelper","createTempFile",null,-1],["java.nio.file.Files","createTempFile",null,-1],["org.apache.poi.util.DefaultTempFileCreationStrategy","createTempFile","DefaultTempFileCreationStrategy.java",102],["org.apache.poi.util.TempFile","createTempFile","TempFile.java",67],["org.apache.poi.xssf.streaming.SheetDataWriter","createTempFile","SheetDataWriter.java",100],["org.apache.poi.xssf.streaming.SheetDataWriter","","SheetDataWriter.java",74],["org.apache.poi.xssf.streaming.SheetDataWriter","","SheetDataWriter.java",84],["org.apache.poi.xssf.streaming.SXSSFWorkbook","createSheetDataWriter","SXSSFWorkbook.java",387],["org.apache.poi.xssf.streaming.SXSSFSheet","","SXSSFSheet.java",103],["org.apache.poi.xssf.streaming.SXSSFWorkbook","createAndRegisterSXSSFSheet","SXSSFWorkbook.java",694],["org.apache.poi.xssf.streaming.SXSSFWorkbook","createSheet","SXSSFWorkbook.java",712],["org.apache.poi.xssf.streaming.SXSSFWorkbook","createSheet","SXSSFWorkbook.java",104],["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__53171","invokeStatic","xlsx.clj",453],["metabase.query_processor.streaming.xlsx$fn__53171","invoke","xlsx.clj",450],["clojure.lang.MultiFn","invoke","MultiFn.java",234],["metabase.query_processor.streaming$streaming_context_and_rff","invokeStatic","streaming.clj",146],["metabase.query_processor.streaming$streaming_context_and_rff","invoke","streaming.clj",138],["metabase.query_processor.streaming$streaming_context_and_rff","invokeStatic","streaming.clj",152],["metabase.query_processor.streaming$streaming_context_and_rff","invoke","streaming.clj",138],["metabase.query_processor.streaming$streaming_response_STAR_$fn__53319","invoke","streaming.clj",166],["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__43774","invoke","streaming_response.clj",88],["clojure.lang.AFn","run","AFn.java",22],["java.util.concurrent.Executors$RunnableAdapter","call",null,-1],["java.util.concurrent.FutureTask","run",null,-1],["java.util.concurrent.ThreadPoolExecutor","runWorker",null,-1],["java.util.concurrent.ThreadPoolExecutor$Worker","run",null,-1],["java.lang.Thread","run",null,-1]],"cause":"C:\Users\Metabase-Server\AppData\Local\Temp\poifiles\poi-sxssf-sheet1009379297935900637.xml","_status":500}
Metabase is using the /tmp directory for the .xml files before downloading the .xlsx are you doing anything to the /tmp directory that you are aware of?
Thank you for your answers, it only fixes the problem for the moment... but unfortunately it reoccurs a short time later. Is there still a permanent solution for this? We now automatically restart the server several times a day as a temporary solution...