Hide Forgot
Description of problem: pool id in exported csv file from subscriptions page is not correct. Version-Release number of selected component (if applicable): Satellite 6.9 How reproducible: 100% Steps to Reproduce: 1. Have some subscriptions 2. Content -> Subscriptions -> Export csv 3. Actual results: Pool Id Subscription Id Name Candlepin Id Organization Id Sockets Cores Start Date End Date Available Quantity Account Number Contract Number Support Level RAM Stacking Id Multi Entitlement Type Product Id Unmapped Guest Virt Only Requires Virt Who Upstream 1 1 SKU 402892827739328b0177393b783c3533 1 128 2013-04-24 04:00:00 UTC 2022-01-01 04:59:59 UTC 20 20 540155 10169621 Self-Support ES0113909 true NORMAL ES0113909 false false true true 3 2 RHEL7_Custom 402892827739328b01773a39a07f4359 1 2021-01-25 15:46:31 UTC 2049-12-01 00:00:00 UTC -1 -1 NORMAL 933447663502 false false false false 5 3 capsule 6.9 402892827739328b01773e329c1f43a0 1 2021-01-26 10:17:20 UTC 2049-12-01 00:00:00 UTC -1 -1 NORMAL 41871837336 false false false false 6 4 Sat6-CI_Red_Hat_Satellite_Tools_6_9_Composes_Satellite_Tools 402892827739328b01773e3680ef43b4 1 2021-01-26 10:21:35 UTC 2049-12-01 00:00:00 UTC -1 -1 NORMAL 565786099433 false false false false Expected results: # subscription-manager list --available | grep -e "Pool ID" -e "Subscription Name" ~~~ Subscription Name: Sat6-CI_Red_Hat_Satellite_Tools_6_9_Composes_Satellite_Tools Pool ID: 402892827739328b01773e3680ef43b4 Subscription Name: Employee SKU Pool ID: 402892827739328b0177393b783c3533 Subscription Name: RHEL7_Custom Pool ID: 402892827739328b01773a39a07f4359 Subscription Name: Employee SKU Pool ID: 402892827739328b0177393b78fa3536 ~~~ Additional info:
Created redmine issue https://projects.theforeman.org/issues/31774 from this bug
Moving this bug to POST for triage into Satellite since the upstream issue https://projects.theforeman.org/issues/31774 has been resolved.
Steps to test: 1. Deploy a Satellite 6.9 snap 14. 2. Import a subscription manifest. 3. Generate a CSV subscription report in the webUI with Content > Subscriptions > Export CSV. Expected Results: The `Pool Id` column of the report has been renamed to `Pool Id Number`. The `Candlepin Id` column of the report has been renamed `Pool Id`, and the values in that column match the corresponding `Pool ID` values in the output of `subscription-manager list --available` on a registered content host. Actual Results: From the exported CSV: ~~~ Pool Id Number Subscription Id Name Pool Id 12 4 Red Hat Enterprise Linux Server, Premium (Physical or Virtual Nodes) 8a8182ac77ca44fa0177ca614b7b36cc 23 10 Red Hat Virtualization Manager 8a8182ac77ca44fa0177ca6154d936eb 25 11 postgres_puppet_module 8a8182ac77ca44fa0177cb1f9bd1370f ~~~ Listing available subscription from a registered host: ~~~ # subscription-manager list --available | grep -e "Pool ID" -e "Subscription Name" Subscription Name: Red Hat Virtualization Manager Pool ID: 8a8182ac77ca44fa0177ca6154d936eb Subscription Name: postgres_puppet_module Pool ID: 8a8182ac77ca44fa0177cb1f9bd1370f Subscription Name: Red Hat Enterprise Linux Server, Premium (Physical or Virtual Nodes) Pool ID: 8a8182ac77ca44fa0177ca614b7b36cc ~~~ The `Pool Id` column of the report has been renamed to `Pool Id Number`. The `Candlepin Id` column of the report has been renamed `Pool ID`, and the values in that column match the corresponding values in the output of `subscription-manager list --available` on a registered content host. Verified on Satellite 6.9, snap 14.
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (Moderate: Satellite 6.9 Release), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHSA-2021:1313