Problem with joining data to a Saved Question. HTTP 500: Not something with an ID: 2

Metabase v0.37.2

Chrome 86.0.4240.198 (official build)(64-bit)
Windows 10 Build 19041.630
AWS Redshift

I am trying to create a question using the Editor.
I selected a table from my database.
Click Join Data.
In the popup that Shows the list of tables, I clicked on “Saved Questions” as I want to join with the resultset of a Saved Question.
The list of Saved Question won’t load due to an error in the call to
https://metabase.waypath.io/api/database/{id}/schemas

Got HTTP 500 Response:

{“via”:[{“type”:“java.lang.Exception”,“message”:“Not something with an ID: 2”,“at”:[“metabase.util$get_id”,“invokeStatic”,“util.clj”,503]}],“trace”:[[“metabase.util$get_id”,“invokeStatic”,“util.clj”,503],[“metabase.util$get_id”,“invoke”,“util.clj”,494],[“metabase.driver.util$database__GT_driver_STAR_”,“invokeStatic”,“util.clj”,64],[“metabase.driver.util$database__GT_driver_STAR_”,“invoke”,“util.clj”,61],[“clojure.lang.AFn”,“applyToHelper”,“AFn.java”,154],[“clojure.lang.AFn”,“applyTo”,“AFn.java”,144],[“clojure.core$apply”,“invokeStatic”,“core.clj”,665],[“clojure.core$apply”,“invoke”,“core.clj”,660],[“clojure.core.memoize$through_STAR_$fn__11231”,“invoke”,“memoize.clj”,107],[“clojure.core.cache$through$fn__10954”,“invoke”,“cache.clj”,55],[“clojure.core.memoize$through_STAR_$fn__11227$fn__11228”,“invoke”,“memoize.clj”,106],[“clojure.core.memoize.RetryingDelay”,“deref”,“memoize.clj”,47],[“clojure.core$deref”,“invokeStatic”,“core.clj”,2320],[“clojure.core$deref”,“invoke”,“core.clj”,2306],[“clojure.core.memoize$cached_function$fn__11295”,“doInvoke”,“memoize.clj”,231],[“clojure.lang.RestFn”,“applyTo”,“RestFn.java”,137],[“clojure.lang.AFunction$1”,“doInvoke”,“AFunction.java”,31],[“clojure.lang.RestFn”,“invoke”,“RestFn.java”,408],[“metabase.api.database$card_database_supports_nested_queries_QMARK_”,“invokeStatic”,“database.clj”,83],[“metabase.api.database$card_database_supports_nested_queries_QMARK_”,“invoke”,“database.clj”,81],[“metabase.api.database$card_can_be_used_as_source_query_QMARK_”,“invokeStatic”,“database.clj”,116],[“metabase.api.database$card_can_be_used_as_source_query_QMARK_”,“invoke”,“database.clj”,113],[“clojure.core$filter$fn__5889$fn__5890”,“invoke”,“core.clj”,2805],[“clojure.core$completing$fn__8440”,“invoke”,“core.clj”,6868],[“clojure.core$map$fn__5862$fn__5863”,“invoke”,“core.clj”,2742],[“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__19206”,“reduce”,“jdbc.clj”,1227],[“clojure.core$reduce”,“invokeStatic”,“core.clj”,6827],[“clojure.core$reduce”,“invoke”,“core.clj”,6810],[“clojure.java.jdbc$query_reducer$fn__19212$fn__19215”,“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__19229”,“reduce”,“jdbc.clj”,1357],[“clojure.core$transduce”,“invokeStatic”,“core.clj”,6883],[“clojure.core.Eduction”,“reduce”,“core.clj”,7682],[“clojure.core$transduce”,“invokeStatic”,“core.clj”,6883],[“clojure.core$transduce”,“invoke”,“core.clj”,6870],[“metabase.api.database$source_query_cards”,“invokeStatic”,“database.clj”,132],[“metabase.api.database$source_query_cards”,“doInvoke”,“database.clj”,128],[“clojure.lang.RestFn”,“invoke”,“RestFn.java”,397],[“metabase.api.database$cards_virtual_tables”,“invokeStatic”,“database.clj”,156],[“metabase.api.database$cards_virtual_tables”,“doInvoke”,“database.clj”,151],[“clojure.lang.RestFn”,“invoke”,“RestFn.java”,397],[“metabase.api.database$fn__60379”,“invokeStatic”,“database.clj”,700],[“metabase.api.database$fn__60379”,“invoke”,“database.clj”,695],[“compojure.core$wrap_response$fn__1993”,“invoke”,“core.clj”,160],[“compojure.core$wrap_route_middleware$fn__1977”,“invoke”,“core.clj”,132],[“compojure.core$wrap_route_info$fn__1982”,“invoke”,“core.clj”,139],[“compojure.core$wrap_route_matches$fn__1986”,“invoke”,“core.clj”,151],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$wrap_route_matches$fn__1986”,“invoke”,“core.clj”,153],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$wrap_route_matches$fn__1986”,“invoke”,“core.clj”,153],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$wrap_route_matches$fn__1986”,“invoke”,“core.clj”,153],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$wrap_route_matches$fn__1986”,“invoke”,“core.clj”,153],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$wrap_route_matches$fn__1986”,“invoke”,“core.clj”,153],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005”,“invoke”,“core.clj”,200],[“metabase.middleware.auth$enforce_authentication$fn__72906”,“invoke”,“auth.clj”,14],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005”,“invoke”,“core.clj”,200],[“compojure.core$make_context$handler__2033”,“invoke”,“core.clj”,287],[“compojure.core$make_context$fn__2035”,“invoke”,“core.clj”,296],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$make_context$fn__2035”,“invoke”,“core.clj”,297],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$make_context$fn__2035”,“invoke”,“core.clj”,297],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$make_context$fn__2035”,“invoke”,“core.clj”,297],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$make_context$fn__2035”,“invoke”,“core.clj”,297],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$make_context$fn__2035”,“invoke”,“core.clj”,297],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$make_context$fn__2035”,“invoke”,“core.clj”,297],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“metabase.api.routes$fn__73027$fn__73029”,“invoke”,“routes.clj”,73],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005”,“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__74355$fn__74356”,“doInvoke”,“routes.clj”,60],[“clojure.lang.RestFn”,“invoke”,“RestFn.java”,436],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005”,“invoke”,“core.clj”,200],[“compojure.core$make_context$handler__2033”,“invoke”,“core.clj”,287],[“compojure.core$make_context$fn__2035”,“invoke”,“core.clj”,296],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$wrap_route_matches$fn__1986”,“invoke”,“core.clj”,152],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$wrap_route_matches$fn__1986”,“invoke”,“core.clj”,152],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“compojure.core$wrap_route_matches$fn__1986”,“invoke”,“core.clj”,152],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007”,“invoke”,“core.clj”,197],[“metabase.routes$fn__74343$fn__74345”,“invoke”,“routes.clj”,44],[“compojure.core$routes$fn__2005$f__2006”,“invoke”,“core.clj”,198],[“compojure.core$routes$fn__2005”,“invoke”,“core.clj”,200],[“metabase.middleware.exceptions$catch_uncaught_exceptions$fn__73018”,“invoke”,“exceptions.clj”,96],[“metabase.middleware.exceptions$catch_api_exceptions$fn__73015”,“invoke”,“exceptions.clj”,84],[“metabase.middleware.log$log_api_call$fn__74803$fn__74804”,“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__74803”,“invoke”,“log.clj”,191],[“metabase.middleware.security$add_security_headers$fn__72981”,“invoke”,“security.clj”,143],[“metabase.middleware.json$wrap_json_body$fn__74506”,“invoke”,“json.clj”,64],[“metabase.middleware.json$wrap_streamed_json_response$fn__74524”,“invoke”,“json.clj”,100],[“ring.middleware.keyword_params$wrap_keyword_params$fn__75069”,“invoke”,“keyword_params.clj”,55],[“ring.middleware.params$wrap_params$fn__75085”,“invoke”,“params.clj”,69],[“metabase.middleware.misc$maybe_set_site_url$fn__37893”,“invoke”,“misc.clj”,59],[“metabase.middleware.session$bind_current_user$fn__69460$fn__69461”,“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__69460”,“invoke”,“session.clj”,277],[“metabase.middleware.session$wrap_current_user_info$fn__69447”,“invoke”,“session.clj”,238],[“metabase.middleware.session$wrap_session_id$fn__69433”,“invoke”,“session.clj”,184],[“metabase.middleware.auth$wrap_api_key$fn__72914”,“invoke”,“auth.clj”,27],[“ring.middleware.cookies$wrap_cookies$fn__74989”,“invoke”,“cookies.clj”,216],[“metabase.middleware.misc$add_content_type$fn__37878”,“invoke”,“misc.clj”,28],[“metabase.middleware.misc$disable_streaming_buffering$fn__37901”,“invoke”,“misc.clj”,76],[“ring.middleware.gzip$wrap_gzip$fn__75031”,“invoke”,“gzip.clj”,86],[“metabase.middleware.misc$bind_request$fn__37904”,“invoke”,“misc.clj”,93],[“metabase.middleware.ssl$redirect_to_https_middleware$fn__74820”,“invoke”,“ssl.clj”,49],[“metabase.server$async_proxy_handler$fn__74581”,“invoke”,“server.clj”,72],[“metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a”,“handle”,null,-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”,null,-1]],“cause”:“Not something with an ID: 2”,“message”:“Not something with an ID: 2”,“type”:“class java.lang.Exception”}

Hi @MichaelL
Please post “Diagnostic Info” from Admin > Troubleshooting.
I have only seen this error once before - Unable to pick a saved query, no query is shown in the list - and it was caused by the question being selected was actually already archived.

{
“browser-info”: {
“language”: “en-GB”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.7+10”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.7”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.7+10”,
“os.name”: “Linux”,
“os.version”: “4.14.200-155.322.amzn2.x86_64”,
“user.language”: “en”,
“user.timezone”: “GMT”
},
“metabase-info”: {
“databases”: [
“redshift”
],
“hosting-env”: “elastic-beanstalk”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “12.3”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.8”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2020-11-16”,
“tag”: “v0.37.2”,
“branch”: “release-x.37.x”,
“hash”: “25e5f70”
},
“settings”: {
“report-timezone”: “Australia/Sydney”
}
}
}