"Error normalizing query" when I click View Archive

Nothing shows up on the page except this " Error normalizing query".

Maybe it's a pure postgresql issue and I should start there?

Thanks.

Hi @GeneW
You have a question with a corruption. There's no easy way to debug that.
https://github.com/metabase/metabase/issues/15222
Probably easiest simply to delete all questions that are archived directly in the application database table report_card.archive=true

Thank you very much!

Thanks @flamber.
It's OK to delete the whole (row) record in report_card? Don't need to change any other table?

@GeneW Make sure you have backups, but yes, the problem is in the metadata of the specific question (report_card).

@flamber Thanks very much, that did fix the problem. Seems a very old (2018) query was the offending item, for what that is worth.