Hi, I'm having a problem. Apparently from metabase I have no problems when I open a dashboard and in that dashboard I use a filter that is too long. But if I export that dashboard and call it through an iframe then I can't enter the same length in the filter.
That can be possible? Or should it behave the same way
thankss
Hi @franpuebla
So I'm guessing you are talking about normal in-app dashboard vs Signed Embedding dashboard?
What do you mean you cannot input the same length?
If you are getting an error, then include that error.
Thanks for your quick answer!
Yes exactly, normal in-app dashboard vs Signed Embedding dashboard.
Does not show any error, but look at these 2 screenshots:
They are the same, only one called from the app and the other when you share, tell me if it is not understood and I will try to explain it again. Thanks again!
1- { "browser-info": { "language": "es-419", "platform": "MacIntel", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36", "vendor": "Google Inc." }, "system-info": { "file.encoding": "UTF-8", "java.runtime.name": "OpenJDK Runtime Environment", "java.runtime.version": "17.0.5+8-Ubuntu-2ubuntu120.04", "java.vendor": "Private Build", "java.vendor.url": "Unknown", "java.version": "17.0.5", "java.vm.name": "OpenJDK 64-Bit Server VM", "java.vm.version": "17.0.5+8-Ubuntu-2ubuntu120.04", "os.name": "Linux", "os.version": "5.15.0-1023-aws", "user.language": "en", "user.timezone": "Etc/UTC" }, "metabase-info": { "databases": [ "mysql" ], "hosting-env": "unknown", "application-database": "mysql", "application-database-details": { "database": { "name": "MySQL", "version": "8.0.31-0ubuntu0.20.04.1" }, "jdbc-driver": { "name": "MariaDB Connector/J", "version": "2.7.5" } }, "run-mode": "prod", "version": { "date": "2022-03-23", "tag": "v0.42.3", "branch": "release-x.42.x", "hash": "33fb268" }, "settings": { "report-timezone": null } } }
2- `[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:52:29-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error procesando consulta: null
{:database_id 3,
:started_at #t "2022-12-15T17:52:29.227028531Z[Etc/UTC]",
: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},
:native
{:query "CALL audience_greatest_impact_avg ({{date_from}}, {{date_to}}, {{content_display}});",
:template-tags
{"date_from"
{:id "ee320bf8-2821-8342-426a-adf710711941", :name "date_from", :display-name "Date from", :type :text},
"date_to" {:id "549c133e-ff65-f030-93d1-6f8275cfb0de", :name "date_to", :display-name "Date to", :type :text},
"content_display"
{:id "004c5abb-b552-97a5-48a4-390706d8ce1d",
:name "content_display",
:display-name "Content display",
:type :text}}},
:database 3,
:parameters
[{:type :string/=, :value ["2022-12-19"], :target [:variable [:template-tag "date_from"]], :id "3d331fd1"}
{:type :string/=, :value ["2022-12-31"], :target [:variable [:template-tag "date_to"]], :id "abd84bbe"}],
:async? true,
:cache-ttl nil},
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> driver.sql.parameters.substitute$substitute.invokeStatic(substitute.clj:93)"
"driver.sql.parameters.substitute$substitute.invoke(substitute.clj:73)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613$fn__78617.invoke(sql.clj:46)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613.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:49)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:40)"
"query_processor.middleware.parameters$expand_all$replace_48583__48584.invoke(parameters.clj:58)"
"mbql.util.match.impl$replace_in_collection$iter__27400__27404$fn__27405.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_48583__48584.invoke(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:55)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:76)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:72)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604$fn__48605.invoke(parameters.clj:81)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604.invoke(parameters.clj:78)"
"query_processor.middleware.parameters$substitute_parameters$fn__48624.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45984.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52276.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48404.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51227.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643$fn__50648.invoke(resolve_database_and_driver.clj:35)"
"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__50643.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46530.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__46721$fn__46722.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__46721.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50978.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50985.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48350.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49641.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48368.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50919.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51307.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___43282$thunk__43283.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___43282$fn__43285.invoke(reducible.clj:108)"],
:card_id 249,
:context :public-dashboard,
:error "No se puede ejecutar la consulta: faltan los parámetros necesarios: #{"content_display"}",
:row_count 0,
:running_time 0,
:ex-data {:type :missing-required-parameter, :missing ("content_display")},
:data {:rows [], :cols []}}
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:52:29-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error procesando consulta: null
{:database_id 3,
:started_at #t "2022-12-15T17:52:29.284831087Z[Etc/UTC]",
: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},
:native
{:query "CALL audience_comparison_by_display ({{date_from}}, {{date_to}}, {{content_display}});",
:template-tags
{"date_from"
{:id "dff8da13-1a6c-21b3-54a1-a2ec62ab59de", :name "date_from", :display-name "Date from", :type :text},
"date_to" {:id "1d40e363-6df2-a065-84dd-a951d2ecf7da", :name "date_to", :display-name "Date to", :type :text},
"content_display"
{:id "ac692260-bbaa-b298-22c6-3b5b498bb41b",
:name "content_display",
:display-name "Content display",
:type :text}}},
:database 3,
:parameters
[{:type :string/=, :value ["2022-12-19"], :target [:variable [:template-tag "date_from"]], :id "3d331fd1"}
{:type :string/=, :value ["2022-12-31"], :target [:variable [:template-tag "date_to"]], :id "abd84bbe"}],
:async? true,
:cache-ttl nil},
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> driver.sql.parameters.substitute$substitute.invokeStatic(substitute.clj:93)"
"driver.sql.parameters.substitute$substitute.invoke(substitute.clj:73)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613$fn__78617.invoke(sql.clj:46)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613.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:49)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:40)"
"query_processor.middleware.parameters$expand_all$replace_48583__48584.invoke(parameters.clj:58)"
"mbql.util.match.impl$replace_in_collection$iter__27400__27404$fn__27405.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_48583__48584.invoke(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:55)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:76)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:72)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604$fn__48605.invoke(parameters.clj:81)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604.invoke(parameters.clj:78)"
"query_processor.middleware.parameters$substitute_parameters$fn__48624.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45984.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52276.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48404.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51227.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643$fn__50648.invoke(resolve_database_and_driver.clj:35)"
"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__50643.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46530.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__46721$fn__46722.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__46721.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50978.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50985.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48350.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49641.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48368.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50919.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51307.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___43282$thunk__43283.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___43282$fn__43285.invoke(reducible.clj:108)"],
:card_id 252,
:context :public-dashboard,
:error "No se puede ejecutar la consulta: faltan los parámetros necesarios: #{"content_display"}",
:row_count 0,
:running_time 0,
:ex-data {:type :missing-required-parameter, :missing ("content_display")},
:data {:rows [], :cols []}}
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:52:29-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/ff71f8c6-c03a-4649-9abd-d5d6986019fc/dashcard/477/card/249 202 [ASYNC: completed] 463.0 ms (10 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 4/50 (3 esperando, 0 en cola) (113 hilos totales activos) Consultas en ejecución: 2 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:52:29-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/ff71f8c6-c03a-4649-9abd-d5d6986019fc/dashcard/480/card/252 202 [ASYNC: completed] 393.2 ms (10 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 5/50 (3 esperando, 0 en cola) (113 hilos totales activos) Consultas en ejecución: 2 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:52:29-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error procesando consulta: null
{:database_id 3,
:started_at #t "2022-12-15T17:52:29.249142241Z[Etc/UTC]",
: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},
:native
{:query "CALL audience_highest_impact_day_of_week ({{date_from}}, {{date_to}}, {{content_display}});",
:template-tags
{"date_from"
{:id "f2b3da97-708d-0a32-e34d-5b24bbc5dbd2", :name "date_from", :display-name "Date from", :type :text},
"date_to" {:id "f195d5e7-17eb-b535-04e2-ea1b97509a3e", :name "date_to", :display-name "Date to", :type :text},
"content_display"
{:id "4d14ab26-e1ba-d8e4-7bb1-025ef442cf96",
:name "content_display",
:display-name "Content display",
:type :text}}},
:database 3,
:parameters
[{:type :string/=, :value ["2022-12-19"], :target [:variable [:template-tag "date_from"]], :id "3d331fd1"}
{:type :string/=, :value ["2022-12-31"], :target [:variable [:template-tag "date_to"]], :id "abd84bbe"}],
:async? true,
:cache-ttl nil},
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> driver.sql.parameters.substitute$substitute.invokeStatic(substitute.clj:93)"
"driver.sql.parameters.substitute$substitute.invoke(substitute.clj:73)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613$fn__78617.invoke(sql.clj:46)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613.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:49)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:40)"
"query_processor.middleware.parameters$expand_all$replace_48583__48584.invoke(parameters.clj:58)"
"mbql.util.match.impl$replace_in_collection$iter__27400__27404$fn__27405.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_48583__48584.invoke(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:55)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:76)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:72)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604$fn__48605.invoke(parameters.clj:81)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604.invoke(parameters.clj:78)"
"query_processor.middleware.parameters$substitute_parameters$fn__48624.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45984.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52276.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48404.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51227.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643$fn__50648.invoke(resolve_database_and_driver.clj:35)"
"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__50643.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46530.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__46721$fn__46722.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__46721.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50978.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50985.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48350.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49641.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48368.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50919.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51307.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___43282$thunk__43283.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___43282$fn__43285.invoke(reducible.clj:108)"],
:card_id 247,
:context :public-dashboard,
:error "No se puede ejecutar la consulta: faltan los parámetros necesarios: #{"content_display"}",
:row_count 0,
:running_time 0,
:ex-data {:type :missing-required-parameter, :missing ("content_display")},
:data {:rows [], :cols []}}
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:52:29-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/ff71f8c6-c03a-4649-9abd-d5d6986019fc/dashcard/475/card/247 202 [ASYNC: completed] 492.9 ms (10 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 5/50 (3 esperando, 0 en cola) (113 hilos totales activos) Consultas en ejecución: 1 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:52:29-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error procesando consulta: null
{:database_id 3,
:started_at #t "2022-12-15T17:52:29.255846349Z[Etc/UTC]",
: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},
:native
{:query "CALL audience_avg_impacts_for_hour ({{date_from}}, {{date_to}}, {{content_display}});",
:template-tags
{"date_from"
{:id "d677fe2f-b849-1bf5-f45d-1f93fb779a51", :name "date_from", :display-name "Date from", :type :text},
"date_to" {:id "f3df97c2-af49-7cdd-cca4-7ebf813862ef", :name "date_to", :display-name "Date to", :type :text},
"content_display"
{:id "e688116b-de54-e90a-b27d-a5c3590589a5",
:name "content_display",
:display-name "Content display",
:type :text}}},
:database 3,
:parameters
[{:type :string/=, :value ["2022-12-19"], :target [:variable [:template-tag "date_from"]], :id "3d331fd1"}
{:type :string/=, :value ["2022-12-31"], :target [:variable [:template-tag "date_to"]], :id "abd84bbe"}],
:async? true,
:cache-ttl nil},
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> driver.sql.parameters.substitute$substitute.invokeStatic(substitute.clj:93)"
"driver.sql.parameters.substitute$substitute.invoke(substitute.clj:73)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613$fn__78617.invoke(sql.clj:46)"
"driver.sql$fn__78608$substitute_native_parameters__78601__78613.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:49)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:40)"
"query_processor.middleware.parameters$expand_all$replace_48583__48584.invoke(parameters.clj:58)"
"mbql.util.match.impl$replace_in_collection$iter__27400__27404$fn__27405.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_48583__48584.invoke(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:55)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:76)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:72)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604$fn__48605.invoke(parameters.clj:81)"
"query_processor.middleware.parameters$fn__48599$substitute_parameters_STAR___48604.invoke(parameters.clj:78)"
"query_processor.middleware.parameters$substitute_parameters$fn__48624.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45984.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52276.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48404.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51227.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643$fn__50648.invoke(resolve_database_and_driver.clj:35)"
"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__50643.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46530.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__46721$fn__46722.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__46721.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50978.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50985.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48350.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49641.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48368.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50919.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51307.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___43282$thunk__43283.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___43282$fn__43285.invoke(reducible.clj:108)"],
:card_id 251,
:context :public-dashboard,
:error "No se puede ejecutar la consulta: faltan los parámetros necesarios: #{"content_display"}",
:row_count 0,
:running_time 0,
:ex-data {:type :missing-required-parameter, :missing ("content_display")},
:data {:rows [], :cols []}}
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:52:29-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/ff71f8c6-c03a-4649-9abd-d5d6986019fc/dashcard/479/card/251 202 [ASYNC: completed] 508.0 ms (10 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 3/50 (4 esperando, 0 en cola) (113 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:56:32-03:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 1.1 ms (1 llamadas a la BBDD) Conexiones BBDD: 2/15 Hilos Jetty: 3/50 (4 esperando, 0 en cola) (107 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:27-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 22.8 ms (4 llamadas a la BBDD) Conexiones BBDD: 1/15 Hilos Jetty: 5/50 (1 esperando, 0 en cola) (109 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:27-03:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 25.1 ms (4 llamadas a la BBDD) Conexiones BBDD: 1/15 Hilos Jetty: 5/50 (1 esperando, 0 en cola) (109 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:27-03:00 DEBUG metabase.server.middleware.log GET /api/database 200 5.7 ms (4 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 3/50 (4 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:30-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/283a0ad5-2dc3-4204-ac66-0576b4519da1 200 8.5 ms (10 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 3/50 (4 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:30-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 5.1 ms (1 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 3/50 (4 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:30-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/283a0ad5-2dc3-4204-ac66-0576b4519da1/dashcard/203/card/139 202 [ASYNC: completed] 64.5 ms (16 llamadas a la BBDD) Conexiones BBDD: 4/15 Hilos Jetty: 3/50 (3 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 2 (0 en cola); mysql DB 3 connections: 0/1 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:30-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/283a0ad5-2dc3-4204-ac66-0576b4519da1/dashcard/202/card/134 202 [ASYNC: completed] 68.6 ms (16 llamadas a la BBDD) Conexiones BBDD: 4/15 Hilos Jetty: 4/50 (2 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 0 (0 en cola); mysql DB 3 connections: 1/1 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:31-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/283a0ad5-2dc3-4204-ac66-0576b4519da1/dashcard/202/card/134 202 [ASYNC: completed] 47.0 ms (16 llamadas a la BBDD) Conexiones BBDD: 2/15 Hilos Jetty: 3/50 (3 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 1 (0 en cola); mysql DB 3 connections: 0/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:31-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/283a0ad5-2dc3-4204-ac66-0576b4519da1/dashcard/203/card/139 202 [ASYNC: completed] 48.6 ms (16 llamadas a la BBDD) Conexiones BBDD: 1/15 Hilos Jetty: 3/50 (3 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 0 (0 en cola); mysql DB 3 connections: 1/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:34-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 7.0 ms (1 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 4/50 (3 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:34-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/8b3b2750-7884-4372-8dfc-c558c9f71f7e 200 20.3 ms (13 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 4/50 (3 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:34-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/233f375f-29dc-4216-9a23-c4d299aa6982 200 8.5 ms (9 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 3/50 (4 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:34-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/73e393f0-9117-442f-a97b-4889da9ad261 200 15.7 ms (12 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 3/50 (3 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:34-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 5.1 ms (1 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 3/50 (4 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:34-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/8b3b2750-7884-4372-8dfc-c558c9f71f7e/dashcard/98/card/73 202 [ASYNC: completed] 123.0 ms (22 llamadas a la BBDD) Conexiones BBDD: 2/15 Hilos Jetty: 2/50 (4 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 2 (0 en cola); mysql DB 3 connections: 0/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:34-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/8b3b2750-7884-4372-8dfc-c558c9f71f7e/dashcard/96/card/74 202 [ASYNC: completed] 153.3 ms (22 llamadas a la BBDD) Conexiones BBDD: 3/15 Hilos Jetty: 5/50 (2 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 1 (0 en cola); mysql DB 3 connections: 0/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:34-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/8b3b2750-7884-4372-8dfc-c558c9f71f7e/dashcard/97/card/75 202 [ASYNC: completed] 165.2 ms (22 llamadas a la BBDD) Conexiones BBDD: 2/15 Hilos Jetty: 3/50 (3 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 0 (0 en cola); mysql DB 3 connections: 1/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:34-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 19.0 ms (1 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 4/50 (3 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 1 (0 en cola)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:34-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/8b3b2750-7884-4372-8dfc-c558c9f71f7e/dashcard/98/card/73 202 [ASYNC: completed] 115.2 ms (22 llamadas a la BBDD) Conexiones BBDD: 3/15 Hilos Jetty: 2/50 (4 esperando, 0 en cola) (110 hilos totales activos) Consultas en ejecución: 1 (0 en cola); mysql DB 3 connections: 0/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:35-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/233f375f-29dc-4216-9a23-c4d299aa6982/dashcard/214/card/115 202 [ASYNC: completed] 193.5 ms (22 llamadas a la BBDD) Conexiones BBDD: 2/15 Hilos Jetty: 3/50 (5 esperando, 0 en cola) (116 hilos totales activos) Consultas en ejecución: 6 (0 en cola); mysql DB 3 connections: 0/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:35-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/8b3b2750-7884-4372-8dfc-c558c9f71f7e/dashcard/100/card/71 202 [ASYNC: completed] 233.0 ms (19 llamadas a la BBDD) Conexiones BBDD: 2/15 Hilos Jetty: 4/50 (5 esperando, 0 en cola) (116 hilos totales activos) Consultas en ejecución: 5 (0 en cola); mysql DB 3 connections: 1/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:35-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/8b3b2750-7884-4372-8dfc-c558c9f71f7e/dashcard/99/card/72 202 [ASYNC: completed] 266.7 ms (20 llamadas a la BBDD) Conexiones BBDD: 3/15 Hilos Jetty: 3/50 (5 esperando, 0 en cola) (116 hilos totales activos) Consultas en ejecución: 4 (0 en cola); mysql DB 3 connections: 1/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:35-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/8b3b2750-7884-4372-8dfc-c558c9f71f7e/dashcard/96/card/74 202 [ASYNC: completed] 303.9 ms (22 llamadas a la BBDD) Conexiones BBDD: 1/15 Hilos Jetty: 3/50 (5 esperando, 0 en cola) (116 hilos totales activos) Consultas en ejecución: 3 (0 en cola); mysql DB 3 connections: 1/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:35-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/8b3b2750-7884-4372-8dfc-c558c9f71f7e/dashcard/97/card/75 202 [ASYNC: completed] 356.9 ms (22 llamadas a la BBDD) Conexiones BBDD: 1/15 Hilos Jetty: 3/50 (5 esperando, 0 en cola) (116 hilos totales activos) Consultas en ejecución: 2 (0 en cola); mysql DB 3 connections: 0/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:35-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/73e393f0-9117-442f-a97b-4889da9ad261/dashcard/101/card/67 202 [ASYNC: completed] 310.0 ms (24 llamadas a la BBDD) Conexiones BBDD: 1/15 Hilos Jetty: 3/50 (5 esperando, 0 en cola) (116 hilos totales activos) Consultas en ejecución: 1 (0 en cola); mysql DB 3 connections: 0/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:35-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/73e393f0-9117-442f-a97b-4889da9ad261/dashcard/102/card/68 202 [ASYNC: completed] 80.6 ms (21 llamadas a la BBDD) Conexiones BBDD: 2/15 Hilos Jetty: 3/50 (5 esperando, 0 en cola) (116 hilos totales activos) Consultas en ejecución: 2 (0 en cola); mysql DB 3 connections: 0/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:35-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/73e393f0-9117-442f-a97b-4889da9ad261/dashcard/104/card/70 202 [ASYNC: completed] 110.2 ms (21 llamadas a la BBDD) Conexiones BBDD: 2/15 Hilos Jetty: 2/50 (6 esperando, 0 en cola) (116 hilos totales activos) Consultas en ejecución: 2 (0 en cola); mysql DB 3 connections: 1/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:35-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/73e393f0-9117-442f-a97b-4889da9ad261/dashcard/103/card/69 202 [ASYNC: completed] 102.7 ms (21 llamadas a la BBDD) Conexiones BBDD: 1/15 Hilos Jetty: 3/50 (6 esperando, 0 en cola) (116 hilos totales activos) Consultas en ejecución: 1 (0 en cola); mysql DB 3 connections: 1/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:35-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/8b3b2750-7884-4372-8dfc-c558c9f71f7e/dashcard/99/card/72 202 [ASYNC: canceled] 1.0 s (20 llamadas a la BBDD) Conexiones BBDD: 0/15 Hilos Jetty: 2/50 (6 esperando, 0 en cola) (117 hilos totales activos) Consultas en ejecución: 0 (0 en cola); mysql DB 3 connections: 0/2 (0 threads blocked)
[153e55af-f237-4a5c-bcf6-b234cbb365b4] 2022-12-15T14:57:35-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error procesando consulta: null
{:database_id 3,
:started_at #t "2022-12-15T17:57:34.550990618Z[Etc/UTC]",
:via
[{:status :failed,
:class org.eclipse.jetty.io.EofException,
:error nil,
:stacktrace
["org.eclipse.jetty.io.ChannelEndPoint.flush(ChannelEndPoint.java:279)"
"org.eclipse.jetty.io.WriteFlusher.flush(WriteFlusher.java:422)"
"org.eclipse.jetty.io.WriteFlusher.write(WriteFlusher.java:277)"
"org.eclipse.jetty.io.AbstractEndPoint.write(AbstractEndPoint.java:381)"
"org.eclipse.jetty.server.HttpConnection$SendCallback.process(HttpConnection.java:832)"
"org.eclipse.jetty.util.IteratingCallback.processing(IteratingCallback.java:241)"
"org.eclipse.jetty.util.IteratingCallback.iterate(IteratingCallback.java:223)"
"org.eclipse.jetty.server.HttpConnection.send(HttpConnection.java:550)"
"org.eclipse.jetty.server.HttpChannel.sendResponse(HttpChannel.java:915)"
"org.eclipse.jetty.server.HttpChannel.write(HttpChannel.java:987)"
"org.eclipse.jetty.server.HttpOutput.channelWrite(HttpOutput.java:285)"
"org.eclipse.jetty.server.HttpOutput.channelWrite(HttpOutput.java:269)"
"org.eclipse.jetty.server.HttpOutput.flush(HttpOutput.java:749)"
"java.base/java.util.zip.DeflaterOutputStream.flush(DeflaterOutputStream.java:290)"
"--> async.streaming_response$delay_output_stream$fn__26905.invoke(streaming_response.clj:119)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.flush(Unknown Source)"
"query_processor.streaming.json$fn$reify__37605.finish_BANG_(json.clj:91)"
"query_processor.streaming$streaming_reducedf$fn__38368.invoke(streaming.clj:128)"
"api.public$public_reducedf$fn__69927.invoke(public.clj:96)"
"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:64)"
"query_processor.context.default$default_reducef.invoke(default.clj:48)"
"query_processor.context$reducef.invokeStatic(context.clj:69)"
"query_processor.context$reducef.invoke(context.clj:62)"
"query_processor.context.default$default_runf$respond_STAR___37338.invoke(default.clj:69)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:509)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc$fn__82002.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__82002.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:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49655.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__50401.invoke(check_features.clj:42)"
"query_processor.middleware.limit$limit$fn__47991.invoke(limit.clj:37)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__50784.invoke(cache.clj:204)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__51848.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51892.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49712.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39780.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__44546.invoke(annotate.clj:659)"
"query_processor.middleware.permissions$check_query_permissions$fn__46288.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51006.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46684.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__46622.invoke(visualization_settings.clj:63)"
"query_processor.middleware.escape_join_aliases$escape_join_aliases_middleware$fn__48032.invoke(escape_join_aliases.clj:64)"
"query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__50971.invoke(fix_bad_references.clj:91)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47569.invoke(resolve_joined_fields.clj:111)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__51618.invoke(resolve_joins.clj:178)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__51160.invoke(add_implicit_joins.clj:246)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47588.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__51212.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46956.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__46595.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__39509.invoke(binning.clj:232)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45930.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__50338.invoke(add_dimension_projections.clj:487)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__50632.invoke(add_implicit_clauses.clj:164)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47976.invoke(upgrade_field_literals.clj:117)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__47333.invoke(add_source_metadata.clj:125)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50883.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48970.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45911.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__48624.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45984.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52276.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48404.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51227.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643$fn__50648.invoke(resolve_database_and_driver.clj:35)"
"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__50643.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46530.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__46721$fn__46722.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__46721.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50978.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50985.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48350.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49641.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48368.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50919.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51307.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___43282$thunk__43283.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___43282$fn__43285.invoke(reducible.clj:108)"]}],
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:database 3,
:query
{:source-table 18,
:joins
[{:fields :all,
:source-table 13,
:condition [:= [:field 303 nil] [:field 327 {:join-alias "Companies"}]],
:alias "Companies"}
{:fields :all,
:source-table 29,
:condition [:= [:field 293 nil] [:field 599 {:join-alias "Smart Campaign Types"}]],
:alias "Smart Campaign Types"}],
:filter [:and [:segment 2] [:time-interval [:field 291 nil] :current :week]],
:aggregation [[:count]]},
:parameters
[{:type :id,
:value ["3578d760-d5ed-11ec-8c7d-ddca21808446"],
:target [:dimension [:field 602 {:join-alias "Companies"}]],
:id "11f02712"}
{:type :date/all-options, :value "~2022-12-15", :target [:dimension [:field 311 nil]], :id "3afbea9a"}
{:type :date/all-options, :value "2022-12-15~", :target [:dimension [:field 291 nil]], :id "ce8bc124"}],
:async? true,
:cache-ttl nil},
:native
{:query
"SELECT count() AS count FROM campaigns LEFT JOIN companies Companies ON campaigns.company_id = Companies.id LEFT JOIN smart_campaign_types Smart Campaign Types ON campaigns.smart_campaign = Smart Campaign Types.id WHERE (campaigns.payment_status = ? AND campaigns.status = ? AND campaigns.is_test = FALSE AND campaigns.end_date >= date_add(str_to_date(concat(yearweek(date_add(now(6), INTERVAL -1 day)), ' Sunday'), '%X%V %W'), INTERVAL 1 day) AND campaigns.end_date < date_add(str_to_date(concat(yearweek(date_add(date_add(now(6), INTERVAL 1 week), INTERVAL -1 day)), ' Sunday'), '%X%V %W'), INTERVAL 1 day) AND Companies.id_token = ? AND campaigns.start_date < ? AND campaigns.end_date >= ?)",
:params
("approved"
"ready"
"3578d760-d5ed-11ec-8c7d-ddca21808446"
#t "2022-12-15T00:00Z[Etc/UTC]"
#t "2022-12-16T00:00Z[Etc/UTC]")},
:status :failed,
:class java.io.IOException,
:stacktrace
["java.base/sun.nio.ch.FileDispatcherImpl.writev0(Native Method)"
"java.base/sun.nio.ch.SocketDispatcher.writev(SocketDispatcher.java:66)"
"java.base/sun.nio.ch.IOUtil.write(IOUtil.java:217)"
"java.base/sun.nio.ch.IOUtil.write(IOUtil.java:153)"
"java.base/sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:563)"
"java.base/java.nio.channels.SocketChannel.write(SocketChannel.java:642)"
"org.eclipse.jetty.io.ChannelEndPoint.flush(ChannelEndPoint.java:273)"
"org.eclipse.jetty.io.WriteFlusher.flush(WriteFlusher.java:422)"
"org.eclipse.jetty.io.WriteFlusher.write(WriteFlusher.java:277)"
"org.eclipse.jetty.io.AbstractEndPoint.write(AbstractEndPoint.java:381)"
"org.eclipse.jetty.server.HttpConnection$SendCallback.process(HttpConnection.java:832)"
"org.eclipse.jetty.util.IteratingCallback.processing(IteratingCallback.java:241)"
"org.eclipse.jetty.util.IteratingCallback.iterate(IteratingCallback.java:223)"
"org.eclipse.jetty.server.HttpConnection.send(HttpConnection.java:550)"
"org.eclipse.jetty.server.HttpChannel.sendResponse(HttpChannel.java:915)"
"org.eclipse.jetty.server.HttpChannel.write(HttpChannel.java:987)"
"org.eclipse.jetty.server.HttpOutput.channelWrite(HttpOutput.java:285)"
"org.eclipse.jetty.server.HttpOutput.channelWrite(HttpOutput.java:269)"
"org.eclipse.jetty.server.HttpOutput.flush(HttpOutput.java:749)"
"java.base/java.util.zip.DeflaterOutputStream.flush(DeflaterOutputStream.java:290)"
"--> async.streaming_response$delay_output_stream$fn__26905.invoke(streaming_response.clj:119)"
"async.streaming_response.proxy$java.io.OutputStream$ff19274a.flush(Unknown Source)"
"query_processor.streaming.json$fn$reify__37605.finish_BANG_(json.clj:91)"
"query_processor.streaming$streaming_reducedf$fn__38368.invoke(streaming.clj:128)"
"api.public$public_reducedf$fn__69927.invoke(public.clj:96)"
"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:64)"
"query_processor.context.default$default_reducef.invoke(default.clj:48)"
"query_processor.context$reducef.invokeStatic(context.clj:69)"
"query_processor.context$reducef.invoke(context.clj:62)"
"query_processor.context.default$default_runf$respond_STAR___37338.invoke(default.clj:69)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:509)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc$fn__82002.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__82002.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:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49655.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__50401.invoke(check_features.clj:42)"
"query_processor.middleware.limit$limit$fn__47991.invoke(limit.clj:37)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__50784.invoke(cache.clj:204)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__51848.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51892.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49712.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39780.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__44546.invoke(annotate.clj:659)"
"query_processor.middleware.permissions$check_query_permissions$fn__46288.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51006.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46684.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__46622.invoke(visualization_settings.clj:63)"
"query_processor.middleware.escape_join_aliases$escape_join_aliases_middleware$fn__48032.invoke(escape_join_aliases.clj:64)"
"query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__50971.invoke(fix_bad_references.clj:91)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47569.invoke(resolve_joined_fields.clj:111)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__51618.invoke(resolve_joins.clj:178)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__51160.invoke(add_implicit_joins.clj:246)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47588.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__51212.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46956.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__46595.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__39509.invoke(binning.clj:232)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45930.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__50338.invoke(add_dimension_projections.clj:487)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__50632.invoke(add_implicit_clauses.clj:164)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47976.invoke(upgrade_field_literals.clj:117)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__47333.invoke(add_source_metadata.clj:125)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50883.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48970.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45911.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__48624.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45984.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52276.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48404.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51227.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50643$fn__50648.invoke(resolve_database_and_driver.clj:35)"
"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__50643.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46530.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__46721$fn__46722.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__46721.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50978.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50985.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48350.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49641.invoke(results_metadata.clj:82)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48368.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50919.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51307.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___43282$thunk__43283.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___43282$fn__43285.invoke(reducible.clj:108)"],
:card_id 72,
:context :public-dashboard,
:error "Broken pipe",
:row_count 0,
:running_time 0,
:preprocessed
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:user-parameters
[{:type :id,
:value ["3578d760-d5ed-11ec-8c7d-ddca21808446"],
:target [:dimension [:field 602 {:join-alias "Companies"}]],
:id "11f02712"}
{:type :date/all-options, :value "~2022-12-15", :target [:dimension [:field 311 nil]], :id "3afbea9a"}
{:type :date/all-options, :value "2022-12-15~", :target [:dimension [:field 291 nil]], :id "ce8bc124"}],
:info
{:context :public-dashboard,
:card-id 72,
:card-name "Por Vencer",
:dashboard-id 24,
:query-hash
[-49, 43, 125, -25, 15, -97, -126, -103, -107, 92, 63, -77, -120, 53, -102, 32, -43, -116, 37, 82, 59, 123, -27,
-94, 31, -36, -30, 63, 35, 27, -44, 90]},
:database 3,
:query
{:source-table 18,
:filter
[:and
[:=
[:field 306 nil]
[:value
"approved"
{:base_type :type/,
:effective_type :type/,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "ENUM",
:name "payment_status"}]]
[:=
[:field 314 nil]
[:value
"ready"
{:base_type :type/,
:effective_type :type/*,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "ENUM",
:name "status"}]]
[:=
[:field 304 nil]
[:value
false
{:base_type :type/Boolean,
:effective_type :type/Boolean,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "BIT",
:name "is_test"}]]
[:>= [:field 291 {:temporal-unit :default}] [:relative-datetime 0 :week]]
[:< [:field 291 {:temporal-unit :default}] [:relative-datetime 1 :week]]
[:=
[:field 602 {:join-alias "Companies"}]
[:value
"3578d760-d5ed-11ec-8c7d-ddca21808446"
{:base_type :type/Text,
:effective_type :type/Text,
:coercion_strategy nil,
:semantic_type :type/PK,
:database_type "CHAR",
:name "id_token"}]]
[:< [:field 311 {:temporal-unit :default}] [:absolute-datetime #t "2022-12-15T00:00Z[Etc/UTC]" :default]]
[:>= [:field 291 {:temporal-unit :default}] [:absolute-datetime #t "2022-12-16T00:00Z[Etc/UTC]" :default]]],
:aggregation [[:aggregation-options [:count] {:name "count"}]],
:joins
[{:alias "Companies",
:strategy :left-join,
:fields
[[:field 327 {:join-alias "Companies"}]
[:field 602 {:join-alias "Companies"}]
[:field 335 {:join-alias "Companies"}]
[:field 354 {:join-alias "Companies"}]
[:field 326 {:join-alias "Companies"}]
[:field 352 {:join-alias "Companies"}]
[:field 332 {:join-alias "Companies"}]
[:field 347 {:join-alias "Companies"}]
[:field 340 {:join-alias "Companies"}]
[:field 357 {:join-alias "Companies"}]
[:field 334 {:join-alias "Companies"}]
[:field 339 {:join-alias "Companies"}]
[:field 350 {:join-alias "Companies"}]
[:field 328 {:join-alias "Companies"}]
[:field 338 {:join-alias "Companies"}]
[:field 346 {:temporal-unit :default, :join-alias "Companies"}]
[:field 718 {:join-alias "Companies"}]
[:field 730 {:join-alias "Companies"}]
[:field 337 {:temporal-unit :default, :join-alias "Companies"}]
[:field 351 {:join-alias "Companies"}]
[:field 345 {:join-alias "Companies"}]
[:field 331 {:join-alias "Companies"}]
[:field 325 {:join-alias "Companies"}]
[:field 353 {:join-alias "Companies"}]
[:field 333 {:join-alias "Companies"}]
[:field 336 {:join-alias "Companies"}]
[:field 330 {:join-alias "Companies"}]
[:field 348 {:join-alias "Companies"}]
[:field 343 {:join-alias "Companies"}]
[:field 341 {:join-alias "Companies"}]
[:field 356 {:join-alias "Companies"}]
[:field 355 {:join-alias "Companies"}]
[:field 329 {:join-alias "Companies"}]
[:field 344 {:join-alias "Companies"}]
[:field 342 {:join-alias "Companies"}]
[:field 358 {:join-alias "Companies"}]
[:field 349 {:join-alias "Companies"}]
[:field 589 {:join-alias "Companies"}]
[:field 717 {:join-alias "Companies"}]],
:source-table 13,
:condition [:= [:field 303 nil] [:field 327 {:join-alias "Companies"}]]}
{:alias "Smart Campaign Types",
:strategy :left-join,
:fields
[[:field 599 {:join-alias "Smart Campaign Types"}]
[:field 598 {:join-alias "Smart Campaign Types"}]
[:field 600 {:join-alias "Smart Campaign Types"}]],
:source-table 29,
:condition [:= [:field 293 nil] [:field 599 {:join-alias "Smart Campaign Types"}]]}]},
:async? true},
:data {:rows [], :cols []}}`
there or more?
thanks
@franpuebla Latest release is 45.1: https://github.com/metabase/metabase/releases/latest
I don't know if you have a reverse proxy cutting off something, but try latest release, and have a look at request header size too:
https://www.metabase.com/docs/latest/configuring-metabase/environment-variables#mb_jetty_request_header_size
Hi Flamber, now I update and change the variable to MB_JETTY_REQUEST_HEADER_SIZE=24576, but the same story.
1- { "browser-info": { "language": "es-419", "platform": "MacIntel", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36", "vendor": "Google Inc." }, "system-info": { "file.encoding": "UTF-8", "java.runtime.name": "OpenJDK Runtime Environment", "java.runtime.version": "17.0.5+8-Ubuntu-2ubuntu120.04", "java.vendor": "Private Build", "java.vendor.url": "Unknown", "java.version": "17.0.5", "java.vm.name": "OpenJDK 64-Bit Server VM", "java.vm.version": "17.0.5+8-Ubuntu-2ubuntu120.04", "os.name": "Linux", "os.version": "5.15.0-1023-aws", "user.language": "en", "user.timezone": "Etc/UTC" }, "metabase-info": { "databases": [ "mysql" ], "hosting-env": "unknown", "application-database": "mysql", "application-database-details": { "database": { "name": "MySQL", "version": "8.0.31-0ubuntu0.20.04.1" }, "jdbc-driver": { "name": "MariaDB Connector/J", "version": "2.7.6" } }, "run-mode": "prod", "version": { "date": "2022-12-07", "tag": "v0.45.1", "branch": "release-x.45.x", "hash": "019d31c" }, "settings": { "report-timezone": null } } }
2- `[eac8f6a1-2f17-4c38-a5d6-db441df7e0a4] 2022-12-16T10:13:12-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/ff71f8c6-c03a-4649-9abd-d5d6986019fc/dashcard/479/card/251 202 [ASYNC: completed] 105.6 ms (14 llamadas a la BBDD) Conexiones BBDD: 1/13 Hilos Jetty: 4/50 (3 esperando, 0 en cola) (111 hilos totales activos) Consultas en ejecución: 0 (0 en cola)
[eac8f6a1-2f17-4c38-a5d6-db441df7e0a4] 2022-12-16T10:13:12-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error procesando consulta: No se puede ejecutar la consulta: faltan los parámetros necesarios: #{"date_from" "date_to" "content_display"}
{:database_id 3,
:started_at #t "2022-12-16T13:13:12.661770119Z[Etc/UTC]",
: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},
:native
{:query "CALL audience_comparison_by_display ({{date_from}}, {{date_to}}, {{content_display}});",
:template-tags
{"date_from"
{:id "dff8da13-1a6c-21b3-54a1-a2ec62ab59de", :name "date_from", :display-name "Date from", :type :text},
"date_to" {:id "1d40e363-6df2-a065-84dd-a951d2ecf7da", :name "date_to", :display-name "Date to", :type :text},
"content_display"
{:id "ac692260-bbaa-b298-22c6-3b5b498bb41b",
:name "content_display",
:display-name "Content display",
:type :text}}},
:database 3,
:parameters [],
:async? true,
:cache-ttl nil},
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> driver.sql.parameters.substitute$substitute.invokeStatic(substitute.clj:96)"
"driver.sql.parameters.substitute$substitute.invoke(substitute.clj:76)"
"driver.sql$fn__85160$substitute_native_parameters__85153__85165$fn__85169.invoke(sql.clj:46)"
"driver.sql$fn__85160$substitute_native_parameters__85153__85165.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:49)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:40)"
"query_processor.middleware.parameters$expand_all$replace_51356__51357.invoke(parameters.clj:58)"
"mbql.util.match.impl$replace_in_collection$iter__23552__23556$fn__23557.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_51356__51357.invoke(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:58)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:55)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:52)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:76)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:72)"
"query_processor.middleware.parameters$fn__51372$substitute_parameters_STAR___51377$fn__51378.invoke(parameters.clj:81)"
"query_processor.middleware.parameters$fn__51372$substitute_parameters_STAR___51377.invoke(parameters.clj:78)"
"query_processor.middleware.parameters$substitute_parameters.invokeStatic(parameters.clj:108)"
"query_processor.middleware.parameters$substitute_parameters.invoke(parameters.clj:100)"
"query_processor$preprocess_STAR_$fn__54997.invoke(query_processor.clj:127)"
"query_processor$preprocess_STAR_.invokeStatic(query_processor.clj:125)"
"query_processor$preprocess_STAR_.invoke(query_processor.clj:120)"
"query_processor$fn__55005$combined_pre_process__55006$combined_pre_process_STAR___55007.invoke(query_processor.clj:209)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__53450$fn__53455.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:76)"
"driver$do_with_driver.invoke(driver.clj:72)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__53450.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__49450.invoke(fetch_source_query.clj:314)"
"query_processor.middleware.store$initialize_store$fn__49640$fn__49641.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:45)"
"query_processor.store$do_with_store.invoke(store.clj:39)"
"query_processor.middleware.store$initialize_store$fn__49640.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__53722.invoke(normalize_query.clj:22)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__50728.invoke(constraints.clj:53)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__53661.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__54033.invoke(catch_exceptions.clj:167)"
"query_processor.reducible$async_qp$qp_STAR___45482$thunk__45484.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___45482$fn__45486.invoke(reducible.clj:105)"],
:card_id 252,
:context :public-dashboard,
:error
"No se puede ejecutar la consulta: faltan los parámetros necesarios: #{"date_from" "date_to" "content_display"}",
:row_count 0,
:running_time 0,
:ex-data {:type :missing-required-parameter, :missing ("content_display" "date_to" "date_from")},
:data {:rows [], :cols []}}
[eac8f6a1-2f17-4c38-a5d6-db441df7e0a4] 2022-12-16T10:13:12-03:00 DEBUG metabase.server.middleware.log GET /api/public/dashboard/ff71f8c6-c03a-4649-9abd-d5d6986019fc/dashcard/480/card/252 202 [ASYNC: completed] 174.8 ms (14 llamadas a la BBDD) Conexiones BBDD: 0/13 Hilos Jetty: 2/50 (4 esperando, 0 en cola) (111 hilos totales activos) Consultas en ejecución: 0 (0 en cola)`
any idea what it happend?
@franpuebla So you are using Public Sharing, not Signed Embedding.
It says it's missing required parameters. Make sure the dashboard filters are connected to the cards.
I think that in the debug it says that there is nothing in the field, because apparently it would not be able to send it from the public share
https://drive.google.com/file/d/1XPly8i1GuGkTEyJb_5WsnLsQ0f6K7NyY/view?usp=share_link
@franpuebla I cannot say why it's not working. I'm guessing that you have a reverse-proxy doing something that is causing problems.
