Updating systems from System Set Manager(SSM) causes error "ORA-02291 integrity constraint (RHNADMIN.RHN_SSMOPS_SER_FK) violated - parent key not found"

Solution Verified - Updated -

Issue

  • Systems update from System Set Manager(SSM) fails with below errors, these errors are logged in tomcat's catalina.out log,
2017-05-23 12:18:45,199 [RHN Message Dispatcher] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: INSERT INTO rhnSsmOperationServer (operation_id, server_id)

com.redhat.rhn.common.db.WrappedSQLException: ORA-02291: integrity constraint (RHNADMIN.RHN_SSMOPS_SER_FK) violated - parent key not found

Environment

  • Red Hat Satellite 5.x

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