Satellite 5.4 to 5.7 upgrade fails with "no matching unique or primary key for this column-list"

Solution Verified - Updated -

Issue

During an upgrade of Satellite from 5.4 to 5.7, the step to run spacewalk-schema-upgrade fails with the following in the log:

SATELLITE-SCHEMA-5.5-TO-SATELLITE-SCHEMA-5.6/008-RHNCONTENTSOURCESSL.SQL.ORACL
-------------------------------------------------------------------------------
satellite-schema-5.5-to-satellite-schema-5.6/008-rhnContentSourceSsl.sql.oracle

                constraint rhn_csssl_cacertid_fk references rhnCryptoKey(id),
                                                                         *
ERROR at line 10:
ORA-02270: no matching unique or primary key for this column-list

Environment

  • Red Hat Enterprise Linux 6
  • Satellite 5.4
  • External Oracle database

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In