Problem with Bulk generate applicability

Support
1

Problem:
After migration to new OS RHEL9 from backup DB from RHEL8 i have a problem with refresh errata information.
Task : [Bulk generate applicability for ] report Warning :

PG::UndefinedColumn: ERROR: column katello_rpms.evr does not exist
LINE 5: katello_rpms.evr > katello_installed_packages.ev…

Expected outcome:
No error after execute this task.
Foreman and Proxy versions:
3.12.1
Foreman and Proxy plugin versions:
3.12.1
Katello: 4.14.1
Distribution and version:
RockyLinux 9.5
Other relevant data:

1 Like
2

Try running foreman-installer (which you need to do after each upgrade.) It seems like the migration to remove the EVR-related things may not have run.

1 Like
3

Also, just to make sure, the DB backup (on the EL9 box) was restored on the same version of Katello that it was taken from (on the EL8 box)?

This only applies to Katello 4.16, so I wonder if for some reason the postgresql-evr RPM is not installed. If not, on versions of Katello before 4.16, any EVR-related column would fail to be added.
Did any past installer run fail?