Project

General

Profile

Bug #27600

UndefinedTable error when generating "Applied Errata" report

Added by Robert Cooper 2 months ago. Updated about 1 month ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Difficulty:
Triaged:
Yes
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:

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

History

#1 Updated by Marek Hulán about 2 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.

#2 Updated by Robert Cooper about 2 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 about 2 months ago

Hey Robert,

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

#4 Updated by James Jeffers about 2 months ago

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

#5 Updated by Ian Ballou about 1 month ago

  • Status changed from New to Need more information

#6 Updated by John Mitsch about 1 month 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 about 1 month ago

  • Triaged changed from No to Yes

Also available in: Atom PDF