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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
