RHN Satellite 5.6 throws an ISE when scheduling a remote command with `timeout=0`

Solution Unverified - Updated -

Issue

  • RHN Satellite throws an ISE when scheduling a remote command using SSM and setting the timeout=0
Error message:
  RHN::Exception: DBD::Pg::st execute failed: ERROR:  column "action_id" is of type numeric but expression is of type text
LINE 2: SELECT DISTINCT S.id, $1, $2
                              ^
HINT:  You will need to rewrite or cast the expression.
  RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 122 RHN::Exception::DB::throw
  RHN::DB::st /usr/share/perl5/vendor_perl/RHN/DB.pm 456 RHN::DB::handle_error
  RHN::DB::Scheduler /usr/share/perl5/vendor_perl/RHN/DB/Scheduler.pm 1454 RHN::DB::st::execute_h
  Sniglets::ListView::SystemList /usr/share/perl5/vendor_perl/Sniglets/ListView/SystemList.pm 371 RHN::DB::Scheduler::schedule_remote_command
  Sniglets::ListView::SystemList /usr/share/perl5/vendor_perl/Sniglets/ListView/SystemList.pm 361 (eval)
  Sniglets::ListView::List /usr/share/perl5/vendor_perl/Sniglets/ListView/List.pm 374 Sniglets::ListView::SystemList::ssm_remote_command_action_cb
  Sniglets::Lists /usr/share/perl5/vendor_perl/Sniglets/Lists.pm 135 Sniglets::ListView::List::callback
  PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 478 Sniglets::Lists::listview_cb
  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)

Environment

  • Red Hat Satellite 5.6

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