SDDC Manager precheck fails with error, "Failed to find product type for id ###"

Products

• VMware Cloud Foundation 5.x

Issue/Introduction

Receive a similar precheck error in the SDDC Manager UI.

A similar error is observed in the lcm-debug.log on the SDDC Manager. 

/var/log/vmware/vcf/lcm/lcm-debug.log

####-##-##T##:##:##.###+0000 ERROR [vcf_lcm,5cbc9a5895f979c7,2ada] [c.v.v.c.c.i.v.model.VvsProductIdMap,http-nio-127.0.0.1-7400-exec-6] Product type not found for id ###
####-##-##T##:##:##.###+0000 ERROR [vcf_lcm,5cbc9a5895f979c7,2ada] [c.v.v.c.v.i.CompatibilityControllerAggregator,http-nio-127.0.0.1-7400-exec-6] Failed to get aggregated compatibility validation from controller VvsCompatibilityController
com.vmware.vcf.compatibility.controllers.internal.vvs.exception.VvsException: Failed to find product type for id ###
        at com.vmware.vcf.compatibility.controllers.internal.vvs.model.VvsProductIdMap.getProductTypeForProductId(VvsProductIdMap.java:66)
        at com.vmware.vcf.compatibility.translators.internal.vvs.VvsControllerTranslator.lambda$getInteropProductsForRelease$7(VvsControllerTranslator.java:433)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)

Environment

VMware Cloud Foundation 5.x
VMware Cloud Foundation 9.x

Cause

The NSX Advanced Load Balancer is only supported in SDDC Manager 5.2 or greater. 
The HCX Bundle is only supported in SDDC Manager 9.0 or greater. 

Resolution

Upgrade SDDC to 5.2 before uploading the NSX Advanced Load Balancer bundle.
Upgrade SDDC to 9.0 before uploading the HCX bundle.


Workaround:

1. Take a snapshot of the SDDC Manager VM. 

2. SSH into the SDDC VM and elevate to root.

3. Disable Depot polling if environment is connected to the internet/depot.

a. Edit the application-prod.properties file

vi /opt/vmware/vcf/lcm/lcm-app/conf/application-prod.properties

b. Set lcm.core.enableVmwareCompatibilityDataPolling to false.

example: lcm.core.enableVmwareCompatibilityDataPolling=false

c. Cycle the lcm service for the change to take effect. 

systemctl restart lcm

4. Create a copy of the VVS data json.

cp /nfs/vmware/vcf/nfs-mount/compatibility/VmwareCompatibilityData.json /nfs/vmware/vcf/nfs-mount/compatibility/VmwareCompatibilityData.json-bkp

5. Remove the NSX Advanced Load Balancer or HCX data from the VVS data. (Update the .productId with the ID in the SDDC Manager UI or lcm-debug.log)

jq 'walk(if type == "object" and .productId == xxx then empty else . end)'  /nfs/vmware/vcf/nfs-mount/compatibility/VmwareCompatibilityData.json-bkp >  /nfs/vmware/vcf/nfs-mount/compatibility/VmwareCompatibilityData.json

Example:

jq 'walk(if type == "object" and .productId == 660 then empty else . end)'  /nfs/vmware/vcf/nfs-mount/compatibility/VmwareCompatibilityData.json-bkp >  /nfs/vmware/vcf/nfs-mount/compatibility/VmwareCompatibilityData.json

6. After successfully upgrading SDDC Manager  enable the VmwareCompatibilityDataPolling 

a. Edit the application-prod.properties file

vi /opt/vmware/vcf/lcm/lcm-app/conf/application-prod.properties

b. Set lcm.core.enableVmwareCompatibilityDataPolling to true.

example: lcm.core.enableVmwareCompatibilityDataPolling=true

c. Cycle the lcm service for the change to take effect. 

systemctl restart lcm

 

Additional Information

5.2 Release notes.