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

Solution Verified - Updated -

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.

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