Translated message

A translation of this page exists in English.

Satellite のチャンネルをクローンにすると、Web UI に "500 - Internal Server Error" が表示され、"ORA-12899: value too large for column "RHNSAT"."RHNERRATAFILETMP"."FILENAME" (actual: ***, maximum: 128)" であることを示すトレースバックメールを受け取ります

Solution Verified - Updated -

Issue

  • 子チャンネルをクローンにすると、Satellite WebUI で "500 - Internal Server Error" を受け取ります。
  • [RHEL Satellite サーバー]、[チャンネル]、[ソフトウェアチャンネルの管理]、[チャンネルのクローン] の順に選択します。 チャンネルと、チャンネル (すべてのエラータ) で現在選択できるラジオボタンを選択し、[チャンネルの作成] を選択します。"Error 500 internal server error..." が発生します。
  • 以下は、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、および 5.5

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content