Bug 772181

Summary: WEB TRACEBACK
Product: [Community] Spacewalk Reporter: Artem <im.gavrilenko>
Component: WebUIAssignee: Tomas Lestach <tlestach>
Status: CLOSED DUPLICATE QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 1.6CC: slukasik
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-01-06 12:06:13 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On:    
Bug Blocks: 765736    

Description Artem 2012-01-06 10:35:57 UTC
The following exception occurred while executing this request:
 POST /network/systems/details/history/cancel_events_confirm.pxt HTTP/1.1 (from browser)
 /network/systems/details/history/cancel_events_confirm.pxt (from Apache)

Date:
 Fri Jan  6 05:11:23 2012

Headers:
 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
 Accept-Charset: windows-1251,utf-8;q=0.7,*;q=0.3
 Accept-Encoding: gzip,deflate,sdch
 Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.6,en;q=0.4
 Cache-Control: max-age=0
 Connection: keep-alive
 Content-Length: 385
 Content-Type: application/x-www-form-urlencoded
 Cookie: pxt-session-cookie=106x2e16a0751bca293adcc3ebd5411919d6
 Host: 10.0.0.209
 Origin: https://10.0.0.209
 Referer: https://10.0.0.209/network/systems/details/history/cancel_events_confirm.pxt?set_label=schedule_action_list&sid=1000010001
 User-Agent: Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2

Form variables:
 alphabar_column =>
 first_lower => 1
 first_upper => 25
 formvars => set_label
 formvars => set_label
 formvars => set_label
 last_lower => 1
 last_upper => 3
 list_action_label_cancel-events => Cancel Selected Events
 list_action_url_cancel-events =>
 list_mode => events_in_set
 lower => 1
 next_lower => 1
 next_upper => 3
 prev_lower => 1
 prev_upper => 25
 pxt:trap => rhn:action_list_cb
 set_label => schedule_action_list
 sid => 1000010001
 upper => 3

User Information:
 User imroot (id 1, org_id 1)

Error notes:
 (none)

Initial Request:
 Yes

Error message:
 RHN::Exception: DBD::Oracle::db prepare failed: ORA-00911: invalid character (DBD ERROR: error possibly near <*> indicator at char 197 in 'SELECT SA.action_id
 FROM rhnSet ST, rhnServerAction SA
 WHERE ST.user_id = :user_id
  AND ST.label = :label
  AND SA.server_id = :server_id
  AND ST.element = SA.action_id
  AND SA.status = 0<*>;
') [for Statement "SELECT SA.action_id
 FROM rhnSet ST, rhnServerAction SA
 WHERE ST.user_id = :user_id
  AND ST.label = :label
  AND SA.server_id = :server_id
  AND ST.element = SA.action_id
  AND SA.status = 0;
"]
 RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 228 RHN::Exception::DB::throw
 RHN::DB::Action /usr/share/perl5/vendor_perl/RHN/DB/Action.pm 240 RHN::DB::handle_error
 Sniglets::ListView::ActionList /usr/share/perl5/vendor_perl/Sniglets/ListView/ActionList.pm 168 RHN::DB::Action::delete_system_from_action_set
 Sniglets::ListView::List /usr/share/perl5/vendor_perl/Sniglets/ListView/List.pm 374 Sniglets::ListView::ActionList::events_in_set_cb
 Sniglets::Lists /usr/share/perl5/vendor_perl/Sniglets/Lists.pm 135 Sniglets::ListView::List::callback
 PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 489 Sniglets::Lists::listview_cb
 PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 PXT::ApacheHandler::pxt_parse_data
 PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 (eval)
 main -e 0 PXT::ApacheHandler::handler
 main -e 0 (eval)

Comment 1 Tomas Lestach 2012-01-06 12:06:13 UTC

*** This bug has been marked as a duplicate of bug 771634 ***