Error when exporting excel of model

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 []}}

Hi @llg3888
Looks like you have a reverse-proxy somewhere, which is closing the connection between the browser and Metabase after 60 seconds. Change the timeout on the reverse-proxy.