This request is to add the Vendor Supported Software Channels to RHN/QA. The
channel file in svn is: vss-channels.cvs
The SVN revision number is: 61041.
PLEASE NOTE: This will require creating new Channel Families. I've placed the
family name/desc in the row immediately preceeding the new channel requests.
1. Create new channel family "rhel-vss-hp-private" - "HP Premier Software â HP
Verification Access Only"
2. Create new channel family "rhel-vss-ibm-private" - "IBM Supported Software â
IBM Verification Access Only"
3. Create new channel family "rhel-vss-dell-private" - "DELL Supported Software
â DELL Verification Access Only"
4. Create new channel family "rhel-vss-extras" â "Vendor Supported Software Extras"
Created attachment 116352 [details]
vss-channels.cvs - rev#61041
Channel families created. There was a non-ascii character in the csv (the dash
in the channel names) in the future make sure it looks good through vi or
something similar and that OO isn't putting in non-ascii characters.
Channel creation failed. You have a unique contraint violation. Basically you
are trying to create a channel that has another field that is the same as an
Creating channel rhel-3-vss
Channel rhel-3-vss membership updated
Exception caught, rolling back...
server.rhnSQL.sql_base.SQLError: (1, 'ORA-00001: unique constraint
(RHN.RHN_DCM_OS_RELEASE_CAID_UQ) violated\n', 'insert into rhnDistChannelMap
(channel_id, channel_arch_id, os, release) values (:channel_id,
:channel_arch_id, :os, :release)')
Looks like it's whatever is right after the rhel-3-vss channel (or possibly that
Created attachment 116672 [details]
HP VSS channels
Committed revision 61631.
This should create the HP only channels.
Please see if the HP channels will create now that I've changed up the spread sheet.
Two new families are required:
Transmitting file data .
Committed revision 61631.
I tried to push HP-VSS-channels.csv to qa, but there are still a couple issues
with this csv.
rhel-i386-3 is listed as the parent channel for some of the new channels, but
there is not channel with this label. There is a rhel-i386-as-3, if that's the
one you want. Same problem with rhel-x86_64-3, i think the one you want is
Also, I got an error indicating that some of the values for the new channels
were too large for their columns in the db.
Here are the column length limits:
Name Null? Type
----------------------- -------- ----------------
ID NOT NULL NUMBER
LABEL NOT NULL VARCHAR2(128)
BASEDIR NOT NULL VARCHAR2(256)
NAME NOT NULL VARCHAR2(64)
SUMMARY NOT NULL VARCHAR2(500)
LAST_MODIFIED NOT NULL DATE
CREATED NOT NULL DATE
MODIFIED NOT NULL DATE
CHANNEL_ARCH_ID NOT NULL NUMBER
any update on this, or can I close this out?
Closing this out due to lack of updates.