<p class="MsoPlainText">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.<br>
</p><p style="margin-left:40px" class="MsoPlainText">The following exception occurred while executing this
request:</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>GET
/network/systems/details/history/event.pxt?sid=1000010408&hid=43897
HTTP/1.1 (from browser)<span style>
</span>/network/systems/details/history/event.pxt (from Apache)</p>
<p style="margin-left:40px" class="MsoPlainText"> </p>
<p style="margin-left:40px" class="MsoPlainText">Date:</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>Fri Jul 27
15:59:10 2012</p>
<p style="margin-left:40px" class="MsoPlainText"> </p>
<p style="margin-left:40px" class="MsoPlainText">Headers:</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>Accept:
text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>Accept-Encoding:
gzip, deflate</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>Accept-Language:
en-us,en;q=0.5</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>Connection:
keep-alive</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>Cookie:
__utma=28514213.865170206.1319482654.1319482654.1319482654.1;
pxt-session-cookie=31254x8ae38551827bc5563011140108dd4f56</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>Host:
<a href="http://spacewalk.hgvc.com">spacewalk.hgvc.com</a></p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>Referer: <a href="https://spacewalk.hgvc.com/network/systems/details/history/history.pxt?sid=1000010408"><span style="color:windowtext;text-decoration:none">https://spacewalk.example.com/network/systems/details/history/history.pxt?sid=1000010408</span></a></p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>User-Agent:
Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20100101 Firefox/14.0.1</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>X-ClickOnceSupport:
( .NET CLR 3.5.30729; .NET4.0E)</p>
<p style="margin-left:40px" class="MsoPlainText"> </p>
<p style="margin-left:40px" class="MsoPlainText">Form variables:</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>hid => 43897</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>sid =>
1000010408</p>
<p style="margin-left:40px" class="MsoPlainText"> </p>
<p style="margin-left:40px" class="MsoPlainText">User Information:</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>User administrator (id
1, org_id 1)</p>
<p style="margin-left:40px" class="MsoPlainText"> </p>
<p style="margin-left:40px" class="MsoPlainText">Error notes:</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>(none)</p>
<p style="margin-left:40px" class="MsoPlainText"> </p>
<p style="margin-left:40px" class="MsoPlainText">Initial Request:</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>Yes</p>
<p style="margin-left:40px" class="MsoPlainText"> </p>
<p style="margin-left:40px" class="MsoPlainText">Error message:</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>RHN::Exception:
DBD::Oracle::db prepare_cached failed: ORA-00905: missing keyword (DBD ERROR:
error possibly near <*> indicator at char 165 in '</p>
<p style="margin-left:40px" class="MsoPlainText">SELECT CFN.path,</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>CFF.name AS
FAILURE_REASON</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>FROM</p>
<p style="margin-left:40px" class="MsoPlainText"><span style>
</span>rhnConfigFileName CFN,</p>
<p style="margin-left:40px" class="MsoPlainText"><span style>
</span>rhnActionConfigFileName ACFN</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>LEFT JOIN
rhnConfigFileFailure CFF</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span><*>AND
ACFN.failure_id = CFF.id</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>WHERE
ACFN.server_id = :sid</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>AND
ACFN.action_id = :aid</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>AND
ACFN.config_file_name_id = CFN.id ORDER BY CFN.path</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>') [for Statement
"</p>
<p style="margin-left:40px" class="MsoPlainText">SELECT CFN.path,</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>CFF.name AS
FAILURE_REASON</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>FROM</p>
<p style="margin-left:40px" class="MsoPlainText"><span style>
</span>rhnConfigFileName CFN,</p>
<p style="margin-left:40px" class="MsoPlainText"><span style>
</span>rhnActionConfigFileName ACFN</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>LEFT JOIN
rhnConfigFileFailure CFF</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>AND
ACFN.failure_id = CFF.id</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>WHERE
ACFN.server_id = :sid</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>AND
ACFN.action_id = :aid</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>AND
ACFN.config_file_name_id = CFN.id ORDER BY CFN.path</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>"]</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>RHN::DB
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 121 RHN::Exception::DB::throw</p>
<p style="margin-left:40px" class="MsoPlainText"><span style>
</span>RHN::DB::DataSource
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/DataSource.pm 73 RHN::DB::handle_error</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>RHN::DataSource
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DataSource.pm 108
RHN::DB::DataSource::run_query</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>RHN::DB::Server
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/Server.pm 926
RHN::DataSource::execute_query</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>RHN::DB::Server
/usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/Server.pm 973 RHN::DB::Server::server_event_config_upload</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>RHN::Server
/usr/lib/perl5/vendor_perl/5.8.8/RHN/Server.pm 49
RHN::DB::Server::server_event_details</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>Sniglets::Servers
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Servers.pm 382
RHN::Server::lookup_server_event</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>PXT::Parser
/usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 160
Sniglets::Servers::server_history_event_details</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>PXT::Parser
/usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 72 PXT::Parser::expand_tag</p>
<p style="margin-left:40px" class="MsoPlainText"><span style>
</span>PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm
489 PXT::Parser::expand_tags</p>
<p style="margin-left:40px" class="MsoPlainText"><span style>
</span>PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm
103 PXT::ApacheHandler::pxt_parse_data</p>
<p style="margin-left:40px" class="MsoPlainText"><span style>
</span>PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm
103 (eval)</p>
<p style="margin-left:40px" class="MsoPlainText"><span style> </span>main -e 0
PXT::ApacheHandler::handler</p><div style="margin-left:40px">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span style> </span>main -e
0 (eval)</span></div>