LCM Precheck workflow fails with error “Http failure response for https://SDDC_MANAGER_FQDN/ui/api/v1/system/check-sets/queries: 500 Internal Server Error"

Products

• VMware Cloud Foundation

Issue/Introduction

• Running a pre-check on any WLD with any target version in VCF 5.0 fails with "Http failure response for https://<sddc-manager>/ui/api/v1/system/check-sets/queries: 500 Internal Server Error"

From the logs, /var/log/vmware/vcf/operationsmanager/operationsmanager.log

ERROR [vcf_om,1add1c9aebf34c74,a1c0] [o.a.c.c.C.[.[.[.[dispatcherServlet],http-nio-127.0.0.1-7300-exec-10] Servlet.service() for servlet [dispatcherServlet] in context with path [/operationsmanager] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root cause
java.lang.NullPointerException: null
at com.vmware.vcf.baseliner.input.provider.handler.InternalMixedDatasourceHandler.lambda$getVdsData$4(InternalMixedDatasourceHandler.java:197)

Environment

VCF 5.0
VCF 5.1.0

Cause

VDS entries with empty is_used_by_nsxt field in the SDDC Manager inventory

Resolution

The issue is resolved in VCF 5.1.1

Workaround:

Please follow the steps mentioned below:

1. SSH into the SDDC Manager virtual machine and elevate to root
   
   
2. Back up the VDS table.
   
pg_dump --data-only -U postgres -d platform -t vds -h localhost > backup_vds.sql
   
   
3. Identify which VDS has a null value set for the is_used_by_nsxt.
   
psql -h localhost -U postgres -d platform -c "select id, name from vds where is_used_by_nsxt is null;"

Example:
psql -h localhost -U postgres -d platform -c "select id, name from vds where is_used_by_nsxt is null;"
                  id                  |         name
--------------------------------------+----------------------
 7ffbe445-####-####-####-############ | SDDC-Dswitch-Private
   
   
4. Set the empty is_used_by_nsxt fields to 't' or 'f' depending on whether the respective vds uses NSX.
   
   psql -h localhost -U postgres -d platform -c "update vds set is_used_by_nsxt='f' where id='<vds-id>';"

Example:
psql -h localhost -U postgres -d platform -c "update vds set is_used_by_nsxt='f' where id='7ffbe445-####-####-####-############';"
UPDATE 1
   
   
5. Retry the LCM Precheck.