UndefinedTable error when generating "Applied Errata" report
I'm running an instance of Foreman 1.22, upgraded via yum from to 1.20 then 1.21. When trying to generate the new report "Applied Errata", I get the following error message:
PG::UndefinedTable: ERROR: relation "template_invocations" does not exist LINE 1: ..."."id" FROM "foreman_tasks_tasks" LEFT OUTER JOIN template_i... ^ : SELECT "foreman_tasks_tasks"."id" FROM "foreman_tasks_tasks" LEFT OUTER JOIN template_invocations ON foreman_tasks_tasks.id = template_invocations.run_host_job_task_id LEFT OUTER JOIN templates ON template_invocations.template_id = templates.id WHERE (state != 'stoppped' AND label = 'Actions::Katello::Host::Erratum::Install') ORDER BY "foreman_tasks_tasks"."id" ASC LIMIT $1
#1 Updated by Marek Hulán 6 months ago
- Project changed from Foreman to Katello
Could you also please list of your plugin versions? IIRC, this could happen if you don't have remote execution plugin installed. Probably this would need to be changed to not rely on template_invocations in case REX is missing https://github.com/Katello/katello/pull/8020/files#diff-0205d45df3cff4d704595cc677d03b10R58-R60 or we should require REX plugin for this template https://github.com/theforeman/community-templates/blob/develop/report_templates/applied_errata.erb#L44-L46
Moving to Katello, the first option is probably better.
#6 Updated by John Mitsch 6 months ago
- Status changed from Need more information to Rejected
Thanks for filing this issue. It sounds like the original error has been worked out. If you are seeing a blank report and you know you have applicable errata on the system, please open up a new issue and add any relevant information there and we can address that issue.