Error processing query: For input string when doing filtering from dashboard

Bug reports
1

Hello, I am encountering an error that seems similar to this one: Error when filter list of values in metamodel
but in this case it is:

2022-11-04 15:45:36,701 [streaming-response-thread-pool-154] ERRORmetabase.query-processor.middleware.catch-exceptions - Error processing query: For input string: "2016-02-08T16:33:41+01:00"
{:database_id 36,
 :started_at #t "2022-11-04T15:45:36.365237700+01:00[Europe/Berlin]",
 :via
 [{:status :failed,
   :class clojure.lang.ExceptionInfo,
   :error
   "Error filtering against :type/Float Field: unable to parse String \"2016-02-08T16:33:41+01:00\" to a :type/Float",
   :stacktrace
   ["--> query_processor.middleware.auto_parse_filter_values$fn__51586$parse_value_for_base_type__51591$fn__51592.invoke(auto_parse_filter_values.clj:25)"
    "query_processor.middleware.auto_parse_filter_values$fn__51586$parse_value_for_base_type__51591.invoke(auto_parse_filter_values.clj:14)"
    "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__51608$replace_51609__51610.invoke(auto_parse_filter_values.clj:35)"
    "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$fn__51608$replace_51609__51610.invoke(auto_parse_filter_values.clj:35)"
    "mbql.util.match.impl$replace_in_collection$iter__20188__20192$fn__20193.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$fn__51608$replace_51609__51610.invoke(auto_parse_filter_values.clj:35)"
    "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__51608.invoke(auto_parse_filter_values.clj:35)"
    "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.invokeStatic(auto_parse_filter_values.clj:35)"
    "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values.invoke(auto_parse_filter_values.clj:32)"
    "query_processor$preprocess_STAR_$fn__54090.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__54098$combined_pre_process__54099$combined_pre_process_STAR___54100.invoke(query_processor.clj:209)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52543$fn__52548.invoke(resolve_database_and_driver.clj:35)"
    "driver$do_with_driver.invokeStatic(driver.clj:75)"
    "driver$do_with_driver.invoke(driver.clj:71)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52543.invoke(resolve_database_and_driver.clj:34)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48578.invoke(fetch_source_query.clj:349)"
    "query_processor.middleware.store$initialize_store$fn__48766$fn__48767.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__48766.invoke(store.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__52815.invoke(normalize_query.clj:22)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__49848.invoke(constraints.clj:53)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__52754.invoke(process_userland_query.clj:145)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__53126.invoke(catch_exceptions.clj:167)"
    "query_processor.reducible$async_qp$qp_STAR___44981$thunk__44983.invoke(reducible.clj:100)"
    "query_processor.reducible$async_qp$qp_STAR___44981.invoke(reducible.clj:106)"
    "query_processor.reducible$async_qp$qp_STAR___44981.invoke(reducible.clj:91)"
    "query_processor.reducible$sync_qp$qp_STAR___44992.doInvoke(reducible.clj:126)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:331)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:327)"
    "query_processor$fn__54145$process_query_and_save_execution_BANG___54154$fn__54157.invoke(query_processor.clj:342)"
    "query_processor$fn__54145$process_query_and_save_execution_BANG___54154.invoke(query_processor.clj:335)"
    "query_processor$fn__54189$process_query_and_save_with_max_results_constraints_BANG___54198$fn__54201.invoke(query_processor.clj:354)"
    "query_processor$fn__54189$process_query_and_save_with_max_results_constraints_BANG___54198.invoke(query_processor.clj:347)"
    "api.dataset$run_query_async$fn__68895.invoke(dataset.clj:69)"
    "query_processor.streaming$streaming_response_STAR_$fn__40099$fn__40100.invoke(streaming.clj:162)"
    "query_processor.streaming$streaming_response_STAR_$fn__40099.invoke(streaming.clj:161)"
    "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$task__19006.invoke(streaming_response.clj:84)"],
   :error_type :invalid-query,
   :ex-data {:type :invalid-query}}],
 :error_type :invalid-query,
 :json_query
 {:database 36,
  :query
  {:fields [["field" 72806 nil] ["field" 72811 nil] ["field" 72812 nil]],
   :filter ["between" ["field" 72806 nil] "2016-02-08T16:33:41+01:00" "2022-08-07T19:41:27+02:00"],
   :source-table "card__92"},
  :type "query",
  :parameters [],
  :middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
 :native nil,
 :status :failed,
 :class java.lang.NumberFormatException,
 :stacktrace
 ["java.base/jdk.internal.math.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2054)"
  "java.base/jdk.internal.math.FloatingDecimal.parseDouble(FloatingDecimal.java:110)"
  "java.base/java.lang.Double.parseDouble(Double.java:651)"
  "--> query_processor.middleware.auto_parse_filter_values$fn__51586$parse_value_for_base_type__51591$fn__51592.invoke(auto_parse_filter_values.clj:21)"
  "query_processor.middleware.auto_parse_filter_values$fn__51586$parse_value_for_base_type__51591.invoke(auto_parse_filter_values.clj:14)"
  "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__51608$replace_51609__51610.invoke(auto_parse_filter_values.clj:35)"
  "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$fn__51608$replace_51609__51610.invoke(auto_parse_filter_values.clj:35)"
  "mbql.util.match.impl$replace_in_collection$iter__20188__20192$fn__20193.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$fn__51608$replace_51609__51610.invoke(auto_parse_filter_values.clj:35)"
  "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__51608.invoke(auto_parse_filter_values.clj:35)"
  "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.invokeStatic(auto_parse_filter_values.clj:35)"
  "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values.invoke(auto_parse_filter_values.clj:32)"
  "query_processor$preprocess_STAR_$fn__54090.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__54098$combined_pre_process__54099$combined_pre_process_STAR___54100.invoke(query_processor.clj:209)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52543$fn__52548.invoke(resolve_database_and_driver.clj:35)"
  "driver$do_with_driver.invokeStatic(driver.clj:75)"
  "driver$do_with_driver.invoke(driver.clj:71)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52543.invoke(resolve_database_and_driver.clj:34)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48578.invoke(fetch_source_query.clj:349)"
  "query_processor.middleware.store$initialize_store$fn__48766$fn__48767.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__48766.invoke(store.clj:10)"
  "query_processor.middleware.normalize_query$normalize$fn__52815.invoke(normalize_query.clj:22)"
  "query_processor.middleware.constraints$add_default_userland_constraints$fn__49848.invoke(constraints.clj:53)"
  "query_processor.middleware.process_userland_query$process_userland_query$fn__52754.invoke(process_userland_query.clj:145)"
  "query_processor.middleware.catch_exceptions$catch_exceptions$fn__53126.invoke(catch_exceptions.clj:167)"
  "query_processor.reducible$async_qp$qp_STAR___44981$thunk__44983.invoke(reducible.clj:100)"
  "query_processor.reducible$async_qp$qp_STAR___44981.invoke(reducible.clj:106)"
  "query_processor.reducible$async_qp$qp_STAR___44981.invoke(reducible.clj:91)"
  "query_processor.reducible$sync_qp$qp_STAR___44992.doInvoke(reducible.clj:126)"
  "query_processor$process_userland_query.invokeStatic(query_processor.clj:331)"
  "query_processor$process_userland_query.doInvoke(query_processor.clj:327)"
  "query_processor$fn__54145$process_query_and_save_execution_BANG___54154$fn__54157.invoke(query_processor.clj:342)"
  "query_processor$fn__54145$process_query_and_save_execution_BANG___54154.invoke(query_processor.clj:335)"
  "query_processor$fn__54189$process_query_and_save_with_max_results_constraints_BANG___54198$fn__54201.invoke(query_processor.clj:354)"
  "query_processor$fn__54189$process_query_and_save_with_max_results_constraints_BANG___54198.invoke(query_processor.clj:347)"
  "api.dataset$run_query_async$fn__68895.invoke(dataset.clj:69)"
  "query_processor.streaming$streaming_response_STAR_$fn__40099$fn__40100.invoke(streaming.clj:162)"
  "query_processor.streaming$streaming_response_STAR_$fn__40099.invoke(streaming.clj:161)"
  "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$task__19006.invoke(streaming_response.clj:84)"],
 :card_id 92,
 :context :ad-hoc,
 :error "For input string: \"2016-02-08T16:33:41+01:00\"",
 :row_count 0,
 :running_time 0,
 :preprocessed nil,
 :data {:rows [], :cols []}}

t string: \"2016-02-08T16:33:41+01:00\"",
 :row_count 0,
 :running_time 0,
 :preprocessed nil,
 :data {:rows [], :cols []}}

It seems to come down to the field 'Jahr' which contains years as four digit numbers in the database. Although I have set this to type 'creation date' in datamodel settings for this column (which works great, it can be displayed along other time series), when filtering this still seems to create an error.

Is there any ideo how to come around of this?

2

Hi @mmoole
Looks like similar problem like:
https://github.com/metabase/metabase/issues/25994 - upvote by clicking :+1: on the first post
Metabase doesn't have a "year" type, so you should just use "No special type" or "Quantity". Otherwise you would have to convert your year column to be set as a date instead (yyyy-01-01).