Input to date-string->range does not match schema

jlcornejo · February 15, 2022, 5:32pm

Update to version 0.42.0 and I have been reported several errors in the visualizations.

If you select the date filter, the dashboard works again.

Reviewing the log, the error it indicates is:

Input to date-string->range does not match schema

when opening the question, it works with the same filters.

[bb430c90-003e-4fef-8b13-7cf41814e008] 2022-02-15T14:24:06-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error procesando consulta: null
{:database_id 33,
 :started_at #t "2022-02-15T17:24:02.693728Z[GMT]",
 :via
 [{:status :failed,
   :class clojure.lang.ExceptionInfo,
   :error
   "No se pueden sustituir los parámetros: Input to date-string->range does not match schema: \n\n\t   [(named (not (instance? java.lang.String nil)) date-string) nil]  \n\n",
   :stacktrace
   ["--> driver.sql.parameters.substitute$substitute$fn__78003.invoke(substitute.clj:83)"
    "driver.sql.parameters.substitute$substitute.invokeStatic(substitute.clj:80)"
    "driver.sql.parameters.substitute$substitute.invoke(substitute.clj:71)"
    "driver.sql$fn__78521$substitute_native_parameters__78514__78526$fn__78530.invoke(sql.clj:46)"
    "driver.sql$fn__78521$substitute_native_parameters__78514__78526.invoke(sql.clj:42)"
    "query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
    "query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
    "query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:50)"
    "query_processor.middleware.parameters$expand_one.invoke(parameters.clj:41)"
    "query_processor.middleware.parameters$expand_all$replace_48586__48587.invoke(parameters.clj:59)"
    "mbql.util.match.impl$replace_in_collection$iter__27401__27405$fn__27406.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_48586__48587.invoke(parameters.clj:59)"
    "query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:59)"
    "query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
    "query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:56)"
    "query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
    "query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:77)"
    "query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:73)"
    "query_processor.middleware.parameters$fn__48602$substitute_parameters_STAR___48607$fn__48608.invoke(parameters.clj:82)"
    "query_processor.middleware.parameters$fn__48602$substitute_parameters_STAR___48607.invoke(parameters.clj:79)"
    "query_processor.middleware.parameters$substitute_parameters$fn__48628.invoke(parameters.clj:111)"
    "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46025.invoke(resolve_referenced.clj:79)"
    "query_processor.middleware.expand_macros$expand_macros$fn__52249.invoke(expand_macros.clj:184)"
    "query_processor.middleware.add_timezone_info$add_timezone_info$fn__48407.invoke(add_timezone_info.clj:15)"
    "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51200.invoke(splice_params_in_response.clj:32)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50647$fn__50652.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__50647.invoke(resolve_database_and_driver.clj:34)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46571.invoke(fetch_source_query.clj:286)"
    "query_processor.middleware.store$initialize_store$fn__46762$fn__46763.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__46762.invoke(store.clj:10)"
    "query_processor.middleware.validate$validate_query$fn__50982.invoke(validate.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__50989.invoke(normalize_query.clj:22)"
    "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48353.invoke(add_rows_truncated.clj:35)"
    "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49645.invoke(results_metadata.clj:82)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__48371.invoke(constraints.clj:42)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__50923.invoke(process_userland_query.clj:146)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__51280.invoke(catch_exceptions.clj:169)"
    "query_processor.reducible$async_qp$qp_STAR___43323$thunk__43324.invoke(reducible.clj:103)"
    "query_processor.reducible$async_qp$qp_STAR___43323$fn__43326.invoke(reducible.clj:108)"],
   :error_type :invalid-query,
   :ex-data

flamber · February 15, 2022, 5:40pm

Hi @jlcornejo
Have a look at closed issue coming in 0.42.1 (maybe today, maybe tomorrow)
https://github.com/metabase/metabase/milestone/150?closed=1

jlcornejo · February 15, 2022, 5:49pm

I did not find a similar error T_T

flamber · February 15, 2022, 5:53pm

@jlcornejo Then provide steps to reproduce. It looks like you are trying to connect different types of filters together:
https://github.com/metabase/metabase/issues/20048

jlcornejo · February 15, 2022, 6:11pm

Remove the default filter and all questions on the board work.
Although this is disabled, it generates problems.

Turning off the default settings magically makes everything work again.

The problem is that I need a default filter when starting the dashboard, loading the whole history is very slow.

Reviewing the log, the filter is appreciated, even if it is deactivated.

:value {:type :date/all-options, :id "a467c9cf", :default "next30days~"}}),

filtering a time range, also works

the problem must be the default time filter

I will keep checking

jlcornejo · February 15, 2022, 6:23pm

Checking again, I found a similar problem. (sorry for replicate)