Upgrading to RHN Satellite 5.5 results in "ORA-02292: integrity constraint (RHNSAT.RHN_PKGSRC_GROUP_FK) violated" error

Solution Verified - Updated 2024-08-06T07:15:25+00:00 -

Issue

spacewalk-schema-update failed during upgrade, the error log showed the error:

delete from rhnpackagegroup pg
*
ERROR at line 1:
ORA-02292: integrity constraint (RHNSAT.RHN_PKGSRC_GROUP_FK) violated - child record found

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Here are the common uses of Markdown.

Code blocks

~~~
Code surrounded in tildes is easier to read
~~~

Links/URLs

[Red Hat Customer Portal](https://access.redhat.com)