I have a dashboard with 2 filters and a question in it, everytime I select one of the filters, the question displays: “There was a problem displaying this chart.”
In the logs this can be seen:
[f64c1517-c2fb-4942-8122-1477941d0304] 2019-09-18T15:40:13+01:00 WARN metabase.query-processor.middleware.process-userland-query Query failure {:status :failed,
:class clojure.lang.ExceptionInfo,
:error (not (integer? “cne_version”)),
:stacktrace
("–> models.params$fn__26319$field_form__GT_id__26324.invoke(params.clj:21)"
“query_processor.middleware.parameters.mbql$fn__38234$build_filter_clause__38239$fn__38249.invoke(mbql.clj:63)”
“query_processor.middleware.parameters.mbql$fn__38234$build_filter_clause__38239.invoke(mbql.clj:39)”
“query_processor.middleware.parameters.mbql$fn__38234$build_filter_clause__38239$fn__38249$iter__38254__38258$fn__38259$fn__38260.invoke(mbql.clj:46)”
“query_processor.middleware.parameters.mbql$fn__38234$build_filter_clause__38239$fn__38249$iter__38254__38258$fn__38259.invoke(mbql.clj:45)”
“query_processor.middleware.parameters.mbql$fn__38234$build_filter_clause__38239$fn__38249.invoke(mbql.clj:45)”
“query_processor.middleware.parameters.mbql$fn__38234$build_filter_clause__38239.invoke(mbql.clj:39)”
“query_processor.middleware.parameters.mbql$expand.invokeStatic(mbql.clj:78)”
“query_processor.middleware.parameters.mbql$expand.invoke(mbql.clj:65)”
“query_processor.middleware.parameters$expand_mbql_params.invokeStatic(parameters.clj:39)”
“query_processor.middleware.parameters$expand_mbql_params.invoke(parameters.clj:35)”
“query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:63)”
“query_processor.middleware.parameters$expand_one.invoke(parameters.clj:56)”
“query_processor.middleware.parameters$expand_all$replace_40406__40407.invoke(parameters.clj:74)”
“mbql.util.match$replace_in_collection$iter__21070__21074$fn__21075.invoke(match.clj:132)”
“mbql.util.match$replace_in_collection.invokeStatic(match.clj:131)”
“mbql.util.match$replace_in_collection.invoke(match.clj:126)”
“query_processor.middleware.parameters$expand_all$replace_40406__40407.invoke(parameters.clj:74)”
“query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:74)”
“query_processor.middleware.parameters$expand_all.invoke(parameters.clj:68)”
“query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:71)”
“query_processor.middleware.parameters$expand_all.invoke(parameters.clj:68)”
“query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:92)”
“query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:88)”
“query_processor.middleware.parameters$substitute_parameters_STAR_.invokeStatic(parameters.clj:97)”
“query_processor.middleware.parameters$substitute_parameters_STAR_.invoke(parameters.clj:94)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__37478.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__40729.invoke(resolve_driver.clj:22)”
“query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__36669$fn__36670.invoke(bind_effective_timezone.clj:9)”
“util.date$call_with_effective_timezone.invokeStatic(date.clj:88)”
“util.date$call_with_effective_timezone.invoke(date.clj:77)”
“query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__36669.invoke(bind_effective_timezone.clj:8)”
“query_processor.middleware.store$initialize_store$fn__43849$fn__43850.invoke(store.clj:11)”
“query_processor.store$do_with_store.invokeStatic(store.clj:46)”
“query_processor.store$do_with_store.invoke(store.clj:40)”
“query_processor.middleware.store$initialize_store$fn__43849.invoke(store.clj:10)”
“query_processor.middleware.async$async__GT_sync$fn__34007.invoke(async.clj:23)”
“query_processor.middleware.async_wait$runnable$fn__36397.invoke(async_wait.clj:89)”),
:query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:userland-query? true},
:info
{:executed-by 157,
:context :question,
:card-id 818,
:dashboard-id nil,
:query-hash [-98, 66, 90, -81, -100, -10, 99, -115, -102, 30, 103, 9, -124, -53, 38, 54, -111, -37, 109, -103, 124, -126, 77, -104, -1, -85, -40, 74, -18, 16, -81, -34]},
:query
{:source-table “card__726”,
:filter [:and [:contains [:field-literal “cne_version” :type/Text] “Fi6” {:case-sensitive false}] [:= [:field-literal “test_status” :type/Text] “Skipped” “Failed”]],
:breakout [[:field-literal “cne_version” :type/Text] [:field-literal “functional_area” :type/Text]],
:aggregation [[:count]]},
:parameters [{:type “category”, :target [“dimension” [“field-literal” “cne_version” “type/Text”]], :value [“Fi6.1.0”]}],
:async? true,
:cache-ttl nil},
:preprocessed nil,
:native nil,
:ex-data {:type :schema.core/error, :value “cne_version”, :error (not (integer? “cne_version”))}}
The question is based on another one which is SQL native.
Metabase version: 0.33.2
on the first post: