Bug 1720574

Summary: [Sat 6.5] Satellite GUI & reporting tool reports much less Installable Erratas than "yum updateinfo" on the client
Product: Red Hat Satellite Reporter: Victor Hernando <vhernand>
Component: Errata ManagementAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED DUPLICATE QA Contact: Perry Gagne <pgagne>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 6.5.0CC: pmoravec
Target Milestone: Unspecified   
Target Release: Unused   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2019-06-21 11:19:34 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Installable_Errata_Satellite_6_5_GUI none

Description Victor Hernando 2019-06-14 09:17:45 UTC
Created attachment 1580615 [details]
Installable_Errata_Satellite_6_5_GUI

Description of problem:
The Installable Errata figures shown on the Satellite GUI are very different from the figures reported on the client executing "yum updateinfo".

* Errata info from "yum updateinfo" on the client.
~~~
# yum updateinfo
Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager
rhel-7-server-extras-rpms                                                                                                                                   | 2.0 kB  00:00:00     
rhel-7-server-rpms                                                                                                                                          | 2.0 kB  00:00:00     
rhel-7-server-satellite-tools-6.5-rpms                                                                                                                      | 2.1 kB  00:00:00     
Updates Information Summary: updates
    15 Security notice(s)
        11 Important Security notice(s)
         3 Moderate Security notice(s)
         1 Low Security notice(s)
    37 Bugfix notice(s)
     2 Enhancement notice(s)
updateinfo summary done
Uploading Enabled Repositories Report
Loaded plugins: product-id, subscription-manager
~~~

* Errata info from Satellite GUI (see attachment)
Security: 4
Bug Fix: 8
Enhancement: 1

Version-Release number of selected component (if applicable):
6.5

How reproducible:


Steps to Reproduce:
- Subscribe a fresh RHEL 7.6 to your Satellite 6.5.
- Install katello-agent
- Check the column Installable Updates on Hosts -> Content Hosts
- Run the report Applicable errata from: Monitor -> Report Templates
- Run "yum updateinfo" in your RHEL 7.6 client
- Compare the results. (See attachment)

Actual results:
Satellite GUI and reporting tool is reporting a fewer number of Installable Erratas compared with the figures reported by "yum updateinfo"

Expected results:
The figures should be the same, checking the installable Errata from both sides.
In Satellite 6.4 is working properly.

Additional info:

Comment 5 Marek Hulan 2019-06-14 10:00:35 UTC
I'm moving to errata management component, since the template simply use host_applicable_errata_filtered macro. Based on the report, it's not clear if the report template and GUI shows different number or they are the same. But the report uses the same logic, so it's probably something in the errata calculation itself.

Comment 6 Victor Hernando 2019-06-14 10:05:02 UTC
Hi Marek,

Report template and GUI shows the same and incorrect number (see below), or at least figures that don't match with what is reported from the client with "yum updateinfo".

* Errata info from Satellite GUI and Report template (see attachment)
Security: 4
Bug Fix: 8
Enhancement: 1

Regards

Comment 7 Victor Hernando 2019-06-17 08:08:49 UTC
Hi Team,

Do we have any update on this?

Regards

Comment 8 Pavel Moravec 2019-06-17 12:05:26 UTC
I can not reproduce it based on steps in #c0 - newly installed rhel76 shows:

# yum updateinfo
Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager
rhel-7-server-rpms                                                                                                                                                     | 2.0 kB  00:00:00     
rhel-7-server-satellite-tools-6.5-rpms                                                                                                                                 | 2.1 kB  00:00:00     
Updates Information Summary: updates
    15 Security notice(s)
        11 Important Security notice(s)
         3 Moderate Security notice(s)
         1 Low Security notice(s)
    44 Bugfix notice(s)
     3 Enhancement notice(s)
updateinfo summary done
#

and webui provides same counts.

Can't be either of below BZs applicable?
1700406 - Changing CV or LE of a Content Hosts does not update applicable errata
1699786 - Installable Errata not recalculated after CV publish/promote

Does

foreman-rake katello:import_applicability

help you as a workaround? (I will ask the customer via case)

Comment 9 Victor Hernando 2019-06-17 13:58:48 UTC
(In reply to Pavel Moravec from comment #8)
> I can not reproduce it based on steps in #c0 - newly installed rhel76 shows:
> 
> # yum updateinfo
> Loaded plugins: enabled_repos_upload, package_upload, product-id,
> search-disabled-repos, subscription-manager
> rhel-7-server-rpms                                                          
> | 2.0 kB  00:00:00     
> rhel-7-server-satellite-tools-6.5-rpms                                      
> | 2.1 kB  00:00:00     
> Updates Information Summary: updates
>     15 Security notice(s)
>         11 Important Security notice(s)
>          3 Moderate Security notice(s)
>          1 Low Security notice(s)
>     44 Bugfix notice(s)
>      3 Enhancement notice(s)
> updateinfo summary done
> #
> 
> and webui provides same counts.
> 
> Can't be either of below BZs applicable?
> 1700406 - Changing CV or LE of a Content Hosts does not update applicable
> errata
> 1699786 - Installable Errata not recalculated after CV publish/promote
> 
> Does
> 
> foreman-rake katello:import_applicability
> 
> help you as a workaround? (I will ask the customer via case)

Hi Pavel

No changes after applying the procedure suggested by Ameya via case, neither applying the "foreman-rake katello:import_applicability". In my case, even after dropping the extra repo from the CV the same figures remains in the Satellite WebUI.

The customer just updated the case to let us know that no changes on their side neither, he attached some screenshots just in case those would be useful for us.

Regards

Comment 10 Victor Hernando 2019-06-21 11:18:55 UTC
Hi Team, 

Finally, the issue seems to be related to this BZ:

Bug 1713274 : https://bugzilla.redhat.com/show_bug.cgi?id=1713274

So closing this one.

Thanks for your support!

Comment 11 Victor Hernando 2019-06-21 11:19:34 UTC

*** This bug has been marked as a duplicate of bug 1713274 ***