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 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.
