Bug 500429

Created attachment 343625 [details]
ise on activation key

Description of problem:
shared child channels are displayed twice under activationkey->child channels

Version-Release number of selected component (if applicable):

Satellite-5.3.0-RHEL5-re20090507.1-i386-embedded-oracle.iso
How reproducible:


Steps to Reproduce:
1.create 2 orgs orgA & orgB
2.establish a trust between orgA &orgB
3.create a public channel in orgA 
4. create another public channel as the child of the above channel.
5. create an activation key with provisioning checked
6. navigate to the child channel tab for the activation key
7. see that child channel is displayed twice
8. select the child channel and click on update key.


  
Actual results:
shared child channels are displayed twice.
selecting the child channel results in ISE

Expected results:


Additional info:
The following exception occurred while executing this request:
 POST /network/account/activation_keys/child_channels.pxt HTTP/1.1 (from browser)
 /network/account/activation_keys/child_channels.pxt (from Apache)

Date:
  Tue May 12 12:10:28 2009

Headers:
  Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
  Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  Accept-Encoding: gzip,deflate
  Accept-Language: en-us,en;q=0.5
  Connection: keep-alive
  Content-Length: 143
  Content-Type: application/x-www-form-urlencoded
  Cookie: rh_omni_tc=70160000000H4AoAAK; s_vi=[CS]v1|49ADE3A00000275D-A3A0999000007BF[CE]; __qca=49acb2eb-314b0-7ea25-f74b9; pxt-session-cookie=1540xf704bc1e5b68e16ba63b866009178397; pxt-session-cookie=1540xf704bc1e5b68e16ba63b866009178397
  Host: rlx-0-10.rhndev.redhat.com
  Keep-Alive: 300
  Referer: https://rlx-0-10.rhndev.redhat.com/network/account/activation_keys/child_channels.pxt?tid=41
  User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.5) Gecko/2008120908 Red Hat/3.0.5-1.el5_2 Firefox/3.0.5

Form variables:
  Update Key => Update Key
  pxt:trap => rhn:edit_token_channels_cb
  tid => 41
  token_child_channels => 125
  token_child_channels => 125
  token_child_channels => 125

User Information:
  User pt-org2 (id 22, org_id 3)

Error notes:
  (none)

Initial Request:
  Yes

Error message:
  RHN::Exception: DBD::Oracle::st execute failed: ORA-00001: unique constraint (RHNSAT.RHN_REG_TOK_CHN_UQ) violated (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO rhnRegTokenChannels
            (token_id, channel_id)
SELECT DISTINCT :tid, :cid