[Spacewalk-list] Updates not displayed in web interface

[Stefan Förster]

Hi there,

at our Spacewalk 0.8 server (upgraded from 0.6 to 0.7 and then from
0.7 to 0.8), available updates don't show up in the web interface. We
are generating the reports about updates with our regular reporting
system, using the following SQL against an Oracle 10.2 database:

set linesize 200;
set pagesize 100;

column Hostname format a30;
column Updates format 9999999;

SELECT srv.name "Hostname",
       count(srv.name) "Updates"
FROM spacewalk.rhnserver SRV
     JOIN spacewalk.RHNSERVERNEEDEDPACKAGEVIEW NPV ON SRV.ID = NPV.Server_id
GROUP BY SRV.id, SRV.name
ORDER BY SRV.name;


However, these updates are not displayed in the web interface. More
precise, the table "rhnServerNeededCache" never get's filled. We have
to execute the following SQL to get it filled:

delete from rhnServerNeededCache;
insert into rhnServerNeededCache(SERVER_ID,PACKAGE_ID) (select
SERVER_ID,PACKAGE_ID from RHNSERVERNEEDEDPACKAGEVIEW);

How do we fix that problem?


Cheers
Stefan