Created attachment 453749 [details]
Log from sync process.

Description of problem:
After Satellite upgrade from 5.2.1 to 5.4 with external DB upgrade from oracle-10g to 11g, satellite-sync returnes SQL error when retrieving product names data. But the sync process does not crash after that and continues as usual.

Version-Release number of selected component (if applicable):
# rpm -q rhn-upgrade
rhn-upgrade-5.4.0.8-1.el5sat
# rhn-schema-version 
5.4.0.8-1.el5sat
# rpm -q spacewalk-schema
spacewalk-schema-1.2.21-7.el5sat

How reproducible:
Always

Steps to Reproduce:
1. run 'satellite-sync -c <your_channel>'
   (doesn't matter if you have fully synced the channel earlier or not)
2. Wait to the moment, when sync says "Retrieving / parsing product names data"
3. See the stacktrace with SQL error
  
Actual results:
Python stacktrace with SQL error:
(1, 'ORA-00001: unique constraint (PNOVOTNY.RHN_PRODUCTNAME_NAME_UQ) violated\n', "insert into rhnProductName (id, label, name) values (sequence_nextval('rhn_productname_id_seq'), :product_label, :product_name)")

Expected results:
No SQL error.

Additional info:
See full log from sync process in attachment.