Satellite upgrade from 5.3 to 5.4 is stopping due to 'ORA-00001: unique constraint (RHNSAT.RHN_SC_AC_SAID_UQ) violated' during schema upgrade

Issue

• Encountering the following error during the schema upgrade step when upgrading from Red Hat Network Satellite 5.3 to 5.4:

# /usr/bin/spacewalk-schema-upgrade  
SQL> spool /var/log/spacewalk/schema-upgrade/20110430-135034-to-satellite-schema-5.4.log append  
SQL> whenever sqlerror exit sql.sqlcode  
SQL> select 'satellite-schema-5.3-to-satellite-schema-5.4/001-rhnServerChannelArchCompat.sql' from dual;  

'SATELLITE-SCHEMA-5.3-TO-SATELLITE-SCHEMA-5.4/001-RHNSERVERCHANNELARCHCOMPAT.SQ  
\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\----  
satellite-schema-5.3-to-satellite-schema-5.4/001-rhnServerChannelArchCompat.sql  

SQL> insert into rhnServerChannelArchCompat (server\_arch\_id, channel\_arch\_id) values  
 2 (LOOKUP\_SERVER\_ARCH('ppc64-redhat-linux'), LOOKUP\_CHANNEL\_ARCH('channel-ppc'));  
 insert into rhnServerChannelArchCompat (server\_arch\_id, channel\_arch\_id) values  
*  
ERROR at line 1:  
ORA-00001: unique constraint (RHNSAT.RHN\_SC\_AC\_SAID\_UQ) violated