[Spacewalk-list] after 1.2 update WEB TRACEBACK on remote command in SSM

Marco Giunta giunta at sissa.it
Thu Dec 9 09:46:26 UTC 2010


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




More information about the Spacewalk-list mailing list