Hi at all,
after update to 1.2 version, and after apply this patch:
http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=3dc3e6d8986ec442d2a6ab651100840c34c9690e
to /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm I still have WEB TRACEBACK
errors if I run remote commands in SSM, also if I try with only 1
system selected; this is the error:
Error message:
RHN::Exception: DBD::Oracle::db prepare_cached failed: ORA-00904: "OV"."SERVER_ID":
invalid identifier (DBD ERROR: error possibly near<*> indicator at char 704 in '
SELECT SERVER_ID AS ID, SECURITY_ERRATA, BUG_ERRATA, ENHANCEMENT_ERRATA,
OUTDATED_PACKAGES, SERVER_NAME,
SERVER_ADMINS, GROUP_COUNT, NOTE_COUNT, MODIFIED, CHANNEL_LABELS,
CHANNEL_ID, HISTORY_COUNT,
LAST_CHECKIN_DAYS_AGO, PENDING_UPDATES, OS, RELEASE,
SERVER_ARCH_NAME, LAST_CHECKIN, LOCKED,
( SELECT CASE
MAX(CASE PS.state WHEN 'OK' THEN 1 WHEN 'PENDING' THEN 2
WHEN 'UNKNOWN' THEN 3 WHEN 'WARNING' THEN 4 WHEN 'CRITICAL' THEN 5 END)
WHEN 1 THEN 'OK' WHEN 2 THEN 'PENDING' WHEN 3 THEN
'UNKNOWN' WHEN 4 THEN 'WARNING' WHEN 5 THEN 'CRITICAL' END ST
FROM rhn_probe_state PS
LEFT OUTER JOIN rhn_check_probe CP ON<*>OV.server_id = CP.host_id
WHERE PS.probe_id = CP.probe_id
GROUP BY OV.server_id ) MONITORING_STATUS,
COALESCE((SELECT 1 FROM rhnServerFeaturesView SFV WHERE SFV.server_id =
OV.server_id AND SFV.label = 'ftr_system_grouping'), 0) AS SELECTABLE
FROM rhnServerOverview OV
WHERE server_id IN (:p0)
ORDER BY UPPER(NVL(SERVER_NAME, '(none)')), SERVER_ID
') [for Statement "
SELECT SERVER_ID AS ID, SECURITY_ERRATA, BUG_ERRATA, ENHANCEMENT_ERRATA,
OUTDATED_PACKAGES, SERVER_NAME,
SERVER_ADMINS, GROUP_COUNT, NOTE_COUNT, MODIFIED, CHANNEL_LABELS,
CHANNEL_ID, HISTORY_COUNT,
LAST_CHECKIN_DAYS_AGO, PENDING_UPDATES, OS, RELEASE,
SERVER_ARCH_NAME, LAST_CHECKIN, LOCKED,
( SELECT CASE
MAX(CASE PS.state WHEN 'OK' THEN 1 WHEN 'PENDING' THEN 2
WHEN 'UNKNOWN' THEN 3 WHEN 'WARNING' THEN 4 WHEN 'CRITICAL' THEN 5 END)
WHEN 1 THEN 'OK' WHEN 2 THEN 'PENDING' WHEN 3 THEN
'UNKNOWN' WHEN 4 THEN 'WARNING' WHEN 5 THEN 'CRITICAL' END ST
FROM rhn_probe_state PS
LEFT OUTER JOIN rhn_check_probe CP ON OV.server_id = CP.host_id
WHERE PS.probe_id = CP.probe_id
GROUP BY OV.server_id ) MONITORING_STATUS,
COALESCE((SELECT 1 FROM rhnServerFeaturesView SFV WHERE SFV.server_id =
OV.server_id AND SFV.label = 'ftr_system_grouping'), 0) AS SELECTABLE
FROM rhnServerOverview OV
WHERE server_id IN (:p0)
ORDER BY UPPER(NVL(SERVER_NAME, '(none)')), SERVER_ID
"]
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228
RHN::Exception::DB::throw
RHN::DB::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm 73
RHN::DB::handle_error
RHN::DB::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm 52
RHN::DB::DataSource::run_query
RHN::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DataSource.pm 144
RHN::DB::DataSource::run_complex_query
Sniglets::ListView::List
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm 1220
RHN::DataSource::elaborate
Sniglets::ListView::List
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm 908
Sniglets::ListView::List::default_provider
Sniglets::Lists /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Lists.pm 119
Sniglets::ListView::List::render
PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 160
Sniglets::Lists::listview
PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 72
PXT::Parser::expand_tag
PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 522
PXT::Parser::expand_tags
PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 117
PXT::ApacheHandler::pxt_parse_data
PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 117
(eval)
main -e 0 PXT::ApacheHandler::handler
main -e 0 (eval)
Is there any other patch available ???
Regards,
Marco
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
