When I try to select a saved question in the query editor, it won't show the saved questions.
Diagnostic Info:
{
"browser-info": {
"language": "en-AU",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.0 Safari/605.1.15",
"vendor": "Apple Computer, Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.11+9",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.11+9",
"os.name": "Linux",
"os.version": "4.14.232-177.418.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"redshift",
"postgres"
],
"hosting-env": "elastic-beanstalk",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.6"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"date": "2021-04-27",
"tag": "v0.39.1",
"branch": "release-x.39.x",
"hash": "6beba48"
},
"settings": {
"report-timezone": "Australia/Sydney"
}
}
}
Luiggi
July 20, 2021, 2:28am
2
Last time I saw this issue was because a saved question was corrupt, can you search for the question with the ID 2 and archive it?
Thanks Luiggi
Ive archived question 2 but it is still throwing an error...
Luiggi
July 20, 2021, 5:33pm
4
OK so it isn't that card. Try searching through the questions one by one till you get to the corrupted one
Ok. So its definitely a question? Not a collection?
Luiggi
July 20, 2021, 11:56pm
6
The error I saw it was a question that needed to be hidden, not a collection
How do you know which question is corrupted?
Luiggi
July 21, 2021, 1:41pm
8
You will have to go one by one archiving those to see which one is the one that got corrupted
Hmm ok. that doesn't seem like the most efficient way, we have over 300 questions.... And many on the team are using the questions.
Is there any other way we can check a log or something to find the culprit?
@jins-agridigital If you search the forum or Github of "Not something with an ID", then you'll find a couple of posts, but no one has provided the corrupted question, so we currently don't know how to trigger the problem.
It would be great to actually get the information on the root cause, so we can fix this problem (or at least prevent it in the future).
For reference: https://github.com/metabase/metabase/issues/15834
Thanks @flamber
Ive resolved the issue from my end by following: Cannot include saved questions as starting data in custom question - #12 by aris_pg
Specifically:
Add the metabase application DB to metabase
Go to report_card table
Filter by column dataset_query - filter (contains) "card__2"
I then went to the question URL and archived the question and also then deleted it from the archive.
I still don't know the exact reason for the cause. But that has at least solved it.
@jins-agridigital And since you have deleted the question, then we will never know how to reproduce the problem or how the question came into that state.