Pool-ID generated by hypervisor subscription shows incorrectly as Virtual instead of virt-who-hypervisor-pool-id In Red Hat Satellite 6

Solution Verified - Updated -

Environment

  • Red Hat Satellite 6

Issue

  • In Satellite Web-UI, under Content -> Subscription tab ESXI Pool-ID showing incorrectly as Virtual instead of virt-who-hypervisor-pool-id for VDC subscription attached to hypervisor.

Resolution

  • Check if the affected ESXI hosts is subscribed with correct VDC subscription.

    # su - postgres -c "psql -d candlepin -c 'select 
cp_consumer.name,cp_entitlement.quantity,cp_entitlement.pool_id,cp2_products.product_id,cp2_products.name,
cp_pool.contractnumber from cp_entitlement INNER JOIN cp_consumer ON (cp_entitlement.consumer_id = 
cp_consumer.id) INNER JOIN cp_pool ON (cp_entitlement.pool_id = cp_pool.id) INNER JOIN cp2_products ON 
(cp_pool.product_uuid = cp2_products.uuid) ORDER by pool_id,cp_consumer.name;'|grep -i '<SKU>

  • If, ESXI host is correctly subscribed then run below commands on Satellite server to fix the GUI issue.

    # foreman-rake console
# Katello::Pool.import_all
# exit

# foreman-rake katello:import_subscriptions

Root Cause

  • The root cause cannot be identified, But this issue can happen due to discrepancy in Database

Diagnostic Steps

  • Check the ESXI Pool-ID is showing correct or not on satellite WebUI under Content -> Subscription, It can show as "Virtual" instead of showing actual ESXI Pool-ID ( Check attached screenshot for reference).

  • Check if the affected ESXI hosts is subscribed with correct VDC subscription.

    # su - postgres -c "psql -d candlepin -c 'select 
cp_consumer.name,cp_entitlement.quantity,cp_entitlement.pool_id,cp2_products.product_id,cp2_products.name,
cp_pool.contractnumber from cp_entitlement INNER JOIN cp_consumer ON (cp_entitlement.consumer_id = 
cp_consumer.id) INNER JOIN cp_pool ON (cp_entitlement.pool_id = cp_pool.id) INNER JOIN cp2_products ON 
(cp_pool.product_uuid = cp2_products.uuid) ORDER by pool_id,cp_consumer.name;'|grep -i '<SKU>

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments