[Spacewalk-list] WEB TRACEBACK

[Milan Zazrivec]

On Monday 30 July 2012 20:48:05 Ron Helzer wrote:
> 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?s
> id=1000010408<https://spacewalk.hgvc.com/network/systems/details/history/hi
> story.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)

Fixed in spacewalk.git master: 6e34bd693fd826f85e48a9ef464ef2d13466728a

Thank you
-Milan Zázrivec