Note: This is a beta release of Red Hat Bugzilla 5.0. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Also email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback here.
Bug 162479 - Please add the following VSS channels and families to RHN QA. Filename: vss-channels.cvs Revision: 61041
Summary: Please add the following VSS channels and families to RHN QA. Filename: vss-...
Alias: None
Product: Red Hat Network
Classification: Red Hat
Component: RHN/Channels
Version: RHN Stable
Hardware: All
OS: Linux
Target Milestone: ---
Assignee: James Slagle
QA Contact: Red Hat Satellite QA List
Whiteboard: None
Depends On:
TreeView+ depends on / blocked
Reported: 2005-07-05 13:36 UTC by Chris Jones
Modified: 2014-01-13 01:49 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Last Closed: 2006-05-04 15:37:37 UTC
Target Upstream Version:

Attachments (Terms of Use)
vss-channels.cvs - rev#61041 (deleted)
2005-07-05 13:36 UTC, Chris Jones
no flags Details
HP VSS channels Committed revision 61631. (deleted)
2005-07-12 18:54 UTC, Chris Jones
no flags Details

Description Chris Jones 2005-07-05 13:36:12 UTC
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"

Comment 1 Chris Jones 2005-07-05 13:36:14 UTC
Created attachment 116352 [details]
vss-channels.cvs - rev#61041

Comment 2 Chris MacLeod 2005-07-05 14:50:47 UTC
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
existing channel.

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
channel itself)

Comment 3 Chris Jones 2005-07-12 18:54:14 UTC
Created attachment 116672 [details]
HP VSS channels
Committed revision 61631.

This should create the HP only channels.

Comment 4 Chris Jones 2005-07-12 18:56:34 UTC
Please see if the HP channels will create now that I've changed up the spread sheet.

Two new families are required:

Adding channels/HP-VSS-channels.csv
Transmitting file data .
Committed revision 61631.

Comment 5 James Slagle 2005-09-26 14:22:27 UTC
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
 PARENT_CHANNEL                   NUMBER
 ORG_ID                           NUMBER
 LABEL                   NOT NULL VARCHAR2(128)
 BASEDIR                 NOT NULL VARCHAR2(256)
 NAME                    NOT NULL VARCHAR2(64)
 SUMMARY                 NOT NULL VARCHAR2(500)
 DESCRIPTION                      VARCHAR2(4000)
 CREATED                 NOT NULL DATE
 MODIFIED                NOT NULL DATE
 GPG_KEY_URL                      VARCHAR2(256)
 GPG_KEY_ID                       VARCHAR2(14)
 GPG_KEY_FP                       VARCHAR2(50)
 END_OF_LIFE                      DATE

Comment 6 James Slagle 2006-01-23 14:44:52 UTC
any update on this, or can I close this out?

Comment 7 Bret McMillan 2006-05-04 15:37:37 UTC
Closing this out due to lack of updates.

Note You need to log in before you can comment on or make changes to this bug.