Satellite 5.7 throws an ISE when trying to add a Red Hat Errata to a custom channel using when connected to an external Oracle database
Issue
- Satellite 5.7 throws an Internal Server Error when trying to add a Red Hat Errata to a custom channel using when connected to an external Oracle database.
2015-05-13 09:58:28,742 [TP-Processor7] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: SELECT DISTINCT E.id , E.advis
ory_name AS advisory,
E.update_date AS UPDATE_DATE,
E.synopsis as ADVISORY_SYNOPSIS,
E.advisory_type as ADVISORY_TYPE,
E.advisory_name AS advisory
FROM rhnErrata E inner join
rhnChannelErrata CE on E.id = CE.errata_id left join
( select Cloned.original_id as clonedId from rhnChannelErrata CE2 inner join
rhnErrataCloned Cloned on CE2.errata_id = cloned.id
where CE2.channel_id = ?
) temp on E.id = temp.clonedId left join
(SELECT errata_id from rhnChannelErrata where channel_id = ?) exists on exists.errata_id = E.id,
rhnSet S
WHERE CE.channel_id = S.element
AND S.label = 'channels_for_errata'
and temp.clonedId is null
and exists.errata_id is null
and S.user_id = ?
Caused by:
com.redhat.rhn.common.db.WrappedSQLException: ORA-00905: missing keyword
Environment
- Red Hat Satellite 5.7
- External Oracle database
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.