Unable to select saved questions in query editor

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"
    }
  }
}

image

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...

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?

The error I saw it was a question that needed to be hidden, not a collection

How do you know which question is corrupted?

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

Specifically:

  1. Add the metabase application DB to metabase
  2. Go to report_card table
  3. Filter by column dataset_query - filter (contains) "card__2"
  4. 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.

image

@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.