List: I'm getting the following ISE when trying to create a notification method for my Spacewalk user.
Any assistance in fixing this would be appreciated. Thanks! ________________________________________________________ Trevor T. Kates Associate Software Systems Engineer -----Original Message----- From: dev-n...@dom.com [mailto:dev-n...@dom.com] Sent: Tuesday, December 14, 2010 4:57 PM To: Trevor T Kates (Services - 6) Subject: WEB TRACEBACK (Tue Dec 14 16:56:53 2010) The following exception occurred while executing this request: POST /network/users/details/contact_methods/create.pxt HTTP/1.1 (from browser) /network/users/details/contact_methods/create.pxt (from Apache) Date: Tue Dec 14 16:56:53 2010 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: 165 Content-Type: application/x-www-form-urlencoded Cookie: pxt-session-cookie=138218x34f7fc33389a5e50917adedefc6421fe Host: redacted Keep-Alive: 115 Referer: https://redacted/network/users/details/contact_methods/create.pxt?uid=1 User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13) Gecko/20101209 CentOS/3.6-2.el5.centos Firefox/3.6.13 Form variables: create_method => Create Method method_email => trevor.t.ka...@dom.com method_name => DomMail pxt:trap => rhn:contact-method-create-cb redirect_to => index.pxt?uid=1 uid => 1 User Information: User trevor (id 1, org_id 1) Error notes: (none) Initial Request: Yes Error message: RHN::Exception: DBD::Oracle::st execute failed: ORA-00904: "CM"."LAST_UPDATE_DATE": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 192 in 'INSERT INTO rhn_contact_methods (recid, method_name, contact_id, schedule_id, method_type_id, pager_email, pager_split_long_messages, email_address, last_update_user, notification_format_id, <*>CM.last_update_date) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, SYSDATE)') [for Statement "INSERT INTO rhn_contact_methods (recid, method_name, contact_id, schedule_id, method_type_id, pager_email, pager_split_long_messages, email_address, last_update_user, notification_format_id, CM.last_update_date) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, SYSDATE)" with ParamValues: :p5="2", :p8='trevor.t.ka...@dom.com', :p10="4", :p2='DomMail', :p3='1', :p6=undef, :p1="3", :p7=0, :p4=1, :p9="1"] RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228 RHN::Exception::DB::throw RHN::DB::ContactMethod /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/ContactMethod.pm 225 RHN::DB::handle_error Sniglets::ContactMethod /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ContactMethod.pm 208 RHN::DB::ContactMethod::commit Sniglets::ContactMethod /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ContactMethod.pm 207 (eval) PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 515 Sniglets::ContactMethod::contact_method_edit_cb PXT::Request /usr/lib/perl5/vendor_perl/5.8.8/PXT/Request.pm 585 PXT::ApacheHandler::pxt_parse_data PXT::Handlers /usr/lib/perl5/vendor_perl/5.8.8/PXT/Handlers.pm 114 PXT::Request::include PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 141 PXT::Handlers::pxt_include_handler 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 117 PXT::ApacheHandler::pxt_parse_data PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 117 (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. _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list