[Spacewalk-list] ISE when attempting to create a notification method for Spacewalk user

[Trevor T Kates]

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-null at dom.com [mailto:dev-null at 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.kates at 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.kates at 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.