[Spacewalk-list] Spacewalk 1.5, Remote Commands, ORA-00904: "X"."NAME": invalid identifier
Trevor T Kates
trevor.t.kates at dom.com
Mon Jul 25 21:37:42 UTC 2011
List:
After upgrading to Spacewalk 1.5, the attached traceback is being generated
when attempting to run remote commands via the System Set Manager when any
number of systems is selected. The backend database serving this instance of
Spacewalk is Oracle11gR2 XE. I'm trying to pin down whether this is an issue
with Oracle11g, but at the moment, I don't have an Oracle10g instance available
on which to test.
Any assistance with this is greatly appreciated.
Regards,
_______________________________________________________________________________
Trevor T. Kates
> -----Original Message-----
> From: dev-null at dom.com [mailto:dev-null at dom.com]
> Sent: Monday, July 25, 2011 5:31 PM
> To: Trevor T Kates (Services - 6)
> Subject: WEB TRACEBACK from spacewalk.example.com (Mon Jul 25 17:31:13 2011)
>
> The following exception occurred while executing this request:
> POST /network/systems/ssm/provisioning/remote_command_conf.pxt HTTP/1.1 (from
> browser)
> /network/systems/ssm/provisioning/remote_command_conf.pxt (from Apache)
>
> Date:
> Mon Jul 25 17:31:13 2011
>
> Headers:
> Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
> Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
> Accept-Encoding: gzip,deflate
> Accept-Language: en-us,en;q=0.5
> Connection: keep-alive
> Content-Length: 231
> Content-Type: application/x-www-form-urlencoded
> Cookie: pxt-session-cookie=162300xb57639fa15eeb28e69e3396766cc15e6
> Host: spacewalk.example.com
> Keep-Alive: 115
> Referer:
> https://spacewalk.example.com/network/systems/ssm/provisioning/remote_command.
> pxt
> User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.18)
> Gecko/20110622 CentOS/3.6-1.el5.centos Firefox/3.6.18
>
> Form variables:
> am_pm => PM
> day => 25
> formvar_hmac => cd0b4df26e6f75cbea5d45f1b959588ad81590db
> group => root
> hour => 5
> minute => 31
> mode => ssm
> month => 7
> schedule_remote_command => Schedule Remote Command
> script => #!/bin/sh
> ls
> timeout => 600
> username => root
> year => 2011
>
> User Information:
> User trevor7 (id 1, org_id 1)
>
> Error notes:
> (none)
>
> Initial Request:
> Yes
>
> Error message:
> RHN::Exception: DBD::Oracle::db prepare_cached failed: ORA-00904: "X"."NAME":
> invalid identifier (DBD ERROR: error possibly near <*> indicator at char 614 in
> '
> select * from (
> SELECT DISTINCT S.id,
> S.name AS SERVER_NAME
> FROM rhnServer S,
> rhnClientCapabilityName CCN,
> rhnClientCapability CC,
> rhnSet ST,
> rhnUserServerPerms USP
> WHERE USP.user_id = :user_id
> AND ST.user_id = :user_id
> AND ST.label = 'system_list'
> AND USP.server_id = ST.element
> AND EXISTS(SELECT 1 FROM rhnServerFeaturesView SFV WHERE SFV.server_id =
> ST.element AND SFV.label = 'ftr_remote_command')
> AND USP.server_id = CC.server_id
> AND CC.capability_name_id = CCN.id
> AND CCN.name = 'script.run'
> AND USP.server_id = S.id
> ) X
> ORDER BY UPPER(COALESCE(<*>X.name, '(none)')), X.id
>
> ') [for Statement "
> select * from (
> SELECT DISTINCT S.id,
> S.name AS SERVER_NAME
> FROM rhnServer S,
> rhnClientCapabilityName CCN,
> rhnClientCapability CC,
> rhnSet ST,
> rhnUserServerPerms USP
> WHERE USP.user_id = :user_id
> AND ST.user_id = :user_id
> AND ST.label = 'system_list'
> AND USP.server_id = ST.element
> AND EXISTS(SELECT 1 FROM rhnServerFeaturesView SFV WHERE SFV.server_id =
> ST.element AND SFV.label = 'ftr_remote_command')
> AND USP.server_id = CC.server_id
> AND CC.capability_name_id = CCN.id
> AND CCN.name = 'script.run'
> AND USP.server_id = S.id
> ) X
> ORDER BY UPPER(COALESCE(X.name, '(none)')), X.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::DataSource /usr/lib/perl5/vendor_perl/5.8.8/RHN/DataSource.pm 108
> RHN::DB::DataSource::run_query
> Sniglets::ListView::List
> /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/List.pm 1211
> RHN::DataSource::execute_query
> 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 510
> PXT::Parser::expand_tags
> PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 113
> PXT::ApacheHandler::pxt_parse_data
> PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 113
> (eval)
> main -e 0 PXT::ApacheHandler::handler
> main -e 0 (eval)
CONFIDENTIALITY NOTICE: This electronic message contains
information which may be legally confidential and/or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect. The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful. If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it. Thank you.
More information about the Spacewalk-list
mailing list