Inventory version synchronization failed in SDDC Manager UI.

Products

• VMware SDDC Manager
• VCF - MCOE - SDDC

Issue/Introduction

• Inventory version synchronization failed with: Cannot connect to vCenter FQDN of domain to complete inventory sync 

• /var/log/vmware/vcf/operationsmanager/operationsmanager.log
  • YYYY-MM-DDT0T:MM:SS ERROR [vcf_om,688b2d9009df21eda90b1db3136d9d1d,3ac8] [c.v.v.c.service.ResourceCacheService,om-exec-5] Exception thrown while loading inventory... 
java.lang.IllegalArgumentException: Invalid VMwareProductVersion format: 8.0.3 build-24674464 
        at com.vmware.evo.sddc.common.version.VMwareProductVersion.<init>(VMwareProductVersion.java:44) 
        at com.vmware.vcf.configreconciler.service.ResourceCacheService.buildHostNode(ResourceCacheService.java:851)

 

Environment

SDDC 5.2.x

Cause

The issue occurs if the ESXi host version is updated with invalid format in the SDDC database. This mismatch causes the Inventory sync updates to fail.

Resolution

Please follow the below steps to resolve:

• Take a snapshot for the SDDC Manager
• connect to database
  • psql -h localhost -U postgres -d platform
• To validate the host version
  • select id, hostname, version from host;
• Update the right format and version by below command
  • update host set version='8.0.3-xxxxxxxx' where hostname='%<esxi-hostname>%';     (Note: there is no "build" keyword to be mentioned, only numbers has to be entered. Example- 8.0.3-xxxxxxx)
  • \q to exit from database
• Inventory sync was successful