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-n...@dom.com [mailto:dev-n...@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