Bug #27600

UndefinedTable error when generating "Applied Errata" report

Added by Robert Cooper 7 months ago. Updated 6 months ago.

Target version:
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:


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 = template_invocations.run_host_job_task_id LEFT OUTER JOIN templates ON template_invocations.template_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 or we should require REX plugin for this template

Moving to Katello, the first option is probably better.

#2 Updated by Robert Cooper 6 months 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.

#3 Updated by Samir Jha 6 months ago

Hey Robert,

Can you make sure if you have applicable errata in the system?

#4 Updated by James Jeffers 6 months ago

Have you applied errata via remote execution or katello agent prior to running this report?

#5 Updated by Ian Ballou 6 months ago

  • Status changed from New to Need more information

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

#7 Updated by John Mitsch 6 months ago

  • Triaged changed from No to Yes

Also available in: Atom PDF