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
missed a step in the test plan 5. create an activation with the public custom channel from step 3
this looks fixed in spacewalk code and was probably fixed from 492588. lets do a retest in qa. <Preethi> shughes, looks like thats fixed on your satellite <shughes> Preethi, k...thanks for cross checking <Preethi> shughes, np <shughes> i modified the query for that page late last week...i think that fixed it
mass move to onqa
fails in the latest iso Satellite-5.3.0-RHEL5-re20090520.0-i386-embedded-oracle.iso attached screen shot
Created attachment 345010 [details] child-channel in activation key
took out join against rhnSharedChannelView to prevent dups.
*** Bug 502882 has been marked as a duplicate of this bug. ***
verified. Satellite-5.3.0-RHEL5-re20090529.0-i386-embedded-oracle shared child channels are only displayed once under activation key
Confirming Comment#9 Stage validated -> RELEASE_PENDING
An advisory has been issued which should help the problem described in this bug report. This report is therefore being closed with a resolution of ERRATA. For more information on therefore solution and/or where to find the updated files, please follow the link below. You may reopen this bug report if the solution does not work for you. http://rhn.redhat.com/errata/RHEA-2009-1434.html