Description of problem: On Satellite 5.6.0 with Oracle DB backend there is ISE when you attempt to add Red Hat errata to custom channel. Version-Release number of selected component (if applicable): spacewalk-schema-2.0.2-13.el6sat.noarch spacewalk-java-2.0.2-50.el6sat.noarch How reproducible: always on one system Steps to Reproduce: I'm not perfectly clear if this is the case of one specific system or all Satellite deployments, but this is what I have done: 1. Channels -> Manage Software Channels -> <some_custom_channel> -> Errata -> Add -> Add Red Hat Errata Actual results: ISE [...] 2014-01-17 03:34:09,325 [TP-Processor1] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: SELECT DISTINCT E.id, E.advisory_name AS advisory, E.update_date AS UPDATE_DATE, E.synopsis as ADVISORY_SYNOPSIS, E.advisory_type as ADVISORY_TYPE FROM rhnErrata E inner join rhnChannelErrata CE on CE.errata_id = E.id inner join rhnSet S on S.element = CE.channel_id inner join rhnErrataPackage EP on EP.errata_id = E.id inner join rhnPackage P on p.id = EP.package_id inner join rhnPackage P2 on P.name_id = P2.name_id inner join rhnChannelPackage CP on P2.id = CP.package_id WHERE CP.channel_id = ? and S.user_id = ? and S.label = 'channels_for_errata' and E.id not in (select errata_id from rhnChannelErrata where channel_id = ?) and E.id not in (select original_id from rhnChannelErrata CE, rhnErrataCloned EC where CE.errata_id = EC.id and CE.channel_id = ?); com.redhat.rhn.common.db.WrappedSQLException: ORA-00911: invalid character [...] Expected results: Should display the form
Created attachment 851471 [details] relevant part of catalina.out
This does not seem to be a problem on Satellite with PostgreSQL DB backend.
*** This bug has been marked as a duplicate of bug 1053436 ***