When you are using the VCF Import Tool, certain guardrail messages may require you to perform a manual update to the SDDC Manager database. If you encounter any of these guardrail issues, modify the example commands to resolve the issues.

Procedure

  1. SSH to SDDC Manager as vcf.
  2. Switch to the root account. 
    su
  3. Run the command to remediate the issue for the specific guardrail.
    Replace the values in the example commands with the information for you environment.

    Guardrail

    		 Action Example Command

    vCenter version patch level could not be detected, defaulting to 00000 in SDDC Manager inventory.

    		 Update the vCenter version field in the SDDC Manager database with the correct patch level. 
    psql -h localhost -U postgres -d platform -c "update vcenter set version='8.0.3.00000-23514763' where vm_hostname='sfo-m01-vc01.sfo.rainpole.io'"

    Could not find version and build number for ESXi: {}.

    		Please update the host version field in the SDDC Manager database. 
    psql -h localhost -U postgres -d platform -c "update host set version='8.0.3-23637092' where hostname='sfo01-m01-esx01.sfo.rainpole.io'"
    Could not find vCenter VM name. Update the vCenter vmName field in the SDDC Manager database . 
    psql -h localhost -U postgres -d platform -c "update vcenter set vm_name='sfo-m01-vc01' where vm_hostname='sfo-m01-vc01.sfo.rainpole.io'"
    Could not find SDDC Manager VM name. Update the SDDC Manager Controller vmName field in the SDDC Manager database. 
    psql -h localhost -U postgres -d platform -c "update sddc_manager_controller set vm_name='sfo-vcf01' where vm_hostname='sfo-vcf01.sfo.rainpole.io'"
    Could not find IP address for SDDC Manager: {}. Update the SDDC Manager Controller vmManagementIpAddress field in the SDDC Manager database . 
    psql -h localhost -U postgres -d platform -c "update sddc_manager_controller set vm_management_ip_address='172.16.11.59' where vm_hostname='sfo-vcf01.sfo.rainpole.io'"
    Could not read datastore from VM datastore path: {}. Update the vCenter and PSC datastoreName field in the SDDC Manager database. 
    psql -h localhost -U postgres -d platform -c "update vcenter set datastore_name='sfo-m01-ds01' where vm_hostname='sfo-m01-vc01.sfo.rainpole.io'"
    Could not find datastore for VM: {}. Update the vCenter and PSC datastoreName field in the SDDC Manager database . 
    psql -h localhost -U postgres -d platform -c "update vcenter set datastore_name='sfo-m01-ds01' where vm_hostname='sfo-m01-vc01.sfo.rainpole.io'"
    Could not find gateway IP for ESXi: {}. Update the host gateway field in the SDDC Manager database . 
    psql -h localhost -U postgres -d platform -c "update host set gateway='172.16.11.1' where hostname='sfo01-m01-esx01.sfo.rainpole.io'"
    Could not find the management vmKernel for ESXi: {}. Skipping population of host management_ip_address and subnet fields. Update the management_ip_address and subnetfields in the SDDC Manager database. 
    psql -h localhost -U postgres -d platform -c "update host set management_ip_address='172.16.11.101' where hostname='sfo01-m01-esx01.sfo.rainpole.io'"

    psql -h localhost -U postgres -d platform -c "update host set subnet='255.255.255.0' where hostname='sfo01-m01-esx01.sfo.rainpole.io'"
    Could not find the vMotion vmKernel for ESXi: {}. Skipping population of host vmotion_ip_address field. Update the vmotion_ip_address field in the SDDC Manager database. 
    psql -h localhost -U postgres -d platform -c "update host set vmotion_ip_address='172.16.12.101' where hostname='sfo01-m01-esx01.sfo.rainpole.io'"
    Could not find managed object ID of ESXi: {}. Skipping population of ESXi source_id field. Update the source_id field in the SDDC Manager database. 
    psql -h localhost -U postgres -d platform -c "update host set source_id='host-25' where hostname='sfo01-m01-esx01.sfo.rainpole.io'"
    Could not find vSAN FTT configuration of cluster: {}. Update the ftt field for this cluster in the SDDC Manager database. 
    psql -h localhost -U postgres -d platform -c "update cluster set ftt='1' where name='sfo-m01-cl01'"
    Could not identify primary datastore for cluster: {}. Update the primaryDatastoreName and primaryDatastoreTypefields for the cluster in the SDDC Manager database. 
    psql -h localhost -U postgres -d platform -c "update cluster set primary_datastore_name='sfo-m01-cl01-ds-vsan01' where name='sfo-m01-cl01'"

    psql -h localhost -U postgres -d platform -c "update cluster set primary_datastore_type='VSAN' where name='sfo-m01-cl01'"
    Could not find the subdomain name from SDDC Manager hostname: {}. Update the subDomain field in dnsInfo of SystemInfo in the SDDC Manager database . 
    psql -h localhost -U postgres -d platform -c "update SystemInfo set dns_info= jsonb_set(dns_info, '{subDomain}', '"sfo.rainpole.io"', true)"
    Could not find root domain from SDDC Manager subdomain name: {}. Update the rootDomain field in dnsInfo of SystemInfo in the SDDC Manager database . 
    psql -h localhost -U postgres -d platform -c "update SystemInfo set dns_info= jsonb_set(dns_info, '{rootDomain}', '"rainpole.io"', true)"
    Could not find DNS configuration of SDDC Manager. Update the primaryDns and secondaryDns fields in dnsInfo of SystemInfo in the SDDC Manager database . 
    psql -h localhost -U postgres -d platform -c "update SystemInfo set dns_info= jsonb_set(dns_info, '{primaryDns}', '"172.16.11.4"', true)"
    Could not find NTP configuration of SDDC Manager. Update ntps field in ntpInfo of SystemInfo in the SDDC Manager database . 
    psql -h localhost -U postgres -d platform -c "update SystemInfo set ntp_info= jsonb_set(ntp_info, '{ntps}', '"ntp0.sfo.rainpole.io","ntp1.sfo.rainpole.io"', true)"
    Could not find SDDC Manager version. Verify that the /opt/vmware/vcf/version.txt file has read permissions for user vcf. Update the SDDC Manager Controller version field in the SDDC Manager database. 
    psql -h localhost -U postgres -d platform -c "update sddc_manager_controller set version='5.2.0.0-23684695'"