Cannot open metabase downloaded xlsx

Get Help
1

Hi, suddenly i cannot open downloaded xlsx from metabase. Previoulsy all good and fine. Any idea why suddenly not working and suggestion to fix?

We restarted the instance but issue is not resolved.

I’m using 0.36.6 and this is what appears when i open the xlsx

{
  "database_id": 2,
  "started_at": "2021-01-26T11:08:02.596682+07:00",
  "via": [
    {
      "status": "failed",
      "class": "class org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException",
      "error": "Fail to save: an error occurs while saving the package : The part /docProps/app.xml failed to be saved in the stream with marshaller org.apache.poi.openxml4j.opc.internal.marshallers.DefaultMarshaller@724ad123",
      "stacktrace": [
        "org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:595)",
        "org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1539)",
        "org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:227)",
        "org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:929)",
        "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)",
        "--> query_processor.streaming.xlsx$fn$reify__35434.finish_BANG_(xlsx.clj:79)",
        "query_processor.streaming$streaming_reducedf$fn__35446.invoke(streaming.clj:40)",
        "query_processor.context$reducedf.invokeStatic(context.clj:77)",
        "query_processor.context$reducedf.invoke(context.clj:72)",
        "query_processor.context.default$default_reducef.invokeStatic(default.clj:65)",
        "query_processor.context.default$default_reducef.invoke(default.clj:49)",
        "query_processor.context$reducef.invokeStatic(context.clj:69)",
        "query_processor.context$reducef.invoke(context.clj:62)",
        "query_processor.context.default$default_runf$respond_STAR___37992.invoke(default.clj:70)",
        "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:392)",
        "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)",
        "driver.sql_jdbc$fn__73933.invokeStatic(sql_jdbc.clj:49)",
        "driver.sql_jdbc$fn__73933.invoke(sql_jdbc.clj:47)",
        "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:69)",
        "query_processor.context.default$default_runf.invoke(default.clj:67)",
        "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__45635.invoke(mbql_to_native.clj:26)",
        "query_processor.middleware.check_features$check_features$fn__44911.invoke(check_features.clj:42)",
        "query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45800.invoke(optimize_datetime_filters.clj:133)",
        "query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47328.invoke(wrap_value_literals.clj:137)",
        "query_processor.middleware.annotate$add_column_info$fn__43532.invoke(annotate.clj:574)",
        "query_processor.middleware.permissions$check_query_permissions$fn__44786.invoke(permissions.clj:64)",
        "query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46318.invoke(pre_alias_aggregations.clj:40)",
        "query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44984.invoke(cumulative_aggregations.clj:61)",
        "query_processor.middleware.resolve_joins$resolve_joins$fn__46850.invoke(resolve_joins.clj:183)",
        "query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39262.invoke(add_implicit_joins.clj:245)",
        "query_processor.middleware.large_int_id$convert_id_to_string$fn__45596.invoke(large_int_id.clj:44)",
        "query_processor.middleware.limit$limit$fn__45621.invoke(limit.clj:38)",
        "query_processor.middleware.format_rows$format_rows$fn__45576.invoke(format_rows.clj:81)",
        "query_processor.middleware.desugar$desugar$fn__45050.invoke(desugar.clj:22)",
        "query_processor.middleware.binning$update_binning_strategy$fn__44076.invoke(binning.clj:229)",
        "query_processor.middleware.resolve_fields$resolve_fields$fn__44592.invoke(resolve_fields.clj:24)",
        "query_processor.middleware.add_dimension_projections$add_remapping$fn__38811.invoke(add_dimension_projections.clj:316)",
        "query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__39018.invoke(add_implicit_clauses.clj:141)",
        "query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39411.invoke(add_source_metadata.clj:105)",
        "query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46515.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)",
        "query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43717.invoke(auto_bucket_datetimes.clj:125)",
        "query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44639.invoke(resolve_source_table.clj:46)",
        "query_processor.middleware.parameters$substitute_parameters$fn__46300.invoke(parameters.clj:114)",
        "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44691.invoke(resolve_referenced.clj:80)",
        "query_processor.middleware.expand_macros$expand_macros$fn__45306.invoke(expand_macros.clj:158)",
        "query_processor.middleware.add_timezone_info$add_timezone_info$fn__39442.invoke(add_timezone_info.clj:15)",
        "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47212.invoke(splice_params_in_response.clj:32)",
        "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46526$fn__46530.invoke(resolve_database_and_driver.clj:33)",
        "driver$do_with_driver.invokeStatic(driver.clj:61)",
        "driver$do_with_driver.invoke(driver.clj:57)",
        "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46526.invoke(resolve_database_and_driver.clj:27)",
        "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45524.invoke(fetch_source_query.clj:267)",
        "query_processor.middleware.store$initialize_store$fn__47221$fn__47222.invoke(store.clj:11)",
        "query_processor.store$do_with_store.invokeStatic(store.clj:46)",
        "query_processor.store$do_with_store.invoke(store.clj:40)",
        "query_processor.middleware.store$initialize_store$fn__47221.invoke(store.clj:10)",
        "query_processor.middleware.cache$maybe_return_cached_results$fn__44568.invoke(cache.clj:209)",
        "query_processor.middleware.validate$validate_query$fn__47230.invoke(validate.clj:10)",
        "query_processor.middleware.normalize_query$normalize$fn__45648.invoke(normalize_query.clj:22)",
        "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39280.invoke(add_rows_truncated.clj:36)",
        "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47197.invoke(results_metadata.clj:143)",
        "query_processor.middleware.constraints$add_default_userland_constraints$fn__44927.invoke(constraints.clj:42)",
        "query_processor.middleware.process_userland_query$process_userland_query$fn__46389.invoke(process_userland_query.clj:136)",
        "query_processor.middleware.catch_exceptions$catch_exceptions$fn__44870.invoke(catch_exceptions.clj:174)",
        "query_processor.reducible$async_qp$qp_STAR___38074$thunk__38075.invoke(reducible.clj:101)",
        "query_processor.reducible$async_qp$qp_STAR___38074$fn__38077.invoke(reducible.clj:106)"
      ]
    }
  ],
  "json_query": {
    "type": "native",
    "native": {
      "query": "select order_number from sw_report limit 10",
      "template-tags": {}
    },
    "database": 2,
    "middleware": {
      "js-int-to-string?": true,
      "skip-results-metadata?": true,
      "format-rows?": false
    },
    "async?": true
  },
  "status": "failed",
  "class": "class org.apache.poi.openxml4j.exceptions.OpenXML4JException",
  "stacktrace": [
    "org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:586)",
    "org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1539)",
    "org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:227)",
    "org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:929)",
    "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)",
    "--> query_processor.streaming.xlsx$fn$reify__35434.finish_BANG_(xlsx.clj:79)",
    "query_processor.streaming$streaming_reducedf$fn__35446.invoke(streaming.clj:40)",
    "query_processor.context$reducedf.invokeStatic(context.clj:77)",
    "query_processor.context$reducedf.invoke(context.clj:72)",
    "query_processor.context.default$default_reducef.invokeStatic(default.clj:65)",
    "query_processor.context.default$default_reducef.invoke(default.clj:49)",
    "query_processor.context$reducef.invokeStatic(context.clj:69)",
    "query_processor.context$reducef.invoke(context.clj:62)",
    "query_processor.context.default$default_runf$respond_STAR___37992.invoke(default.clj:70)",
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:392)",
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)",
    "driver.sql_jdbc$fn__73933.invokeStatic(sql_jdbc.clj:49)",
    "driver.sql_jdbc$fn__73933.invoke(sql_jdbc.clj:47)",
    "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:69)",
    "query_processor.context.default$default_runf.invoke(default.clj:67)",
    "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__45635.invoke(mbql_to_native.clj:26)",
    "query_processor.middleware.check_features$check_features$fn__44911.invoke(check_features.clj:42)",
    "query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45800.invoke(optimize_datetime_filters.clj:133)",
    "query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47328.invoke(wrap_value_literals.clj:137)",
    "query_processor.middleware.annotate$add_column_info$fn__43532.invoke(annotate.clj:574)",
    "query_processor.middleware.permissions$check_query_permissions$fn__44786.invoke(permissions.clj:64)",
    "query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46318.invoke(pre_alias_aggregations.clj:40)",
    "query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44984.invoke(cumulative_aggregations.clj:61)",
    "query_processor.middleware.resolve_joins$resolve_joins$fn__46850.invoke(resolve_joins.clj:183)",
    "query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39262.invoke(add_implicit_joins.clj:245)",
    "query_processor.middleware.large_int_id$convert_id_to_string$fn__45596.invoke(large_int_id.clj:44)",
    "query_processor.middleware.limit$limit$fn__45621.invoke(limit.clj:38)",
    "query_processor.middleware.format_rows$format_rows$fn__45576.invoke(format_rows.clj:81)",
    "query_processor.middleware.desugar$desugar$fn__45050.invoke(desugar.clj:22)",
    "query_processor.middleware.binning$update_binning_strategy$fn__44076.invoke(binning.clj:229)",
    "query_processor.middleware.resolve_fields$resolve_fields$fn__44592.invoke(resolve_fields.clj:24)",
    "query_processor.middleware.add_dimension_projections$add_remapping$fn__38811.invoke(add_dimension_projections.clj:316)",
    "query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__39018.invoke(add_implicit_clauses.clj:141)",
    "query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39411.invoke(add_source_metadata.clj:105)",
    "query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46515.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)",
    "query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43717.invoke(auto_bucket_datetimes.clj:125)",
    "query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44639.invoke(resolve_source_table.clj:46)",
    "query_processor.middleware.parameters$substitute_parameters$fn__46300.invoke(parameters.clj:114)",
    "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44691.invoke(resolve_referenced.clj:80)",
    "query_processor.middleware.expand_macros$expand_macros$fn__45306.invoke(expand_macros.clj:158)",
    "query_processor.middleware.add_timezone_info$add_timezone_info$fn__39442.invoke(add_timezone_info.clj:15)",
    "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47212.invoke(splice_params_in_response.clj:32)",
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46526$fn__46530.invoke(resolve_database_and_driver.clj:33)",
    "driver$do_with_driver.invokeStatic(driver.clj:61)",
    "driver$do_with_driver.invoke(driver.clj:57)",
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46526.invoke(resolve_database_and_driver.clj:27)",
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45524.invoke(fetch_source_query.clj:267)",
    "query_processor.middleware.store$initialize_store$fn__47221$fn__47222.invoke(store.clj:11)",
    "query_processor.store$do_with_store.invokeStatic(store.clj:46)",
    "query_processor.store$do_with_store.invoke(store.clj:40)",
    "query_processor.middleware.store$initialize_store$fn__47221.invoke(store.clj:10)",
    "query_processor.middleware.cache$maybe_return_cached_results$fn__44568.invoke(cache.clj:209)",
    "query_processor.middleware.validate$validate_query$fn__47230.invoke(validate.clj:10)",
    "query_processor.middleware.normalize_query$normalize$fn__45648.invoke(normalize_query.clj:22)",
    "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39280.invoke(add_rows_truncated.clj:36)",
    "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47197.invoke(results_metadata.clj:143)",
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__44927.invoke(constraints.clj:42)",
    "query_processor.middleware.process_userland_query$process_userland_query$fn__46389.invoke(process_userland_query.clj:136)",
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__44870.invoke(catch_exceptions.clj:174)",
    "query_processor.reducible$async_qp$qp_STAR___38074$thunk__38075.invoke(reducible.clj:101)",
    "query_processor.reducible$async_qp$qp_STAR___38074$fn__38077.invoke(reducible.clj:106)"
  ],
  "context": "xlsx-download",
  "error": "The part /docProps/app.xml failed to be saved in the stream with marshaller org.apache.poi.openxml4j.opc.internal.marshallers.DefaultMarshaller@724ad123",
  "row_count": 0,
  "running_time": 0,
  "data": {
    "rows": [],
    "cols": []
  }
}
2

