Hello!
We have used metabase version v0.41.6 Built on 2022-01-10.
We created metamodel in this metabase and filtered list of values. Datasource - clickhouse.
We got error.
Hi @Olga
Looks like a problem with the driver, so have a look at the issues: https://github.com/enqueue/metabase-clickhouse-driver/issues
Check the logs for detailed error in Admin > Troubleshooting > Logs.
Thank you, @flamber.
In logs :error "Error filtering against :type/Integer Field: unable to parse String "Approved Expert" to a :type/Integer" because we created foreign key and chose Display values (use foreign key - name)
And we filter list of values - names with type string.
Log
[da316804-2311-40f3-9e31-05f3559c26e3] 2022-02-09T23:51:45+03:00 ERROR metabase.server.middleware.log GET /api/field/30714/remapping/30715 500 5.7 ms (4 DB calls)
{:via
[{:type java.text.ParseException,
:message "Unparseable number: "Approved Expert"",
:at [java.text.NumberFormat parse nil -1]}],
:trace
[[java.text.NumberFormat parse nil -1]
[metabase.api.field$parse_query_param_value_for_field invokeStatic "field.clj" 403]
[metabase.api.field$parse_query_param_value_for_field invoke "field.clj" 398]
[metabase.api.field$fn__74436 invokeStatic "field.clj" 411]
[metabase.api.field$fn__74436 invoke "field.clj" 406]
[compojure.core$wrap_response$fn__32066 invoke "core.clj" 160]
[compojure.core$wrap_route_middleware$fn__32050 invoke "core.clj" 132]
[compojure.core$wrap_route_info$fn__32055 invoke "core.clj" 139]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 151]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 152]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 153]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 152]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 152]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 153]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 152]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 152]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 152]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 153]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 153]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 153]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 153]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078 invoke "core.clj" 200]
[metabase.server.middleware.auth$enforce_authentication$fn__70370 invoke "auth.clj" 14]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078 invoke "core.clj" 200]
[compojure.core$make_context$handler__32106 invoke "core.clj" 289]
[compojure.core$make_context$fn__32110 invoke "core.clj" 299]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$make_context$fn__32110 invoke "core.clj" 300]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[metabase.api.routes$fn__79847$fn__79850 invoke "routes.clj" 56]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078 invoke "core.clj" 200]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.core$apply invokeStatic "core.clj" 667]
[clojure.core$apply invoke "core.clj" 662]
[metabase.server.routes$fn__79992$fn__79993 doInvoke "routes.clj" 57]
[clojure.lang.RestFn invoke "RestFn.java" 436]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078 invoke "core.clj" 200]
[compojure.core$make_context$handler__32106 invoke "core.clj" 289]
[compojure.core$make_context$fn__32110 invoke "core.clj" 299]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 152]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 152]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__32059 invoke "core.clj" 152]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078$f__32079$respond_SINGLEQUOTE___32080 invoke "core.clj" 197]
[metabase.server.routes$fn__79980$fn__79982 invoke "routes.clj" 41]
[compojure.core$routes$fn__32078$f__32079 invoke "core.clj" 198]
[compojure.core$routes$fn__32078 invoke "core.clj" 200]
[metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__77452 invoke "exceptions.clj" 98]
[metabase.server.middleware.exceptions$catch_api_exceptions$fn__77449 invoke "exceptions.clj" 86]
[metabase.server.middleware.log$log_api_call$fn__80447$fn__80448$fn__80449 invoke "log.clj" 209]
[metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info invokeStatic "diagnostic.clj" 15]
[metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info invoke "diagnostic.clj" 9]
[metabase.server.middleware.log$log_api_call$fn__80447$fn__80448 invoke "log.clj" 201]
[toucan.db$_do_with_call_counting invokeStatic "db.clj" 216]
[toucan.db$_do_with_call_counting invoke "db.clj" 209]
[metabase.server.middleware.log$log_api_call$fn__80447 invoke "log.clj" 200]
[metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__83660 invoke "browser_cookie.clj" 30]
[metabase.server.middleware.security$add_security_headers$fn__59285 invoke "security.clj" 147]
[metabase.server.middleware.json$wrap_json_body$fn__82804 invoke "json.clj" 62]
[metabase.server.middleware.json$wrap_streamed_json_response$fn__82822 invoke "json.clj" 98]
[metabase.server.middleware.offset_paging$handle_paging$fn__59309 invoke "offset_paging.clj" 42]
[ring.middleware.keyword_params$wrap_keyword_params$fn__83927 invoke "keyword_params.clj" 55]
[ring.middleware.params$wrap_params$fn__83943 invoke "params.clj" 69]
[metabase.server.middleware.misc$maybe_set_site_url$fn__34077 invoke "misc.clj" 59]
[metabase.server.middleware.session$bind_current_user$fn__44982$fn__44983 invoke "session.clj" 257]
[metabase.server.middleware.session$do_with_current_user invokeStatic "session.clj" 238]
[metabase.server.middleware.session$do_with_current_user invoke "session.clj" 230]
[metabase.server.middleware.session$bind_current_user$fn__44982 invoke "session.clj" 256]
[metabase.server.middleware.session$wrap_current_user_info$fn__44969 invoke "session.clj" 216]
[metabase.server.middleware.session$wrap_session_id$fn__44955 invoke "session.clj" 162]
[metabase.server.middleware.auth$wrap_api_key$fn__70378 invoke "auth.clj" 27]
[ring.middleware.cookies$wrap_cookies$fn__83847 invoke "cookies.clj" 216]
[metabase.server.middleware.misc$add_content_type$fn__34060 invoke "misc.clj" 27]
[metabase.server.middleware.misc$disable_streaming_buffering$fn__34085 invoke "misc.clj" 76]
[ring.middleware.gzip$wrap_gzip$fn__83889 invoke "gzip.clj" 86]
[metabase.server.middleware.misc$bind_request$fn__34088 invoke "misc.clj" 93]
[metabase.server.middleware.ssl$redirect_to_https_middleware$fn__83676 invoke "ssl.clj" 38]
[metabase.server$async_proxy_handler$fn__80220 invoke "server.clj" 71]
[metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a handle nil -1]
[org.eclipse.jetty.server.handler.HandlerWrapper handle "HandlerWrapper.java" 127]
[org.eclipse.jetty.server.Server handle "Server.java" 516]
[org.eclipse.jetty.server.HttpChannel lambda$handle$1 "HttpChannel.java" 388]
[org.eclipse.jetty.server.HttpChannel dispatch "HttpChannel.java" 633]
[org.eclipse.jetty.server.HttpChannel handle "HttpChannel.java" 380]
[org.eclipse.jetty.server.HttpConnection onFillable "HttpConnection.java" 277]
[org.eclipse.jetty.io.AbstractConnection$ReadCallback succeeded "AbstractConnection.java" 311]
[org.eclipse.jetty.io.FillInterest fillable "FillInterest.java" 105]
[org.eclipse.jetty.io.ChannelEndPoint$1 run "ChannelEndPoint.java" 104]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill runTask "EatWhatYouKill.java" 338]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill doProduce "EatWhatYouKill.java" 315]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill tryProduce "EatWhatYouKill.java" 173]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill run "EatWhatYouKill.java" 131]
[org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread run "ReservedThreadExecutor.java" 386]
[org.eclipse.jetty.util.thread.QueuedThreadPool runJob "QueuedThreadPool.java" 883]
[org.eclipse.jetty.util.thread.QueuedThreadPool$Runner run "QueuedThreadPool.java" 1034]
[java.lang.Thread run nil -1]],
:cause "Unparseable number: "Approved Expert"",
:message "Unparseable number: "Approved Expert""}
[da316804-2311-40f3-9e31-05f3559c26e3] 2022-02-09T23:51:46+03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 3,
:started_at #t "2022-02-09T20:51:46.388706Z[GMT]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Error filtering against :type/Integer Field: unable to parse String "Approved Expert" to a :type/Integer",
:stacktrace
["--> query_processor.middleware.auto_parse_filter_values$fn__49167$parse_value_for_base_type__49172$fn__49173.invoke(auto_parse_filter_values.clj:25)"
"query_processor.middleware.auto_parse_filter_values$fn__49167$parse_value_for_base_type__49172.invoke(auto_parse_filter_values.clj:14)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values_STAR_$fn__49189$replace_49190__49191.invoke(auto_parse_filter_values.clj:33)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:47)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values_STAR_$fn__49189$replace_49190__49191.invoke(auto_parse_filter_values.clj:33)"
"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.auto_parse_filter_values$auto_parse_filter_values_STAR_$fn__49189$replace_49190__49191.invoke(auto_parse_filter_values.clj:33)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values_STAR_$fn__49189.invoke(auto_parse_filter_values.clj:33)"
"mbql.util.match.impl$update_in_unless_empty.invokeStatic(impl.cljc:58)"
"mbql.util.match.impl$update_in_unless_empty.doInvoke(impl.cljc:53)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values_STAR_.invokeStatic(auto_parse_filter_values.clj:33)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values_STAR_.invoke(auto_parse_filter_values.clj:32)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49205.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39253.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__43684.invoke(annotate.clj:620)"
"query_processor.middleware.permissions$check_query_permissions$fn__45622.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__50185.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46020.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__45958.invoke(visualization_settings.clj:63)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47119.invoke(resolve_joined_fields.clj:102)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__50771.invoke(resolve_joins.clj:171)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__50307.invoke(add_implicit_joins.clj:190)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47138.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__50359.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46510.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__45931.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__39153.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45265.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__49560.invoke(add_dimension_projections.clj:314)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__49857.invoke(add_implicit_clauses.clj:147)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47506.invoke(upgrade_field_literals.clj:40)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__46887.invoke(add_source_metadata.clj:123)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50107.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48457.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45246.invoke(resolve_source_table.clj:45)"
"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.invoke(reducible.clj:109)"
"query_processor.reducible$sync_qp$qp_STAR___42513$fn__42516.invoke(reducible.clj:135)"
"query_processor.reducible$sync_qp$qp_STAR___42513.invoke(reducible.clj:134)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:243)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:239)"
"query_processor$fn__51477$process_query_and_save_execution_BANG___51486$fn__51489.invoke(query_processor.clj:255)"
"query_processor$fn__51477$process_query_and_save_execution_BANG___51486.invoke(query_processor.clj:247)"
"query_processor$fn__51521$process_query_and_save_with_max_results_constraints_BANG___51530$fn__51533.invoke(query_processor.clj:267)"
"query_processor$fn__51521$process_query_and_save_with_max_results_constraints_BANG___51530.invoke(query_processor.clj:260)"
"api.dataset$run_query_async$fn__57869.invoke(dataset.clj:64)"
"query_processor.streaming$streaming_response_STAR_$fn__38062$fn__38063.invoke(streaming.clj:159)"
"query_processor.streaming$streaming_response_STAR_$fn__38062.invoke(streaming.clj:158)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
"async.streaming_response$do_f_async$fn__25229.invoke(streaming_response.clj:84)"],
:error_type :invalid-query,
:ex-data {:type :invalid-query}}],
:error_type :invalid-query,
:json_query
{:type "query",
:query {:source-table 2411, :filter ["=" ["field" 24638 nil] "Approved Expert"]},
:database 3,
:parameters ,
:middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.NumberFormatException,
:stacktrace
["java.base/java.lang.NumberFormatException.forInputString(Unknown Source)"
"java.base/java.lang.Long.parseLong(Unknown Source)"
"java.base/java.lang.Long.parseLong(Unknown Source)"
"--> query_processor.middleware.auto_parse_filter_values$fn__49167$parse_value_for_base_type__49172$fn__49173.invoke(auto_parse_filter_values.clj:19)"
"query_processor.middleware.auto_parse_filter_values$fn__49167$parse_value_for_base_type__49172.invoke(auto_parse_filter_values.clj:14)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values_STAR_$fn__49189$replace_49190__49191.invoke(auto_parse_filter_values.clj:33)"
"mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:47)"
"mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:38)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values_STAR_$fn__49189$replace_49190__49191.invoke(auto_parse_filter_values.clj:33)"
"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.auto_parse_filter_values$auto_parse_filter_values_STAR_$fn__49189$replace_49190__49191.invoke(auto_parse_filter_values.clj:33)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values_STAR_$fn__49189.invoke(auto_parse_filter_values.clj:33)"
"mbql.util.match.impl$update_in_unless_empty.invokeStatic(impl.cljc:58)"
"mbql.util.match.impl$update_in_unless_empty.doInvoke(impl.cljc:53)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values_STAR_.invokeStatic(auto_parse_filter_values.clj:33)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values_STAR_.invoke(auto_parse_filter_values.clj:32)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49205.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39253.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__43684.invoke(annotate.clj:620)"
"query_processor.middleware.permissions$check_query_permissions$fn__45622.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__50185.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46020.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__45958.invoke(visualization_settings.clj:63)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47119.invoke(resolve_joined_fields.clj:102)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__50771.invoke(resolve_joins.clj:171)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__50307.invoke(add_implicit_joins.clj:190)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47138.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__50359.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46510.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__45931.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__39153.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45265.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__49560.invoke(add_dimension_projections.clj:314)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__49857.invoke(add_implicit_clauses.clj:147)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47506.invoke(upgrade_field_literals.clj:40)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__46887.invoke(add_source_metadata.clj:123)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50107.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48457.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45246.invoke(resolve_source_table.clj:45)"
"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.invoke(reducible.clj:109)"
"query_processor.reducible$sync_qp$qp_STAR___42513$fn__42516.invoke(reducible.clj:135)"
"query_processor.reducible$sync_qp$qp_STAR___42513.invoke(reducible.clj:134)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:243)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:239)"
"query_processor$fn__51477$process_query_and_save_execution_BANG___51486$fn__51489.invoke(query_processor.clj:255)"
"query_processor$fn__51477$process_query_and_save_execution_BANG___51486.invoke(query_processor.clj:247)"
"query_processor$fn__51521$process_query_and_save_with_max_results_constraints_BANG___51530$fn__51533.invoke(query_processor.clj:267)"
"query_processor$fn__51521$process_query_and_save_with_max_results_constraints_BANG___51530.invoke(query_processor.clj:260)"
"api.dataset$run_query_async$fn__57869.invoke(dataset.clj:64)"
"query_processor.streaming$streaming_response_STAR_$fn__38062$fn__38063.invoke(streaming.clj:159)"
"query_processor.streaming$streaming_response_STAR_$fn__38062.invoke(streaming.clj:158)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
"async.streaming_response$do_f_async$fn__25229.invoke(streaming_response.clj:84)"],
:card_id nil,
:context :ad-hoc,
:error "For input string: "Approved Expert"",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows , :cols }}
@Olga Sounds like https://github.com/metabase/metabase/issues/13235, which was just fixed in 0.42.0, but I cannot tell if the driver also needs a change or not.