An Error Occurred Displaying This Card - v0.41.6

Get Help
1

Hi, a co-worker has an hourly subscription set up that would include a display of the information and a .csv. It was working until Jan 31, 2022 when the error began (attached image). 55%20PM

Diagnostic Info:
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.10+9",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.10",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.10+9",
"os.name": "Linux",
"os.version": "4.12.14-lp151.28.7-default",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"mysql"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.26-log"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"date": "2022-01-10",
"tag": "v0.41.6",
"branch": "release-x.41.x",
"hash": "296635f"
},
"settings": {
"report-timezone": "US/Pacific"
}
}
}

2

Hi @alex.print
Check the logs for more detailed error - Admin > Troubleshooting > Logs.
Latest release is 0.42.4: https://github.com/metabase/metabase/releases/latest

3

[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:10-07:00 DEBUG metabase.server.middleware.log GET /api/collection/685 200 10.1 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (1 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:11-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 2,
:started_at #t "2022-04-20T14:15:11.077033Z[UTC]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error
"Error determining value for parameter: You'll need to pick a value for 'From (fulfilled)...' before this query can run.",
:stacktrace
["--> driver.common.parameters.values$fn__81651$value_for_tag__81656$fn__81657.invoke(values.clj:331)"
"driver.common.parameters.values$fn__81651$value_for_tag__81656.invoke(values.clj:324)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680$fn__81684$iter__81686__81690$fn__81691.invoke(values.clj:346)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680$fn__81684.invoke(values.clj:345)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680.invoke(values.clj:336)"
"driver.sql$fn__81759$substitute_native_parameters__81752__81764$fn__81768.invoke(sql.clj:46)"
"driver.sql$fn__81759$substitute_native_parameters__81752__81764.invoke(sql.clj:42)"
"query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
"query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
"query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:50)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:41)"
"query_processor.middleware.parameters$expand_all$replace_48069__48070.invoke(parameters.clj:59)"
"mbql.util.match.impl$replace_in_collection$iter__25741__25745$fn__25746.invoke(impl.cljc:44)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:43)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.parameters$expand_all$replace_48069__48070.invoke(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:56)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:77)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:73)"
"query_processor.middleware.parameters$fn__48085$substitute_parameters_STAR___48090$fn__48091.invoke(parameters.clj:82)"
"query_processor.middleware.parameters$fn__48085$substitute_parameters_STAR___48090.invoke(parameters.clj:79)"
"query_processor.middleware.parameters$substitute_parameters$fn__48111.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45319.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__51429.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__47890.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50374.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868$fn__49872.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45869.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__46057$fn__46058.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__46057.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50157.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50164.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47836.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49134.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47854.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50143.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__50454.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___42504$thunk__42505.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___42504$fn__42507.invoke(reducible.clj:108)"],
:error_type :missing-required-parameter,
:ex-data
{:tag
{:id "f984aef2-9753-41e2-9658-303e660a5f5c",
:name "shippedFrom",
:display-name "From (fulfilled)...",
:type :date,
:required true},
:type :missing-required-parameter}}
{:status :failed,
:class clojure.lang.ExceptionInfo,
:error
"Error building query parameter map: Error determining value for parameter: You'll need to pick a value for 'From (fulfilled)...' before this query can run.",
:stacktrace
["--> driver.common.parameters.values$fn__81675$query__GT_params_map__81680$fn__81684.invoke(values.clj:354)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680.invoke(values.clj:336)"
"driver.sql$fn__81759$substitute_native_parameters__81752__81764$fn__81768.invoke(sql.clj:46)"
"driver.sql$fn__81759$substitute_native_parameters__81752__81764.invoke(sql.clj:42)"
"query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
"query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
"query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:50)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:41)"
"query_processor.middleware.parameters$expand_all$replace_48069__48070.invoke(parameters.clj:59)"
"mbql.util.match.impl$replace_in_collection$iter__25741__25745$fn__25746.invoke(impl.cljc:44)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:43)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.parameters$expand_all$replace_48069__48070.invoke(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:56)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:77)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:73)"
"query_processor.middleware.parameters$fn__48085$substitute_parameters_STAR___48090$fn__48091.invoke(parameters.clj:82)"
"query_processor.middleware.parameters$fn__48085$substitute_parameters_STAR___48090.invoke(parameters.clj:79)"
"query_processor.middleware.parameters$substitute_parameters$fn__48111.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45319.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__51429.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__47890.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50374.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868$fn__49872.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45869.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__46057$fn__46058.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__46057.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50157.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50164.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47836.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49134.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47854.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50143.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__50454.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___42504$thunk__42505.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___42504$fn__42507.invoke(reducible.clj:108)"],
:error_type :missing-required-parameter,
:ex-data
{:type :missing-required-parameter,
:tags
{"shippedFrom"
{:id "f984aef2-9753-41e2-9658-303e660a5f5c",
:name "shippedFrom",
:display-name "From (fulfilled)...",
:type :date,
:required true},
"shippedTo"
{:id "6a43d4ac-32e7-4ec4-12f6-42c9ed38bbdf",
:name "shippedTo",
:display-name "To (fulfilled)...",
:type :date,
:required true},
"type"
{:id "5dfa78ac-f8eb-24ac-c867-490a748a765b",
:name "type",
:display-name "Hosting",
:type :text,
:required true,
:default "hosted"},
"provider" {:id "daa0375a-f71d-b825-34b1-5bbf51bb05dc", :name "provider", :display-name "Provider", :type :text}},
:params [{:type :category, :value "hosted", :target [:variable [:template-tag "type"]]}]}}],
:error_type :missing-required-parameter,
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true, :ignore-cached-results? false, :process-viz-settings? false},
:native
{:template-tags
{"shippedFrom"
{:id "f984aef2-9753-41e2-9658-303e660a5f5c",
:name "shippedFrom",
:display-name "From (fulfilled)...",
:type :date,
:required true},
"shippedTo"
{:id "6a43d4ac-32e7-4ec4-12f6-42c9ed38bbdf",
:name "shippedTo",
:display-name "To (fulfilled)...",
:type :date,
:required true},
"type"
{:id "5dfa78ac-f8eb-24ac-c867-490a748a765b",
:name "type",
:display-name "Hosting",
:type :text,
:required true,
:default "hosted"},
"provider" {:id "daa0375a-f71d-b825-34b1-5bbf51bb05dc", :name "provider", :display-name "Provider", :type :text}},
:query
"SELECT DISTINCT\n o.id AS 'Order ID',\n i.product_id AS 'Product variant ID',\n v.name AS 'Product variant',\n FROM_UNIXTIME(o.created) AS 'Order created',\n s.shipped_at AS 'Order fulfilled',\n r.created_at AS 'Refunded',\n CASE la.provider\n WHEN 'hosted' THEN ha.external_id\n ELSE la.external_id\n END AS 'Asset external ID',\n CASE la.provider\n WHEN 'hosted' THEN ha.provider\n ELSE la.provider\n END AS 'Provider',\n rr.name AS 'Refund reason'\nFROM\n orders o\n INNER JOIN shipments s ON s.order_id = o.id\n INNER JOIN refunds r ON r.order_id = o.id\n INNER JOIN refund_reasons rr ON rr.id = r.refund_reason_id\n INNER JOIN refund_items ri ON ri.refund_id = r.id\n INNER JOIN items i ON ri.item_id = i.id\n INNER JOIN variants v ON v.id = i.product_id\n INNER JOIN item_files itf ON i.id = itf.item_id\n INNER JOIN files f ON itf.file_id = f.id\n INNER JOIN file_licensed_assets fla on f.id = fla.file_id\n INNER JOIN licensed_assets la ON fla.licensed_asset_id = la.id\n LEFT JOIN hosted_assets ha ON ha.id = la.external_id\nWHERE\n o.status = 'fulfilled'\n [[AND la.provider = {{type}}]]\n [[\n AND (\n la.provider = {{provider}} \n OR ha.provider = {{provider}}\n )\n ]]\n AND s.shipped_at > {{shippedFrom}} \n AND s.shipped_at < {{shippedTo}}\nORDER BY \n o.id ASC,\n o.created ASC,\n s.shipped_at ASC;"},
:database 2,
:parameters [{:type "category", :value "hosted", :target ["variable" ["template-tag" "type"]]}],
:async? true,
:cache-ttl nil},
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> driver.common.parameters.values$missing_required_param_exception.invokeStatic(values.clj:97)"
"driver.common.parameters.values$missing_required_param_exception.invoke(values.clj:96)"
"driver.common.parameters.values$fn__81428$default_value_for_tag__81433$fn__81437.invoke(values.clj:197)"
"driver.common.parameters.values$fn__81428$default_value_for_tag__81433.invoke(values.clj:191)"
"driver.common.parameters.values$fn__81457$param_value_for_tag__81462$fn__81466.invoke(values.clj:201)"
"driver.common.parameters.values$fn__81457$param_value_for_tag__81462.invoke(values.clj:199)"
"driver.common.parameters.values$fn__81485.invokeStatic(values.clj:214)"
"driver.common.parameters.values$fn__81485.invoke(values.clj:212)"
"driver.common.parameters.values$fn__81651$value_for_tag__81656$fn__81657.invoke(values.clj:329)"
"driver.common.parameters.values$fn__81651$value_for_tag__81656.invoke(values.clj:324)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680$fn__81684$iter__81686__81690$fn__81691.invoke(values.clj:346)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680$fn__81684.invoke(values.clj:345)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680.invoke(values.clj:336)"
"driver.sql$fn__81759$substitute_native_parameters__81752__81764$fn__81768.invoke(sql.clj:46)"
"driver.sql$fn__81759$substitute_native_parameters__81752__81764.invoke(sql.clj:42)"
"query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
"query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
"query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:50)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:41)"
"query_processor.middleware.parameters$expand_all$replace_48069__48070.invoke(parameters.clj:59)"
"mbql.util.match.impl$replace_in_collection$iter__25741__25745$fn__25746.invoke(impl.cljc:44)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:43)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.parameters$expand_all$replace_48069__48070.invoke(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:56)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:77)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:73)"
"query_processor.middleware.parameters$fn__48085$substitute_parameters_STAR___48090$fn__48091.invoke(parameters.clj:82)"
"query_processor.middleware.parameters$fn__48085$substitute_parameters_STAR___48090.invoke(parameters.clj:79)"
"query_processor.middleware.parameters$substitute_parameters$fn__48111.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45319.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__51429.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__47890.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50374.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868$fn__49872.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45869.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__46057$fn__46058.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__46057.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50157.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50164.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47836.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49134.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47854.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50143.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__50454.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___42504$thunk__42505.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___42504$fn__42507.invoke(reducible.clj:108)"],
:card_id 5242,
:context :question,
:error "You'll need to pick a value for 'From (fulfilled)...' before this query can run.",
:row_count 0,
:running_time 0,
:ex-data {:type :missing-required-parameter},
:data {:rows [], :cols []}}

[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:11-07:00 DEBUG metabase.server.middleware.log POST /api/card/5242/query 202 [ASYNC: completed] 328.0 ms (7 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:12-07:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 2.8 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:12-07:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 3.1 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:12-07:00 DEBUG metabase.server.middleware.log GET /api/database 200 8.1 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:12-07:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 50.3 ms (34 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:12-07:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 3.7 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:13-07:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 5.5 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:14-07:00 DEBUG metabase.server.middleware.log GET /api/native-query-snippet 200 1.8 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:14-07:00 DEBUG metabase.server.middleware.log GET /api/collection 200 8.0 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:16-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 85.9 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:17-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 79.2 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:20-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 52.0 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:23-07:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.4 s (4 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (1 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued); mysql DB 2 connections: 1/3 (0 threads blocked)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:47-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 89.5 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:48-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 79.9 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:48-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 82.9 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:49-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 83.0 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:51-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 82.9 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 1 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:53-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 64.1 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 2 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:53-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 96.8 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 2 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:55-07:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 3.4 s (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 1 (0 queued); mysql DB 2 connections: 2/3 (0 threads blocked)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:56-07:00 DEBUG metabase.server.middleware.log POST /api/card/5242/query 202 [ASYNC: completed] 5.7 s (9 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 1 (0 queued); mysql DB 2 connections: 1/3 (0 threads blocked)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:57-07:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.4 s (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued); mysql DB 2 connections: 2/3 (0 threads blocked)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:01-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 63.6 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:02-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 141.3 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:05-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 20.4 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:07-07:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.4 s (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 1 (0 queued); mysql DB 2 connections: 1/3 (0 threads blocked)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:10-07:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.4 s (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued); mysql DB 2 connections: 1/3 (0 threads blocked)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:11-07:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 2.3 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:11-07:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 3.4 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:11-07:00 DEBUG metabase.server.middleware.log GET /api/database 200 10.4 ms (4 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (2 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:11-07:00 DEBUG metabase.server.middleware.log GET /api/card/5182 200 14.3 ms (10 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:11-07:00 DEBUG metabase.server.middleware.log GET /api/alert/question/5182 200 1.6 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:12-07:00 DEBUG metabase.server.middleware.log GET /api/native-query-snippet 200 2.2 ms (2 DB calls) App DB connections: 2/15 Jetty threads: 6/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:12-07:00 DEBUG metabase.server.middleware.log GET /api/collection/198 200 7.6 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:12-07:00 DEBUG metabase.server.middleware.log GET /api/collection 200 9.1 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:12-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:10-07:00 DEBUG metabase.server.middleware.log GET /api/collection/685 200 10.1 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (1 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:11-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 2,
:started_at #t "2022-04-20T14:15:11.077033Z[UTC]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error
"Error determining value for parameter: You'll need to pick a value for 'From (fulfilled)...' before this query can run.",
:stacktrace
["--> driver.common.parameters.values$fn__81651$value_for_tag__81656$fn__81657.invoke(values.clj:331)"
"driver.common.parameters.values$fn__81651$value_for_tag__81656.invoke(values.clj:324)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680$fn__81684$iter__81686__81690$fn__81691.invoke(values.clj:346)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680$fn__81684.invoke(values.clj:345)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680.invoke(values.clj:336)"
"driver.sql$fn__81759$substitute_native_parameters__81752__81764$fn__81768.invoke(sql.clj:46)"
"driver.sql$fn__81759$substitute_native_parameters__81752__81764.invoke(sql.clj:42)"
"query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
"query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
"query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:50)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:41)"
"query_processor.middleware.parameters$expand_all$replace_48069__48070.invoke(parameters.clj:59)"
"mbql.util.match.impl$replace_in_collection$iter__25741__25745$fn__25746.invoke(impl.cljc:44)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:43)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.parameters$expand_all$replace_48069__48070.invoke(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:56)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:77)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:73)"
"query_processor.middleware.parameters$fn__48085$substitute_parameters_STAR___48090$fn__48091.invoke(parameters.clj:82)"
"query_processor.middleware.parameters$fn__48085$substitute_parameters_STAR___48090.invoke(parameters.clj:79)"
"query_processor.middleware.parameters$substitute_parameters$fn__48111.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45319.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__51429.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__47890.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50374.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868$fn__49872.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45869.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__46057$fn__46058.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__46057.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50157.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50164.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47836.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49134.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47854.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50143.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__50454.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___42504$thunk__42505.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___42504$fn__42507.invoke(reducible.clj:108)"],
:error_type :missing-required-parameter,
:ex-data
{:tag
{:id "f984aef2-9753-41e2-9658-303e660a5f5c",
:name "shippedFrom",
:display-name "From (fulfilled)...",
:type :date,
:required true},
:type :missing-required-parameter}}
{:status :failed,
:class clojure.lang.ExceptionInfo,
:error
"Error building query parameter map: Error determining value for parameter: You'll need to pick a value for 'From (fulfilled)...' before this query can run.",
:stacktrace
["--> driver.common.parameters.values$fn__81675$query__GT_params_map__81680$fn__81684.invoke(values.clj:354)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680.invoke(values.clj:336)"
"driver.sql$fn__81759$substitute_native_parameters__81752__81764$fn__81768.invoke(sql.clj:46)"
"driver.sql$fn__81759$substitute_native_parameters__81752__81764.invoke(sql.clj:42)"
"query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
"query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
"query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:50)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:41)"
"query_processor.middleware.parameters$expand_all$replace_48069__48070.invoke(parameters.clj:59)"
"mbql.util.match.impl$replace_in_collection$iter__25741__25745$fn__25746.invoke(impl.cljc:44)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:43)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.parameters$expand_all$replace_48069__48070.invoke(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:56)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:77)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:73)"
"query_processor.middleware.parameters$fn__48085$substitute_parameters_STAR___48090$fn__48091.invoke(parameters.clj:82)"
"query_processor.middleware.parameters$fn__48085$substitute_parameters_STAR___48090.invoke(parameters.clj:79)"
"query_processor.middleware.parameters$substitute_parameters$fn__48111.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45319.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__51429.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__47890.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50374.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868$fn__49872.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45869.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__46057$fn__46058.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__46057.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50157.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50164.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47836.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49134.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47854.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50143.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__50454.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___42504$thunk__42505.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___42504$fn__42507.invoke(reducible.clj:108)"],
:error_type :missing-required-parameter,
:ex-data
{:type :missing-required-parameter,
:tags
{"shippedFrom"
{:id "f984aef2-9753-41e2-9658-303e660a5f5c",
:name "shippedFrom",
:display-name "From (fulfilled)...",
:type :date,
:required true},
"shippedTo"
{:id "6a43d4ac-32e7-4ec4-12f6-42c9ed38bbdf",
:name "shippedTo",
:display-name "To (fulfilled)...",
:type :date,
:required true},
"type"
{:id "5dfa78ac-f8eb-24ac-c867-490a748a765b",
:name "type",
:display-name "Hosting",
:type :text,
:required true,
:default "hosted"},
"provider" {:id "daa0375a-f71d-b825-34b1-5bbf51bb05dc", :name "provider", :display-name "Provider", :type :text}},
:params [{:type :category, :value "hosted", :target [:variable [:template-tag "type"]]}]}}],
:error_type :missing-required-parameter,
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true, :ignore-cached-results? false, :process-viz-settings? false},
:native
{:template-tags
{"shippedFrom"
{:id "f984aef2-9753-41e2-9658-303e660a5f5c",
:name "shippedFrom",
:display-name "From (fulfilled)...",
:type :date,
:required true},
"shippedTo"
{:id "6a43d4ac-32e7-4ec4-12f6-42c9ed38bbdf",
:name "shippedTo",
:display-name "To (fulfilled)...",
:type :date,
:required true},
"type"
{:id "5dfa78ac-f8eb-24ac-c867-490a748a765b",
:name "type",
:display-name "Hosting",
:type :text,
:required true,
:default "hosted"},
"provider" {:id "daa0375a-f71d-b825-34b1-5bbf51bb05dc", :name "provider", :display-name "Provider", :type :text}},
:query
"SELECT DISTINCT\n o.id AS 'Order ID',\n i.product_id AS 'Product variant ID',\n v.name AS 'Product variant',\n FROM_UNIXTIME(o.created) AS 'Order created',\n s.shipped_at AS 'Order fulfilled',\n r.created_at AS 'Refunded',\n CASE la.provider\n WHEN 'hosted' THEN ha.external_id\n ELSE la.external_id\n END AS 'Asset external ID',\n CASE la.provider\n WHEN 'hosted' THEN ha.provider\n ELSE la.provider\n END AS 'Provider',\n rr.name AS 'Refund reason'\nFROM\n orders o\n INNER JOIN shipments s ON s.order_id = o.id\n INNER JOIN refunds r ON r.order_id = o.id\n INNER JOIN refund_reasons rr ON rr.id = r.refund_reason_id\n INNER JOIN refund_items ri ON ri.refund_id = r.id\n INNER JOIN items i ON ri.item_id = i.id\n INNER JOIN variants v ON v.id = i.product_id\n INNER JOIN item_files itf ON i.id = itf.item_id\n INNER JOIN files f ON itf.file_id = f.id\n INNER JOIN file_licensed_assets fla on f.id = fla.file_id\n INNER JOIN licensed_assets la ON fla.licensed_asset_id = la.id\n LEFT JOIN hosted_assets ha ON ha.id = la.external_id\nWHERE\n o.status = 'fulfilled'\n [[AND la.provider = {{type}}]]\n [[\n AND (\n la.provider = {{provider}} \n OR ha.provider = {{provider}}\n )\n ]]\n AND s.shipped_at > {{shippedFrom}} \n AND s.shipped_at < {{shippedTo}}\nORDER BY \n o.id ASC,\n o.created ASC,\n s.shipped_at ASC;"},
:database 2,
:parameters [{:type "category", :value "hosted", :target ["variable" ["template-tag" "type"]]}],
:async? true,
:cache-ttl nil},
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> driver.common.parameters.values$missing_required_param_exception.invokeStatic(values.clj:97)"
"driver.common.parameters.values$missing_required_param_exception.invoke(values.clj:96)"
"driver.common.parameters.values$fn__81428$default_value_for_tag__81433$fn__81437.invoke(values.clj:197)"
"driver.common.parameters.values$fn__81428$default_value_for_tag__81433.invoke(values.clj:191)"
"driver.common.parameters.values$fn__81457$param_value_for_tag__81462$fn__81466.invoke(values.clj:201)"
"driver.common.parameters.values$fn__81457$param_value_for_tag__81462.invoke(values.clj:199)"
"driver.common.parameters.values$fn__81485.invokeStatic(values.clj:214)"
"driver.common.parameters.values$fn__81485.invoke(values.clj:212)"
"driver.common.parameters.values$fn__81651$value_for_tag__81656$fn__81657.invoke(values.clj:329)"
"driver.common.parameters.values$fn__81651$value_for_tag__81656.invoke(values.clj:324)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680$fn__81684$iter__81686__81690$fn__81691.invoke(values.clj:346)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680$fn__81684.invoke(values.clj:345)"
"driver.common.parameters.values$fn__81675$query__GT_params_map__81680.invoke(values.clj:336)"
"driver.sql$fn__81759$substitute_native_parameters__81752__81764$fn__81768.invoke(sql.clj:46)"
"driver.sql$fn__81759$substitute_native_parameters__81752__81764.invoke(sql.clj:42)"
"query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
"query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
"query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:50)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:41)"
"query_processor.middleware.parameters$expand_all$replace_48069__48070.invoke(parameters.clj:59)"
"mbql.util.match.impl$replace_in_collection$iter__25741__25745$fn__25746.invoke(impl.cljc:44)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:43)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.parameters$expand_all$replace_48069__48070.invoke(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:56)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:77)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:73)"
"query_processor.middleware.parameters$fn__48085$substitute_parameters_STAR___48090$fn__48091.invoke(parameters.clj:82)"
"query_processor.middleware.parameters$fn__48085$substitute_parameters_STAR___48090.invoke(parameters.clj:79)"
"query_processor.middleware.parameters$substitute_parameters$fn__48111.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45319.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__51429.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__47890.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50374.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868$fn__49872.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49868.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45869.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__46057$fn__46058.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__46057.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50157.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50164.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47836.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49134.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47854.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50143.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__50454.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___42504$thunk__42505.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___42504$fn__42507.invoke(reducible.clj:108)"],
:card_id 5242,
:context :question,
:error "You'll need to pick a value for 'From (fulfilled)...' before this query can run.",
:row_count 0,
:running_time 0,
:ex-data {:type :missing-required-parameter},
:data {:rows [], :cols []}}

[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:11-07:00 DEBUG metabase.server.middleware.log POST /api/card/5242/query 202 [ASYNC: completed] 328.0 ms (7 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:12-07:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 2.8 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:12-07:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 3.1 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:12-07:00 DEBUG metabase.server.middleware.log GET /api/database 200 8.1 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:12-07:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 50.3 ms (34 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:12-07:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 3.7 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:13-07:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 5.5 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:14-07:00 DEBUG metabase.server.middleware.log GET /api/native-query-snippet 200 1.8 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:14-07:00 DEBUG metabase.server.middleware.log GET /api/collection 200 8.0 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:16-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 85.9 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:17-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 79.2 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:20-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 52.0 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:23-07:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.4 s (4 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (1 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued); mysql DB 2 connections: 1/3 (0 threads blocked)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:47-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 89.5 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:48-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 79.9 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:48-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 82.9 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:49-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 83.0 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:51-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 82.9 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 1 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:53-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 64.1 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 2 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:53-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 96.8 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 2 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:55-07:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 3.4 s (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 1 (0 queued); mysql DB 2 connections: 2/3 (0 threads blocked)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:56-07:00 DEBUG metabase.server.middleware.log POST /api/card/5242/query 202 [ASYNC: completed] 5.7 s (9 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 1 (0 queued); mysql DB 2 connections: 1/3 (0 threads blocked)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:15:57-07:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.4 s (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued); mysql DB 2 connections: 2/3 (0 threads blocked)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:01-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 63.6 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (130 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:02-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 141.3 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:05-07:00 DEBUG metabase.server.middleware.log GET /api/database/2/autocomplete_suggestions 200 20.4 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:07-07:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.4 s (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 1 (0 queued); mysql DB 2 connections: 1/3 (0 threads blocked)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:10-07:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.4 s (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued); mysql DB 2 connections: 1/3 (0 threads blocked)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:11-07:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 2.3 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:11-07:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 3.4 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:11-07:00 DEBUG metabase.server.middleware.log GET /api/database 200 10.4 ms (4 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (2 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:11-07:00 DEBUG metabase.server.middleware.log GET /api/card/5182 200 14.3 ms (10 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:11-07:00 DEBUG metabase.server.middleware.log GET /api/alert/question/5182 200 1.6 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:12-07:00 DEBUG metabase.server.middleware.log GET /api/native-query-snippet 200 2.2 ms (2 DB calls) App DB connections: 2/15 Jetty threads: 6/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:12-07:00 DEBUG metabase.server.middleware.log GET /api/collection/198 200 7.6 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:12-07:00 DEBUG metabase.server.middleware.log GET /api/collection 200 9.1 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 (0 queued)
[b70e2fd3-b0cf-4bf4-a2c9-c2bfad52d1e7] 2022-04-20T07:16:12-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null

4

@alex.print There's no errors, so I'm guessing that you are seeing this issue, which was fixed in 0.42.0:
https://github.com/metabase/metabase/issues/19525