Hi @eric.halim
Out of curiosity, how much space does Metabase have available to generate temporary files?
I’ve only seen this problem once, when the server was running out of space.
Please post “Diagnostic Info” from Admin > Troubleshooting.

3

Hi @flamber

Is this related to available space? Downloading to csv works though. Only xlsx has issue.

This is 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/88.0.4324.96 Safari/537.36 Edg/88.0.705.50",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.8+10",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.8",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.8+10",
    "os.name": "Linux",
    "os.version": "4.15.0-72-generic",
    "user.language": "en",
    "user.timezone": "Asia/Jakarta"
  },
  "metabase-info": {
    "databases": [
      "mysql"
    ],
    "hosting-env": "unknown",
    "application-database": "mysql",
    "application-database-details": {
      "database": {
        "name": "MySQL",
        "version": "8.0.16"
      },
      "jdbc-driver": {
        "name": "MariaDB Connector/J",
        "version": "2.6.2"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2020-09-15",
      "tag": "v0.36.6",
      "branch": "release-0.36.x",
      "hash": "cb258fb"
    },
    "settings": {
      "report-timezone": "Asia/Bangkok"
    }
  }
}
4

Hi @eric.halim! a couple of things:

  1. the version of your instance is 0.36.6, so please update to the latest version
  2. check the free disk space on the server where Metabase is installed

regards

1 Like
5

oh yes thanks @Luiggi i saw wrongly. yes my version is 0.36.6
we will also check free space on that instance

6

I check the table and I found table “query” and “query_execution” both sum up to 300Mb.

Is it safe to delete content of these 2 tables? What is the impact of doing so?

7

@eric.halim Upgrade to latest release, then you likely won’t have any problems.
Those tables are used for history and auditing. Truncating those tables means you won’t have that history.
There’s an issue open about automatic cleaning up some of those tables:
https://github.com/metabase/metabase/issues/4155 - upvote by clicking :+1: on the first post

8

This really helped me a lot.
I have 0.36 too, but getting more free space was enough.

9

@andresmesad You should upgrade to a newer release, which prevents this problem.
You are using a very old release: https://github.com/metabase/metabase/releases/latest