[Spacewalk-list] WEB TRACEBACK

[Ron Helzer]

I'm getting the following traceback in Spacewalk 1.7 when attempting to
view the history for a failed event. I believe this Spacewalk installation
began around version 0.7 and has been upgraded through each successive
release.

The following exception occurred while executing this request:

 GET /network/systems/details/history/event.pxt?sid=1000010408&hid=43897
HTTP/1.1 (from browser)  /network/systems/details/history/event.pxt (from
Apache)



Date:

  Fri Jul 27 15:59:10 2012



Headers:

  Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

  Accept-Encoding: gzip, deflate

  Accept-Language: en-us,en;q=0.5

  Connection: keep-alive

  Cookie: __utma=28514213.865170206.1319482654.1319482654.1319482654.1;
pxt-session-cookie=31254x8ae38551827bc5563011140108dd4f56

  Host: spacewalk.hgvc.com

  Referer:
https://spacewalk.example.com/network/systems/details/history/history.pxt?sid=1000010408<https://spacewalk.hgvc.com/network/systems/details/history/history.pxt?sid=1000010408>

  User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20100101
Firefox/14.0.1

  X-ClickOnceSupport: ( .NET CLR 3.5.30729; .NET4.0E)



Form variables:

  hid => 43897

  sid => 1000010408



User Information:

  User administrator (id 1, org_id 1)



Error notes:

  (none)



Initial Request:

  Yes



Error message:

  RHN::Exception: DBD::Oracle::db prepare_cached failed: ORA-00905: missing
keyword (DBD ERROR: error possibly near <*> indicator at char 165 in '

SELECT CFN.path,

       CFF.name AS FAILURE_REASON

  FROM

       rhnConfigFileName CFN,

       rhnActionConfigFileName ACFN

  LEFT JOIN rhnConfigFileFailure CFF

   <*>AND ACFN.failure_id = CFF.id

 WHERE ACFN.server_id = :sid

   AND ACFN.action_id = :aid

   AND ACFN.config_file_name_id = CFN.id ORDER BY CFN.path

  ') [for Statement "

SELECT CFN.path,

       CFF.name AS FAILURE_REASON

  FROM

       rhnConfigFileName CFN,

       rhnActionConfigFileName ACFN

  LEFT JOIN rhnConfigFileFailure CFF

   AND ACFN.failure_id = CFF.id

 WHERE ACFN.server_id = :sid

   AND ACFN.action_id = :aid

   AND ACFN.config_file_name_id = CFN.id ORDER BY CFN.path

  "]

  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 121
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::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DataSource.pm 108
RHN::DB::DataSource::run_query

  RHN::DB::Server /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/Server.pm 926
RHN::DataSource::execute_query

  RHN::DB::Server /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/Server.pm 973
RHN::DB::Server::server_event_config_upload

  RHN::Server /usr/lib/perl5/vendor_perl/5.8.8/RHN/Server.pm 49
RHN::DB::Server::server_event_details

  Sniglets::Servers /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Servers.pm
382 RHN::Server::lookup_server_event

  PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 160
Sniglets::Servers::server_history_event_details

  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
489 PXT::Parser::expand_tags

  PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm
103 PXT::ApacheHandler::pxt_parse_data

  PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm
103 (eval)

  main -e 0 PXT::ApacheHandler::handler
  main -e 0 (eval)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120730/40ec57ad/attachment.htm>