Cannot show value list in dashboard Filter

Our dashboard filter cannot show the value list but it can be shown in question in version 37.7

It displays the search box only but it can work on the question. I found below error in the log. Please help to solve.

[a06ba81d-4499-41d1-9b9b-04b7894c6115] 2021-03-08T13:54:14+08:00 ERROR metabase.middleware.log GET /api/dashboard/124/params/3f22a2f6/values 500 594.3 ms (54 DB calls)
{:via
[{:type java.lang.ClassCastException, :message “java.lang.Integer cannot be cast to clojure.lang.IPersistentVector”, :at [clojure.lang.APersistentVector compareTo “APersistentVector.java” 432]}],
:trace
[[clojure.lang.APersistentVector compareTo “APersistentVector.java” 432]
[clojure.lang.Util compare “Util.java” 153]
[clojure.core$compare invokeStatic “core.clj” 840]
[clojure.core$compare invoke “core.clj” 831]
[clojure.lang.AFunction compare “AFunction.java” 51]
[java.util.TimSort countRunAndMakeAscending “TimSort.java” 360]
[java.util.TimSort sort “TimSort.java” 220]
[java.util.Arrays sort “Arrays.java” 1438]
[clojure.core$sort invokeStatic “core.clj” 3115]
[clojure.core$sort invokeStatic “core.clj” 3102]
[clojure.core$sort invoke “core.clj” 3102]
[metabase.api.dashboard$fn__66920$chain_filter__66929$fn__66932 invoke “dashboard.clj” 581]
[metabase.api.dashboard$fn__66920$chain_filter__66929 invoke “dashboard.clj” 545]
[metabase.api.dashboard$fn__66920$chain_filter__66929$fn__66930 invoke “dashboard.clj” 556]
[metabase.api.dashboard$fn__66920$chain_filter__66929 invoke “dashboard.clj” 545]
[metabase.api.dashboard$fn__66955 invokeStatic “dashboard.clj” 595]
[metabase.api.dashboard$fn__66955 invoke “dashboard.clj” 587]
[compojure.core$wrap_response$fn__22442 invoke “core.clj” 160]
[compojure.core$wrap_route_middleware$fn__22426 invoke “core.clj” 132]
[compojure.core$wrap_route_info$fn__22431 invoke “core.clj” 139]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 151]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 152]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 153]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 153]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 153]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 152]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 153]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 152]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 152]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 153]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 153]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 153]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 153]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454 invoke “core.clj” 200]
[metabase.middleware.auth$enforce_authentication$fn__52946 invoke “auth.clj” 14]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454 invoke “core.clj” 200]
[compojure.core$make_context$handler__22482 invoke “core.clj” 287]
[compojure.core$make_context$fn__22484 invoke “core.clj” 296]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$make_context$fn__22484 invoke “core.clj” 297]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$make_context$fn__22484 invoke “core.clj” 297]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$make_context$fn__22484 invoke “core.clj” 297]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$make_context$fn__22484 invoke “core.clj” 297]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$make_context$fn__22484 invoke “core.clj” 297]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 199]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$make_context$fn__22484 invoke “core.clj” 297]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$make_context$fn__22484 invoke “core.clj” 297]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454 invoke “core.clj” 200]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454 invoke “core.clj” 200]
[clojure.lang.AFn applyToHelper “AFn.java” 160]
[clojure.lang.AFn applyTo “AFn.java” 144]
[clojure.core$apply invokeStatic “core.clj” 665]
[clojure.core$apply invoke “core.clj” 660]
[metabase.routes$fn__78732$fn__78733 doInvoke “routes.clj” 60]
[clojure.lang.RestFn invoke “RestFn.java” 436]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454 invoke “core.clj” 200]
[compojure.core$make_context$handler__22482 invoke “core.clj” 287]
[compojure.core$make_context$fn__22484 invoke “core.clj” 296]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 152]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 152]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__22435 invoke “core.clj” 152]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 199]
[compojure.core$routes$fn__22454$f__22455$respond_SINGLEQUOTE___22456 invoke “core.clj” 197]
[compojure.core$make_context$fn__22484 invoke “core.clj” 297]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454 invoke “core.clj” 200]
[compojure.core$routes$fn__22454$f__22455 invoke “core.clj” 198]
[compojure.core$routes$fn__22454 invoke “core.clj” 200]
[metabase.middleware.exceptions$catch_uncaught_exceptions$fn__77394 invoke “exceptions.clj” 96]
[metabase.middleware.exceptions$catch_api_exceptions$fn__77391 invoke “exceptions.clj” 84]
[metabase.middleware.log$log_api_call$fn__79180$fn__79181 invoke “log.clj” 197]
[toucan.db$_do_with_call_counting invokeStatic “db.clj” 216]
[toucan.db$_do_with_call_counting invoke “db.clj” 209]
[metabase.middleware.log$log_api_call$fn__79180 invoke “log.clj” 191]
[metabase.middleware.security$add_security_headers$fn__77357 invoke “security.clj” 143]
[metabase.middleware.json$wrap_json_body$fn__78883 invoke “json.clj” 64]
[metabase.middleware.json$wrap_streamed_json_response$fn__78901 invoke “json.clj” 100]
[ring.middleware.keyword_params$wrap_keyword_params$fn__79446 invoke “keyword_params.clj” 55]
[ring.middleware.params$wrap_params$fn__79462 invoke “params.clj” 69]
[metabase.middleware.misc$maybe_set_site_url$fn__34992 invoke “misc.clj” 59]
[metabase.middleware.session$bind_current_user$fn__59625$fn__59626 invoke “session.clj” 278]
[metabase.middleware.session$do_with_current_user invokeStatic “session.clj” 260]
[metabase.middleware.session$do_with_current_user invoke “session.clj” 252]
[metabase.middleware.session$bind_current_user$fn__59625 invoke “session.clj” 277]
[metabase.middleware.session$wrap_current_user_info$fn__59612 invoke “session.clj” 238]
[metabase.middleware.session$wrap_session_id$fn__59598 invoke “session.clj” 184]
[metabase.middleware.auth$wrap_api_key$fn__52954 invoke “auth.clj” 27]
[ring.middleware.cookies$wrap_cookies$fn__79366 invoke “cookies.clj” 216]
[metabase.middleware.misc$add_content_type$fn__34977 invoke “misc.clj” 28]
[metabase.middleware.misc$disable_streaming_buffering$fn__35000 invoke “misc.clj” 76]
[ring.middleware.gzip$wrap_gzip$fn__79408 invoke “gzip.clj” 86]
[metabase.middleware.misc$bind_request$fn__35003 invoke “misc.clj” 93]
[metabase.middleware.ssl$redirect_to_https_middleware$fn__79197 invoke “ssl.clj” 49]
[metabase.server$async_proxy_handler$fn__78958 invoke “server.clj” 72]
[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” 383]
[org.eclipse.jetty.server.HttpChannel dispatch “HttpChannel.java” 556]
[org.eclipse.jetty.server.HttpChannel handle “HttpChannel.java” 375]
[org.eclipse.jetty.server.HttpConnection onFillable “HttpConnection.java” 273]
[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” 336]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill doProduce “EatWhatYouKill.java” 313]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill tryProduce “EatWhatYouKill.java” 171]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill run “EatWhatYouKill.java” 129]
[org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread run “ReservedThreadExecutor.java” 375]
[org.eclipse.jetty.util.thread.QueuedThreadPool runJob “QueuedThreadPool.java” 773]
[org.eclipse.jetty.util.thread.QueuedThreadPool$Runner run “QueuedThreadPool.java” 905]
[java.lang.Thread run “Thread.java” 748]],
:cause “java.lang.Integer cannot be cast to clojure.lang.IPersistentVector”,
:message “java.lang.Integer cannot be cast to clojure.lang.IPersistentVector”,
:type java.lang.ClassCastException}

Hi @hilaryfu
Post “Diagnostic Info” from Admin > Troubleshooting.
And what is database column type of the field you’re trying to filter?

I have solved the problem by recreation of database tables and discard all current value since the dashboard is setup by multiple tables. It may caused there are some garbage in the meta data.