Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.
Bug 1524216 - Activation Keys > Associations > Content Hosts generates bad links / no data
Summary: Activation Keys > Associations > Content Hosts generates bad links / no data
Keywords:
Status: CLOSED DUPLICATE of bug 1385725
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: WebUI
Version: 6.2.12
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: Unspecified
Assignee: satellite6-bugs
QA Contact: Katello QA List
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-12-10 20:35 UTC by Paul Armstrong
Modified: 2017-12-14 15:17 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-12-14 15:17:42 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)
Screen Shot of Associations tables (62.58 KB, image/png)
2017-12-10 20:35 UTC, Paul Armstrong 		no flags Details
Screen shot 2 with duplicate entries (96.98 KB, image/png)
2017-12-10 20:35 UTC, Paul Armstrong 		no flags Details
Results of basic queries (3.69 KB, text/plain)
2017-12-10 20:37 UTC, Paul Armstrong 		no flags Details
View All

Description Paul Armstrong 2017-12-10 20:35:22 UTC 
Created attachment 1365719 [details]
Screen Shot of Associations tables

Description of problem:
When systems are deployed and registered using activation keys, the key associations are not displayed correctly even though the information is accurate in the database. 


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

How reproducible:
Always.

Steps to Reproduce:
1. Create activation key and associate content and subscriptions
2. Deploy host using activation key.
3. Host is registered fine and content is activated
4. Select Activation Keys > Associations > Content Hosts.

Actual results:

Table contains the proper names of the hosts, but no detail information.
Links for content hosts are lacking IDs

katello_subscription_facet_activation_keys has the proper mapping
katello_subscription_facets points to the proper hosts in hosts table
katello_systems has the proper host_ids

Occasionally we well get duplicate lists doubling the count (wierd)

Expected results:
Table contains complete details
Links point to the proper hosts

Additional info:
See attached screenshots and queries from db
Comment 1 Paul Armstrong 2017-12-10 20:35:59 UTC 
Created attachment 1365720 [details]
Screen shot 2 with duplicate entries
Comment 2 Paul Armstrong 2017-12-10 20:37:16 UTC 
Created attachment 1365734 [details]
Results of basic queries

I will not touch these entries. I can run more queries if you like. This is probably enough info though...
Comment 3 Brad Buckingham 2017-12-14 15:17:42 UTC 

*** This bug has been marked as a duplicate of bug 1385725 ***
Note You need to log in before you can comment on or make changes to this bug.