Metabase search is giving an "Error normalizing query" error. The following log gives error reference "database" -1337," and "source-table" "card__2805". it seems this issue could be due to the wrong data stored in the system. Can you please explain how can I find the faulty data?
`{:via
[{:type clojure.lang.ExceptionInfo,
:message "Error normalizing query",
:data
{:query
{"database" -1337,
"type" "query",
"query"
{"source-table" "card__2805",
"filter"
["and"
["between"
["datetime-field" ["field-literal" "invoice_date" "type/Date"] "minute"]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]
["between"
["datetime-field" ["field-literal" "customer_created" "type/DateTime"] "minute"]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]],
"aggregation"
[["sum" ["field-literal" "revenue" "type/Decimal"]]
["distinct" ["field-literal" "customer" "type/Text"]]
["count"]]}}},
:at [metabase.mbql.normalize$fn__27387$fn__27388 invoke "normalize.cljc" 797]}
{:type clojure.lang.ExceptionInfo,
:message "Error canonicalizing query",
:data
{:query
{:source-table "card__2805",
:filter
[:and
[:between
[:datetime-field [:field-literal "invoice_date" :type/Date] :minute]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]
[:between
[:datetime-field [:field-literal "customer_created" :type/DateTime] :minute]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]],
:aggregation
[[:sum [:field-literal "revenue" :type/Decimal]] [:distinct [:field-literal "customer" :type/Text]] [:count]]}},
:at [metabase.mbql.normalize$canonicalize invokeStatic "normalize.cljc" 678]}
{:type clojure.lang.ExceptionInfo,
:message "Invalid MBQL clause",
:data
{:clause
[:and
[:between
[:datetime-field [:field-literal "invoice_date" :type/Date] :minute]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]
[:between
[:datetime-field [:field-literal "customer_created" :type/DateTime] :minute]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]]},
:at [metabase.mbql.normalize$canonicalize_mbql_clauses$fn__27232 invoke "normalize.cljc" 556]}
{:type clojure.lang.ExceptionInfo,
:message
"Output of update-field-options does not match schema: \n\n\t e[0;33m [nil nil (named (not (\"Invalid :temporal-unit for the specified :base-type.\" a-clojure.lang.PersistentArrayMap)) \"options\")] e[0m \n\n",
:data
{:type :schema.core/error,
:schema
(constrained
[(one (eq :field) :field)
(one (cond-pre (constrained Int "positive integer") (constrained Str "Non-blank string")) "id-or-name")
(one (maybe (recursive #'metabase.mbql.schema/FieldOptions)) "options")]
":field clauses using a string field name must specify :base-type."),
:value [:field "invoice_date" {:base-type :type/Date, :temporal-unit :minute}],
:error
[nil
nil
(named (not ("Invalid :temporal-unit for the specified :base-type." a-clojure.lang.PersistentArrayMap)) "options")]},
:at [metabase.mbql.util$fn__26790$update_field_options__26795 doInvoke "util.cljc" 587]}],
:trace
[[metabase.mbql.util$fn__26790$update_field_options__26795 doInvoke "util.cljc" 587]
[clojure.lang.RestFn applyTo "RestFn.java" 142]
[clojure.core$apply invokeStatic "core.clj" 671]
[clojure.core$apply invoke "core.clj" 662]
[metabase.mbql.util$assoc_field_options invokeStatic "util.cljc" 595]
[metabase.mbql.util$assoc_field_options doInvoke "util.cljc" 592]
[clojure.lang.RestFn invoke "RestFn.java" 439]
[metabase.mbql.util$with_temporal_unit invokeStatic "util.cljc" 600]
[metabase.mbql.util$with_temporal_unit invoke "util.cljc" 597]
[metabase.mbql.normalize$fn__27060 invokeStatic "normalize.cljc" 405]
[metabase.mbql.normalize$fn__27060 invoke "normalize.cljc" 399]
[clojure.lang.MultiFn invoke "MultiFn.java" 229]
[metabase.mbql.normalize$canonicalize_implicit_field_id invokeStatic "normalize.cljc" 364]
[metabase.mbql.normalize$canonicalize_implicit_field_id invoke "normalize.cljc" 361]
[metabase.mbql.normalize$canonicalize_simple_filter_clause invokeStatic "normalize.cljc" 456]
[metabase.mbql.normalize$canonicalize_simple_filter_clause invoke "normalize.cljc" 453]
[metabase.mbql.normalize$fn__27117$fn__27118 invoke "normalize.cljc" 465]
[clojure.lang.MultiFn invoke "MultiFn.java" 229]
[clojure.core$map$fn__5884 invoke "core.clj" 2757]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5419 invokeStatic "core.clj" 139]
[clojure.core.protocols$seq_reduce invokeStatic "protocols.clj" 24]
[clojure.core.protocols$fn__8168 invokeStatic "protocols.clj" 75]
[clojure.core.protocols$fn__8168 invoke "protocols.clj" 75]
[clojure.core.protocols$fn__8110$G__8105__8123 invoke "protocols.clj" 13]
[clojure.core$reduce invokeStatic "core.clj" 6830]
[clojure.core$into invokeStatic "core.clj" 6897]
[clojure.core$into invoke "core.clj" 6889]
[metabase.mbql.normalize$canonicalize_compound_filter_clause invokeStatic "normalize.cljc" 426]
[metabase.mbql.normalize$canonicalize_compound_filter_clause invoke "normalize.cljc" 424]
[metabase.mbql.normalize$fn__27087$fn__27088 invoke "normalize.cljc" 434]
[clojure.lang.MultiFn invoke "MultiFn.java" 229]
[metabase.mbql.normalize$canonicalize_mbql_clauses$fn__27232 invoke "normalize.cljc" 553]
[clojure.walk$prewalk invokeStatic "walk.clj" 65]
[clojure.walk$prewalk invoke "walk.clj" 61]
[metabase.mbql.normalize$canonicalize_mbql_clauses invokeStatic "normalize.cljc" 542]
[metabase.mbql.normalize$canonicalize_mbql_clauses invoke "normalize.cljc" 539]
[medley.core$map_vals$fn__5607$fn__5608 invoke "core.cljc" 110]
[clojure.lang.PersistentArrayMap kvreduce "PersistentArrayMap.java" 377]
[clojure.core$fn__8460 invokeStatic "core.clj" 6847]
[clojure.core$fn__8460 invoke "core.clj" 6832]
[clojure.core.protocols$fn__8189$G__8184__8198 invoke "protocols.clj" 175]
[clojure.core$reduce_kv invokeStatic "core.clj" 6858]
[clojure.core$reduce_kv invoke "core.clj" 6849]
[medley.core$reduce_map invokeStatic "core.cljc" 84]
[medley.core$reduce_map invoke "core.cljc" 81]
[medley.core$map_vals invokeStatic "core.cljc" 110]
[medley.core$map_vals invoke "core.cljc" 105]
[metabase.mbql.normalize$canonicalize_mbql_clauses$fn__27232 invoke "normalize.cljc" 546]
[clojure.walk$prewalk invokeStatic "walk.clj" 65]
[clojure.walk$prewalk invoke "walk.clj" 61]
[metabase.mbql.normalize$canonicalize_mbql_clauses invokeStatic "normalize.cljc" 542]
[metabase.mbql.normalize$canonicalize_mbql_clauses invoke "normalize.cljc" 539]
[clojure.core$comp$fn__5825 invoke "core.clj" 2573]
[clojure.core$update invokeStatic "core.clj" 6185]
[clojure.core$update invoke "core.clj" 6177]
[metabase.mbql.normalize$canonicalize invokeStatic "normalize.cljc" 673]
[metabase.mbql.normalize$canonicalize invoke "normalize.cljc" 666]
[clojure.core$comp$fn__5825 invoke "core.clj" 2573]
[clojure.core$comp$fn__5825 invoke "core.clj" 2573]
[metabase.mbql.normalize$fn__27387$fn__27388 invoke "normalize.cljc" 795]
[metabase.search.scoring$serialize$fn__77600 invoke "scoring.clj" 232]
[clojure.core$update invokeStatic "core.clj" 6185]
[clojure.core$update invoke "core.clj" 6177]
[metabase.search.scoring$serialize invokeStatic "scoring.clj" 232]
[metabase.search.scoring$serialize invoke "scoring.clj" 214]
[metabase.search.scoring$score_and_result invokeStatic "scoring.clj" 289]
[metabase.search.scoring$score_and_result invoke "scoring.clj" 278]
[metabase.search.scoring$score_and_result invokeStatic "scoring.clj" 281]
[metabase.search.scoring$score_and_result invoke "scoring.clj" 278]
[clojure.core$partial$fn__5857 invoke "core.clj" 2628]
[clojure.core$map$fn__5880$fn__5881 invoke "core.clj" 2746]
[clojure.core$map$fn__5880$fn__5881 invoke "core.clj" 2746]
[clojure.core$map$fn__5880$fn__5881 invoke "core.clj" 2746]
[clojure.core$filter$fn__5907$fn__5908 invoke "core.clj" 2810]
[clojure.java.jdbc$init_reduce_rs invokeStatic "jdbc.clj" 1205]
[clojure.java.jdbc$init_reduce_rs invoke "jdbc.clj" 1197]
[clojure.java.jdbc$reducible_result_set_STAR_$reify__20707 reduce "jdbc.clj" 1227]
[clojure.core$reduce invokeStatic "core.clj" 6829]
[clojure.core$reduce invoke "core.clj" 6812]
[clojure.java.jdbc$query_reducer$fn__20713$fn__20716 invoke "jdbc.clj" 1262]
[clojure.java.jdbc$execute_query_with_params invokeStatic "jdbc.clj" 1091]
[clojure.java.jdbc$execute_query_with_params invoke "jdbc.clj" 1084]
[clojure.java.jdbc$db_query_with_resultset_STAR_ invokeStatic "jdbc.clj" 1113]
[clojure.java.jdbc$db_query_with_resultset_STAR_ invoke "jdbc.clj" 1093]
[clojure.java.jdbc$reducible_query$reify__20730 reduce "jdbc.clj" 1357]
[clojure.core$transduce invokeStatic "core.clj" 6885]
[clojure.core$transduce invokeStatic "core.clj" 6881]
[clojure.core$transduce invoke "core.clj" 6872]
[metabase.search.scoring$top_results invokeStatic "scoring.clj" 297]
[metabase.search.scoring$top_results invoke "scoring.clj" 291]
[metabase.api.search$fn__78415$search__78420$fn__78421 invoke "search.clj" 409]
[metabase.api.search$fn__78415$search__78420 invoke "search.clj" 392]
[metabase.api.search$fn__78483 invokeStatic "search.clj" 466]
[metabase.api.search$fn__78483 invoke "search.clj" 450]
[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 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]
[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]
[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" 59]
[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__34079 invoke "misc.clj" 59]
[metabase.server.middleware.session$bind_current_user$fn__44984$fn__44985 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__44984 invoke "session.clj" 256]
[metabase.server.middleware.session$wrap_current_user_info$fn__44971 invoke "session.clj" 216]
[metabase.server.middleware.session$wrap_session_id$fn__44957 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__34062 invoke "misc.clj" 27]
[metabase.server.middleware.misc$disable_streaming_buffering$fn__34087 invoke "misc.clj" 76]
[ring.middleware.gzip$wrap_gzip$fn__83889 invoke "gzip.clj" 86]
[metabase.server.middleware.misc$bind_request$fn__34090 invoke "misc.clj" 93]
[metabase.server.middleware.ssl$redirect_to_https_middleware$fn__83676 invoke "ssl.clj" 48]
[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 "Thread.java" 748]],
:cause
"Output of update-field-options does not match schema: \n\n\t e[0;33m [nil nil (named (not (\"Invalid :temporal-unit for the specified :base-type.\" a-clojure.lang.PersistentArrayMap)) \"options\")] e[0m \n\n",
:data
{:type :schema.core/error,
:schema
(constrained
[(one (eq :field) :field)
(one (cond-pre (constrained Int "positive integer") (constrained Str "Non-blank string")) "id-or-name")
(one (maybe (recursive #'metabase.mbql.schema/FieldOptions)) "options")]
":field clauses using a string field name must specify :base-type."),
:value [:field "invoice_date" {:base-type :type/Date, :temporal-unit :minute}],
:error
[nil
nil
(named (not ("Invalid :temporal-unit for the specified :base-type." a-clojure.lang.PersistentArrayMap)) "options")]},
:message "Error normalizing query",
:query
{"database" -1337,
"type" "query",
"query"
{"source-table" "card__2805",
"filter"
["and"
["between"
["datetime-field" ["field-literal" "invoice_date" "type/Date"] "minute"]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]
["between"
["datetime-field" ["field-literal" "customer_created" "type/DateTime"] "minute"]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]],
"aggregation"
[["sum" ["field-literal" "revenue" "type/Decimal"]]
["distinct" ["field-literal" "customer" "type/Text"]]
["count"]]}}}
e[0m
2023-02-06 11:57:43,304 [qtp969570398-20] ERRORmetabase.mbql.normalize - Invalid clause: [:and [:between [:datetime-field [:field-literal invoice_date :type/Date] :minute] 2020-10-01T00:01:00 2020-10-31T23:59:00] [:between [:datetime-field [:field-literal customer_created :type/DateTime] :minute] 2020-10-01T00:01:00 2020-10-31T23:59:00]]
2023-02-06 11:57:43,739 [qtp969570398-20] ERRORmetabase.server.middleware.log - e[31mGET /api/search 500 609.7 ms (3 DB calls)
{:via
[{:type clojure.lang.ExceptionInfo,
:message "Error normalizing query",
:data
{:query
{"database" -1337,
"type" "query",
"query"
{"source-table" "card__2805",
"filter"
["and"
["between"
["datetime-field" ["field-literal" "invoice_date" "type/Date"] "minute"]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]
["between"
["datetime-field" ["field-literal" "customer_created" "type/DateTime"] "minute"]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]],
"aggregation"
[["sum" ["field-literal" "revenue" "type/Decimal"]]
["distinct" ["field-literal" "customer" "type/Text"]]
["count"]]}}},
:at [metabase.mbql.normalize$fn__27387$fn__27388 invoke "normalize.cljc" 797]}
{:type clojure.lang.ExceptionInfo,
:message "Error canonicalizing query",
:data
{:query
{:source-table "card__2805",
:filter
[:and
[:between
[:datetime-field [:field-literal "invoice_date" :type/Date] :minute]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]
[:between
[:datetime-field [:field-literal "customer_created" :type/DateTime] :minute]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]],
:aggregation
[[:sum [:field-literal "revenue" :type/Decimal]] [:distinct [:field-literal "customer" :type/Text]] [:count]]}},
:at [metabase.mbql.normalize$canonicalize invokeStatic "normalize.cljc" 678]}
{:type clojure.lang.ExceptionInfo,
:message "Invalid MBQL clause",
:data
{:clause
[:and
[:between
[:datetime-field [:field-literal "invoice_date" :type/Date] :minute]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]
[:between
[:datetime-field [:field-literal "customer_created" :type/DateTime] :minute]
"2020-10-01T00:01:00"
"2020-10-31T23:59:00"]]},
:at [metabase.mbql.normalize$canonicalize_mbql_clauses$fn__27232 invoke "normalize.cljc" 556]}
{:type clojure.lang.ExceptionInfo,
:message
"Output of update-field-options does not match schema: \n\n\t e[0;33m [nil nil (named (not (\"Invalid :temporal-unit for the specified :base-type.\" a-clojure.lang.PersistentArrayMap)) \"options\")] e[0m \n\n",
:data
{:type :schema.core/error,
:schema
(constrained
[(one (eq :field) :field)
(one (cond-pre (constrained Int "positive integer") (constrained Str "Non-blank string")) "id-or-name")
(one (maybe (recursive #'metabase.mbql.schema/FieldOptions)) "options")]
":field clauses using a string field name must specify :base-type."),
:value [:field "invoice_date" {:base-type :type/Date, :temporal-unit :minute}],
:error
[nil
nil
(named (not ("Invalid :temporal-unit for the specified :base-type." a-clojure.lang.PersistentArrayMap)) "options")]},
:at [metabase.mbql.util$fn__26790$update_field_options__26795 doInvoke "util.cljc" 587]}],
:trace