Created attachment 452975 [details]
Patch for the problem

Description of problem:
rhnpush into a custom channel (i.e. non-null organization) will fail with:
...
Error Message:
    ORA-00001: unique constraint (RHNSAT.RHN_CNP_CID_NID_UQ) violated
ORA-06512: at "RHNSAT.RHN_CHANNEL", line 1091
ORA-06512: at line 1
Error Class Code: 23
Error Class Info: Could not update database entry.

as long as you're pushing the same packages that you already have in
another organization (NULL for example).


Version-Release number of selected component (if applicable):
spacewalk-schema-1.2.21-4

How reproducible:
Always

Steps to Reproduce:
1. Satellite 5.4 synchronize rhel-5 base and tools channel
2. Create a custom channel with an arch matching the arch of channels
you've synced in step 1.
3. Try to rhnpush content of a RHN-Tools compose into the custom channel
  
Actual results:
The packages are uploaded into the filer, though the data update fails with
the error pasted above.

Expected results:
rhnpush succeeds.

Additional info:
Problem is in rhnChannelNewestPackageView view:

http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=e1569a9a6a3e27c99f1125b6f5c12c47836947fd