License check: There are no assigned licenses found for this product"License check: There are no assigned licenses found for this product" is seen in SDDC Manager and upgrading the system does not resolve the issue./var/log/vmware/vcf/operationsmanager/operationsmanager.log shows errors similar to:YYYY-MM-DDTHH:MM:SS ERROR [vcf_om,3f929f###5984d9e,1##f] [c.v.v.l.s.u.ResourceLicensingPopulator,om-exec-3] License assignment not found for resource esxi01.example.local
YYYY-MM-DDTHH:MM:SS ERROR [vcf_om,3f929f###5984d9e,1##f] [c.v.v.l.s.u.ResourceLicensingPopulator,om-exec-3] License assignment not found for resource esxi02.example.local
YYYY-MM-DDTHH:MM:SS ERROR [vcf_om,3f929f###5984d9e,1##f] [c.v.v.l.s.u.ResourceLicensingPopulator,om-exec-3] License assignment not found for resource esxi03.example.local
YYYY-MM-DDTHH:MM:SS ERROR [vcf_om,3f929f###5984d9e,1##f] [c.v.v.l.s.u.ResourceLicensingPopulator,om-exec-3] License assignment not found for resource esxi04.example.localYYYY-MM-DDTHH:MM:SS ERROR [vcf_om,69a82fb9c7496######de7c809f21d3,5c12] [c.v.v.l.s.u.ResourceLicensingPopulator,pool-3-thread-18] License assignment not found for resource VCENTER02.#####.com
YYYY-MM-DDTHH:MM:SS ERROR [vcf_om,69a82fd5e#########e6f10fcfd1f,a0bf] [c.v.v.l.s.u.ResourceLicensingPopulator,om-exec-8] License assignment not found for resource VCENTER02.#####.com Inventory -> Hosts -> ALL HOSTS, the hosts are in lowercase:example.localexample.localexample.localexample.localMain menu -> Administration -> Licensing -> Licenses -> Assets -> Hosts, the hosts are in uppercase:example.localexample.localexample.localexample.localInventory->Workload Domains->Certificates, you notice upper case vCenter FQDNSDDC Manager retrieves license data from vCenter Server using the resource name. If there is a case-sensitivity mismatch (uppercase vs. lowercase) between the hostnames or vCenter FQDNs registered in the SDDC Manager database and the vSphere inventory, the license status fails to fetch. This discrepancy can block upgrade workflows
Note: The DB edits can be destructive if done incorrectly. Take snapshot of the SDDC Manager. Ref KB: Taking and restoring snapshots of the SDDC Manager appliance.
Resolve this issue by modifying the SDDC Manager PostgreSQL database to match the hostname casing.
Prerequisites:
grep -i "License assignment not found for resource" /var/log/vmware/vcf/operationsmanager/operationsmanager.log | awk '{print $11}' | sort | uniq -c | less -iN1 6 esxi01.example.local
2 3 esxi02.example.local
3 5 esxi03.example.local
4 5 esxi04.example.local
5 6 VCENTER02.#####.comFollow the steps below:
psql -U postgres -h localhost -d platformSELECT id, hostname from host;Example Output
platform=# SELECT id, hostname from host;
id | hostname
--------------------------------------+-----------------------
dbc4a6fd-ee75-##cb-####-e3735c167f5d | ESX01.example.local
select id, vm_hostname, type, status from vcenter;Example Output
platform=# SELECT id, vm_hostname, type, status from vcenter;
id | vm_hostname | type | status
--------------------------------------+---------------------+------------+--------
37840a76-e2d5-####-####-1ac777f3e33b | vcenter01.#####.com | VI | ACTIVE
a4b473b2-b28d-####-####-981e568c1d62 | VCENTER02.#####.com | MANAGEMENT | ACTIVE
(2 rows)update host set hostname='esxi01.example.local' where id='dbc4a6fd-ee75-##cb-####-e3735c167f5d';update vcenter set vm_hostname='vcenter02.#####.com' where id='a4b473b2-b28d-####-####-981e568c1d62';\q to exit the PostgreSQL prompt.For the holistic health of the environment, lowercase is the recommended case for the environment. If you find that you have mixed case hostname / FQDN in your SDDC environment it is recommended that you take the following additional steps: