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

Solution Verified - Updated -


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:


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


  • 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