Bug 475560

Summary: number of critical patches listed in sdc is not correct
Product: [Community] Spacewalk Reporter: wes hayutin <whayutin>
Component: WebUIAssignee: Jesus M. Rodriguez <jesusr>
Status: CLOSED CURRENTRELEASE QA Contact: wes hayutin <whayutin>
Severity: medium Docs Contact:
Priority: low    
Version: 0.4   
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
URL: https://dhcp231-158.rdu.redhat.com/rhn/systems/details/Overview.do?sid=1000010294
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-01-22 16:31:12 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 456552    
Attachments:
Description Flags
ss of the # of errata
none
ss of the # of errata in sdc
none
ss of the # of errata in list of errata none

Description wes hayutin 2008-12-09 17:03:15 UTC 
Description of problem:

register a system to spacewalk
go to the system overview.. note the number of errata and packages that need updating
Comment 1 wes hayutin 2008-12-09 17:03:41 UTC 
Created attachment 326359 [details]
ss of the # of errata
Comment 2 wes hayutin 2008-12-09 17:04:52 UTC 
now click into the system and view the sdc..

notice the number of packages listed as critical..  it has changed from "1" to "3"
Comment 3 wes hayutin 2008-12-09 17:05:24 UTC 
Created attachment 326361 [details]
ss of the # of errata in sdc
Comment 4 wes hayutin 2008-12-09 17:05:57 UTC 
now click on the link "critical" in the sdc and only one package is listed..
Comment 5 wes hayutin 2008-12-09 17:06:29 UTC 
Created attachment 326363 [details]
ss of the # of errata in list of errata
Comment 6 Jesus M. Rodriguez 2008-12-15 16:56:47 UTC 
system list page uses value from rhnserveroverview:

for example on my test system which shows 275 errata, the following query
is used to determine that:

select security_errata, bug_errata, enhancement_errata from rhnserveroverview where server_id = 1000098324;

SECURITY_ERRATA BUG_ERRATA ENHANCEMENT_ERRATA
--------------- ---------- ------------------
	     70        174		   31

Next to find where it gets the numbers for the Server Details page.
Comment 7 Jesus M. Rodriguez 2008-12-15 18:36:17 UTC 
added a distinct to the count_critical_errata_for_system and count_noncritical_errata_for_system datasource queries in Errata_queries.xml.

http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=02fe97e74ce9d33feab334dc97855a0cd83dd017
Comment 8 Jesus M. Rodriguez 2009-01-15 03:13:51 UTC 
Both Critical and Non-Critical link to the same page. So the total seen on the result ErrataList page is the sum of the two on the previous page.

The packages link page shows the same number as seen on the sdc.