Bug #27600
closed
UndefinedTable error when generating "Applied Errata" report
Description
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
Updated by Marek Hulán over 4 years 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.
Updated by Robert Cooper over 4 years ago
Installed plugins:
foreman-tasks 0.15.7
foreman_docker 5.0.0
katello 3.12.2
I installed the foreman_remote_execution 1.8.2 plugin from the foreman-plugins repo. That seems to have fixed the error message, but the report now generated is blank.
Updated by Samir Jha over 4 years ago
Hey Robert,
Can you make sure if you have applicable errata in the system?
Updated by James Jeffers over 4 years ago
Have you applied errata via remote execution or katello agent prior to running this report?
Updated by Ian Ballou over 4 years ago
- Status changed from New to Need more information
Updated by John Mitsch over 4 years 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.