Cloning channels on Satellite gives "500 - Internal Server Error" in Web UI and receiving traceback email with ORA-12899
Issue
- When trying to clone a child channel we receive a 500 - Internal Server Error on the Satellite WebUI.
- RHEL Satellite server > channels > manage software channels> clone channel. I select any channel and radio button current state of the channel (all errata) and hit create channel. Error 500 internal server error.
- When trying to clone the base channel, we get this error "500 Error - Internal Server Error" when it fails.
- The following is the email we receive reporting the Web TraceBack:
Error message:
RHN::Exception: DBD::Oracle::st execute failed: ORA-12899: value too large for column "RHNSAT"."RHNERRATAFILETMP"."FILENAME" (actual: 131, maximum: 128) (DBD ERROR: error possibly near <*> indicator at char 176 in 'INSERT
INTO rhnErrataFileTmp
(id, errata_id, type, checksum_id, filename)
(SELECT sequence_nextval('rhn_erratafile_id_seq'), :new_eid, EF.type, EF.checksum_id, <*>EF.filename
FROM rhnErrataFile EF
WHERE EF.errata_id = :old_eid)
') [for Statement "INSERT
INTO rhnErrataFileTmp
(id, errata_id, type, checksum_id, filename)
(SELECT sequence_nextval('rhn_erratafile_id_seq'), :new_eid, EF.type, EF.checksum_id, EF.filename
FROM rhnErrataFile EF
WHERE EF.errata_id = :old_eid)
" with ParamValues: :new_eid="2058", :old_eid="963"]
RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 117 RHN::Exception::DB::throw
RHN::DB::st /usr/share/perl5/vendor_perl/RHN/DB.pm 452 RHN::DB::handle_error
RHN::DB::ErrataEditor /usr/share/perl5/vendor_perl/RHN/DB/ErrataEditor.pm 247 RHN::DB::st::execute_h
RHN::DB::ChannelEditor /usr/share/perl5/vendor_perl/RHN/DB/ChannelEditor.pm 500 RHN::DB::ErrataEditor::clone_into_org
RHN::DB::ChannelEditor /usr/share/perl5/vendor_perl/RHN/DB/ChannelEditor.pm 426 RHN::DB::ChannelEditor::clone_errata_into_channel
Sniglets::ChannelEditor /usr/share/perl5/vendor_perl/Sniglets/ChannelEditor.pm 261 RHN::DB::ChannelEditor::clone_all_errata
Sniglets::ChannelEditor /usr/share/perl5/vendor_perl/Sniglets/ChannelEditor.pm 227 (eval)
PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 482 Sniglets::ChannelEditor::channel_edit_cb
PXT::Request /usr/share/perl5/vendor_perl/PXT/Request.pm 561 PXT::ApacheHandler::pxt_parse_data
PXT::Handlers /usr/share/perl5/vendor_perl/PXT/Handlers.pm 115 PXT::Request::include
PXT::Parser /usr/share/perl5/vendor_perl/PXT/Parser.pm 141 PXT::Handlers::pxt_include_handler
PXT::Parser /usr/share/perl5/vendor_perl/PXT/Parser.pm 72 PXT::Parser::expand_tag
PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 456 PXT::Parser::expand_tags
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)
Offending Query: INSERT
INTO rhnErrataFileTmp
(id, errata_id, type, checksum_id, filename)
(SELECT sequence_nextval('rhn_erratafile_id_seq'), :new_eid, EF.type, EF.checksum_id, EF.filename
FROM rhnErrataFile EF
WHERE EF.errata_id = :old_eid)
Environment
- Red Hat Network (RHN) Satellite 5.3, 5.4 and 5.5
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.