I am facing an error when exporting the full result of a model into excel/csv/json.
I cannot open the downloaded excel. I am also not able to download the csv or json file.
However, I can export the excel if I applied some filtering which returns just 1 row of record.
Logs when exporting excel:
[da0df521-5b92-47e3-a38f-f9d17c7f237c] 2022-06-09T18:33:16+08:00 DEBUG metabase.server.middleware.log POST /api/card/23/query/xlsx 202 [ASYNC: canceled] 1.0 mins (13 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (4 idle, 0 queued) (123 total active threads) Queries in flight: 0 (0 queued); postgres DB 2 connections: 0/2 (0 threads blocked)
[da0df521-5b92-47e3-a38f-f9d17c7f237c] 2022-06-09T18:33:20+08:00 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "4939583a". 💾
[da0df521-5b92-47e3-a38f-f9d17c7f237c] 2022-06-09T18:33:20+08:00 INFO metabase.query-processor.middleware.cache Query took 1.1 mins to run; minimum for cache eligibility is 15.0 s
[da0df521-5b92-47e3-a38f-f9d17c7f237c] 2022-06-09T18:33:20+08:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 2,
:started_at #t "2022-06-09T10:32:16.008406Z[UTC]",
:json_query
{:constraints nil,
:type :native,
:middleware
{:js-int-to-string? false,
:ignore-cached-results? true,
:process-viz-settings? true,
:skip-results-metadata? true,
:format-rows? false},
:native
{:query
"select strategies.strategy_ticker ,\ncase when exists(select * from strategy_contribution_daily scd where scd.strategy_ticker = strategies.strategy_ticker) then 'Yes' else 'No' end as daily_level,\n(select last_date from strategy_track st where st.strategy_ticker = strategies.strategy_ticker) as last_daily_level,\ncase when exists(select * from strategy_contribution_daily scd2 where scd2.strategy_ticker = strategies.strategy_ticker and scd2.provider_id in (\n\t\t\t\t\tselect provider_id from providers p where provider_name in ('ABC')\n\t\t\t\t)) then 'Yes'\n\t when exists(select * from strategy_contribution_history sch where sch.strategy_ticker = strategies.strategy_ticker) then 'Yes' else 'No' end as historic_track,\ncase when exists(select hh.* from holding_hash hh \n\t\t\t\t left join file_status fs2 on fs2.file_contribution_id = hh.file_contribution_id \n\t\t\t\t left join providers p2 on p2.provider_id = fs2.provider_id\n\t\t\t\t where hh.portfolio_id = (select portfolio_id from portfolio_list pl \n\t\t\t\t where pl.strategy_id = (select strategy_id from strategy_list sl2 where sl2.strategy_ticker = strategies.strategy_ticker))\n\t\t\t\t and p2.provider_name != 'DEF'\n\t\t\t\t) then 'Yes' else 'No' end as constituent\nfrom \n(select strategy_ticker from strategy_track st where st.head_date is not null union select strategy_ticker from strategy_list sl) strategies\n[[where strategies.strategy_ticker = {{strategy_ticker}}]]",
:template-tags
{"strategy_ticker"
{:id "4ada4318-a335-3101-3b29-0ddc8d386ddc",
:name "strategy_ticker",
:display-name "Strategy Ticker",
:type :text}}},
:database 2,
:parameters nil,
:async? true,
:cache-ttl 936},
:status :failed,
:class org.eclipse.jetty.io.EofException,
:stacktrace
["org.eclipse.jetty.server.HttpOutput.checkWritable(HttpOutput.java:765)"
"org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:795)"
"java.base/java.io.OutputStream.write(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.writeHeader(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.<init>(Unknown Source)"
"java.base/java.util.zip.GZIPOutputStream.<init>(Unknown Source)"
"--> async.streaming_response$output_stream_delay$fn__18958.invoke(streaming_response.clj:107)"
"async.streaming_response$delay_output_stream$fn__18967.invoke(streaming_response.clj:122)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.write(Unknown Source)"
"query_processor.streaming.xlsx$fn$reify__39174.finish_BANG_(xlsx.clj:514)"
"query_processor.streaming$streaming_reducedf$fn__39269.invoke(streaming.clj:128)"
"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:63)"
"query_processor.context.default$default_reducef.invoke(default.clj:48)"
"query_processor.middleware.cache$run_query_with_cache$reducef_SINGLEQUOTE___51432$fn__51433.invoke(cache.clj:192)"
"query_processor.middleware.cache.impl$do_with_serialization.invokeStatic(impl.clj:68)"
"query_processor.middleware.cache.impl$do_with_serialization.invoke(impl.clj:39)"
"query_processor.middleware.cache.impl$do_with_serialization.invokeStatic(impl.clj:58)"
"query_processor.middleware.cache.impl$do_with_serialization.invoke(impl.clj:39)"
"query_processor.middleware.cache$run_query_with_cache$reducef_SINGLEQUOTE___51432.invoke(cache.clj:188)"
"query_processor.context$reducef.invokeStatic(context.clj:69)"
"query_processor.context$reducef.invoke(context.clj:62)"
"query_processor.context.default$default_runf$respond_STAR___38226.invoke(default.clj:68)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:507)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc$fn__83551.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__83551.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:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:193)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:178)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___51444.invoke(cache.clj:219)"
"query_processor.middleware.permissions$check_query_permissions$fn__47226.invoke(permissions.clj:109)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__50385.invoke(mbql_to_native.clj:23)"
"query_processor$fn__52917$combined_post_process__52922$combined_post_process_STAR___52923.invoke(query_processor.clj:207)"
"query_processor$fn__52917$combined_pre_process__52918$combined_pre_process_STAR___52919.invoke(query_processor.clj:204)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51365$fn__51370.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51365.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47469.invoke(fetch_source_query.clj:281)"
"query_processor.middleware.store$initialize_store$fn__47657$fn__47658.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__47657.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51637.invoke(normalize_query.clj:22)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48727.invoke(constraints.clj:52)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__51576.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51948.invoke(catch_exceptions.clj:162)"
"query_processor.reducible$async_qp$qp_STAR___44196$thunk__44198.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44196$fn__44200.invoke(reducible.clj:105)"],
:card_id 23,
:context :xlsx-download,
:error "Closed",
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}
Logs when exporting csv/json:
[da0df521-5b92-47e3-a38f-f9d17c7f237c] 2022-06-09T23:18:37+08:00 DEBUG metabase.server.middleware.log POST /api/card/23/query/json 202 [ASYNC: canceled] 2.5 mins (13 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (4 idle, 0 queued) (121 total active threads) Queries in flight: 0 (0 queued); postgres DB 2 connections: 0/2 (0 threads blocked)
[da0df521-5b92-47e3-a38f-f9d17c7f237c] 2022-06-09T23:19:13+08:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 2,
:started_at #t "2022-06-09T15:16:07.117002Z[UTC]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Error reducing result rows",
:stacktrace
["--> query_processor.context.default$default_reducef$fn__38222.invoke(default.clj:59)"
"query_processor.context.default$default_reducef.invokeStatic(default.clj:56)"
"query_processor.context.default$default_reducef.invoke(default.clj:48)"
"query_processor.middleware.cache$run_query_with_cache$reducef_SINGLEQUOTE___51432$fn__51433.invoke(cache.clj:192)"
"query_processor.middleware.cache.impl$do_with_serialization.invokeStatic(impl.clj:68)"
"query_processor.middleware.cache.impl$do_with_serialization.invoke(impl.clj:39)"
"query_processor.middleware.cache.impl$do_with_serialization.invokeStatic(impl.clj:58)"
"query_processor.middleware.cache.impl$do_with_serialization.invoke(impl.clj:39)"
"query_processor.middleware.cache$run_query_with_cache$reducef_SINGLEQUOTE___51432.invoke(cache.clj:188)"
"query_processor.context$reducef.invokeStatic(context.clj:69)"
"query_processor.context$reducef.invoke(context.clj:62)"
"query_processor.context.default$default_runf$respond_STAR___38226.invoke(default.clj:68)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:507)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc$fn__83551.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__83551.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:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:193)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:178)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___51444.invoke(cache.clj:219)"
"query_processor.middleware.permissions$check_query_permissions$fn__47226.invoke(permissions.clj:109)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__50385.invoke(mbql_to_native.clj:23)"
"query_processor$fn__52917$combined_post_process__52922$combined_post_process_STAR___52923.invoke(query_processor.clj:207)"
"query_processor$fn__52917$combined_pre_process__52918$combined_pre_process_STAR___52919.invoke(query_processor.clj:204)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51365$fn__51370.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51365.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47469.invoke(fetch_source_query.clj:281)"
"query_processor.middleware.store$initialize_store$fn__47657$fn__47658.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__47657.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51637.invoke(normalize_query.clj:22)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48727.invoke(constraints.clj:52)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__51576.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51948.invoke(catch_exceptions.clj:162)"
"query_processor.reducible$async_qp$qp_STAR___44196$thunk__44198.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44196$fn__44200.invoke(reducible.clj:105)"],
:error_type :qp,
:ex-data {:type :qp}}],
:error_type :qp,
:json_query
{:constraints nil,
:type :native,
:middleware
{:js-int-to-string? false,
:ignore-cached-results? true,
:process-viz-settings? true,
:skip-results-metadata? true,
:format-rows? false},
:native
{:query
"select strategies.strategy_ticker ,\ncase when exists(select * from strategy_contribution_daily scd where scd.strategy_ticker = strategies.strategy_ticker) then 'Yes' else 'No' end as daily_level,\n(select last_date from strategy_track st where st.strategy_ticker = strategies.strategy_ticker) as last_daily_level,\ncase when exists(select * from strategy_contribution_daily scd2 where scd2.strategy_ticker = strategies.strategy_ticker and scd2.provider_id in (\n\t\t\t\t\tselect provider_id from providers p where provider_name in ('ABC')\n\t\t\t\t)) then 'Yes'\n\t when exists(select * from strategy_contribution_history sch where sch.strategy_ticker = strategies.strategy_ticker) then 'Yes' else 'No' end as historic_track,\ncase when exists(select hh.* from holding_hash hh \n\t\t\t\t left join file_status fs2 on fs2.file_contribution_id = hh.file_contribution_id \n\t\t\t\t left join providers p2 on p2.provider_id = fs2.provider_id\n\t\t\t\t where hh.portfolio_id = (select portfolio_id from portfolio_list pl \n\t\t\t\t where pl.strategy_id = (select strategy_id from strategy_list sl2 where sl2.strategy_ticker = strategies.strategy_ticker))\n\t\t\t\t and p2.provider_name != 'DEF'\n\t\t\t\t) then 'Yes' else 'No' end as constituent\nfrom \n(select strategy_ticker from strategy_track st where st.head_date is not null union select strategy_ticker from strategy_list sl) strategies\n[[where strategies.strategy_ticker = {{strategy_ticker}}]]",
:template-tags
{"strategy_ticker"
{:id "4ada4318-a335-3101-3b29-0ddc8d386ddc",
:name "strategy_ticker",
:display-name "Strategy Ticker",
:type :text}}},
:database 2,
:parameters nil,
:async? true,
:cache-ttl 917},
:status :failed,
:class org.eclipse.jetty.io.EofException,
:stacktrace
["org.eclipse.jetty.server.HttpOutput.checkWritable(HttpOutput.java:765)"
"org.eclipse.jetty.server.HttpOutput.write(HttpOutput.java:795)"
"java.base/java.util.zip.DeflaterOutputStream.flush(Unknown Source)"
"--> async.streaming_response$delay_output_stream$fn__18965.invoke(streaming_response.clj:119)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.flush(Unknown Source)"
"query_processor.streaming.json$fn$reify__38467.write_row_BANG_(json.clj:40)"
"query_processor.streaming$streaming_rff$fn__39260$fn__39265.invoke(streaming.clj:123)"
"query_processor.middleware.process_userland_query$add_and_save_execution_info_xform_BANG_$execution_info_rf_STAR___51567.invoke(process_userland_query.clj:100)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated_xform$fn__49105.invoke(add_rows_truncated.clj:33)"
"query_processor.reducible$combine_additional_reducing_fns$combine_additional_reducing_fns_rf_STAR___44217.invoke(reducible.clj:206)"
"query_processor.middleware.cache$save_results_xform$fn__51396.invoke(cache.clj:117)"
"query_processor.reducible$reducible_rows$reify__44210.reduce(reducible.clj:150)"
"query_processor.context.default$default_reducef$fn__38222.invoke(default.clj:57)"
"query_processor.context.default$default_reducef.invokeStatic(default.clj:56)"
"query_processor.context.default$default_reducef.invoke(default.clj:48)"
"query_processor.middleware.cache$run_query_with_cache$reducef_SINGLEQUOTE___51432$fn__51433.invoke(cache.clj:192)"
"query_processor.middleware.cache.impl$do_with_serialization.invokeStatic(impl.clj:68)"
"query_processor.middleware.cache.impl$do_with_serialization.invoke(impl.clj:39)"
"query_processor.middleware.cache.impl$do_with_serialization.invokeStatic(impl.clj:58)"
"query_processor.middleware.cache.impl$do_with_serialization.invoke(impl.clj:39)"
"query_processor.middleware.cache$run_query_with_cache$reducef_SINGLEQUOTE___51432.invoke(cache.clj:188)"
"query_processor.context$reducef.invokeStatic(context.clj:69)"
"query_processor.context$reducef.invoke(context.clj:62)"
"query_processor.context.default$default_runf$respond_STAR___38226.invoke(default.clj:68)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:507)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
"driver.sql_jdbc$fn__83551.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__83551.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:67)"
"query_processor.context.default$default_runf.invoke(default.clj:65)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:193)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:178)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___51444.invoke(cache.clj:219)"
"query_processor.middleware.permissions$check_query_permissions$fn__47226.invoke(permissions.clj:109)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__50385.invoke(mbql_to_native.clj:23)"
"query_processor$fn__52917$combined_post_process__52922$combined_post_process_STAR___52923.invoke(query_processor.clj:207)"
"query_processor$fn__52917$combined_pre_process__52918$combined_pre_process_STAR___52919.invoke(query_processor.clj:204)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51365$fn__51370.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51365.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47469.invoke(fetch_source_query.clj:281)"
"query_processor.middleware.store$initialize_store$fn__47657$fn__47658.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__47657.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__51637.invoke(normalize_query.clj:22)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48727.invoke(constraints.clj:52)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__51576.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51948.invoke(catch_exceptions.clj:162)"
"query_processor.reducible$async_qp$qp_STAR___44196$thunk__44198.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44196$fn__44200.invoke(reducible.clj:105)"],
:card_id 23,
:context :json-download,
:error "Closed",
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}