Bug 475560 - number of critical patches listed in sdc is not correct
number of critical patches listed in sdc is not correct
Product: Spacewalk
Classification: Community
Component: WebUI (Show other bugs)
All Linux
low Severity medium
: ---
: ---
Assigned To: Jesus M. Rodriguez
wes hayutin
Depends On:
Blocks: space04
  Show dependency treegraph
Reported: 2008-12-09 12:03 EST by wes hayutin
Modified: 2009-01-22 11:31 EST (History)
0 users

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2009-01-22 11:31:12 EST
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)
ss of the # of errata (417.44 KB, image/png)
2008-12-09 12:03 EST, wes hayutin
no flags Details
ss of the # of errata in sdc (448.45 KB, image/png)
2008-12-09 12:05 EST, wes hayutin
no flags Details
ss of the # of errata in list of errata (462.63 KB, image/png)
2008-12-09 12:06 EST, wes hayutin
no flags Details

  None (edit)
Description wes hayutin 2008-12-09 12:03:15 EST
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 12:03:41 EST
Created attachment 326359 [details]
ss of the # of errata
Comment 2 wes hayutin 2008-12-09 12:04:52 EST
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 12:05:24 EST
Created attachment 326361 [details]
ss of the # of errata in sdc
Comment 4 wes hayutin 2008-12-09 12:05:57 EST
now click on the link "critical" in the sdc and only one package is listed..
Comment 5 wes hayutin 2008-12-09 12:06:29 EST
Created attachment 326363 [details]
ss of the # of errata in list of errata
Comment 6 Jesus M. Rodriguez 2008-12-15 11:56:47 EST
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;

--------------- ---------- ------------------
	     70        174		   31

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

Comment 8 Jesus M. Rodriguez 2009-01-14 22:13:51 EST
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.

Note You need to log in before you can comment on or make changes to this bug.