Skip Level Upgrade from VMware Cloud Foundation 3.7.2 fails with "Invalid VMwareProductionVersion" error

Products

• VMware Cloud Foundation

Issue/Introduction

Symptoms:

• Attempting a Skip Level Upgrade from VMware Cloud Foundation 3.7.2 fails with "Invalid VMwareProductionVersion format: 3.7.2.0-13774914\n"
• It may also fail with "Pre-validation failed with error: java.lang.IllegalArgumentException: VMwareProductVersion can not be null" error message.

Environment

VMware Cloud Foundation 3.7.x

Cause

The may either be cause by the addition of the newline character (\n) in the build version, or the version is missing for the return API response. 

Resolution

This is a known issue affect skip level upgrades from 3.7.2 only. 

Workaround:

To workaround this issue, please follow the steps below.

1. Open an SSH session to the SDDC Manager VM and change to the root user:

su -

2.  Connect to the Cassandra DB:

cqlsh --cqlversion=3.4.4

3. Run the following command:

select * from inventory.sddcmanagercontroller;

4. If the "version" field displays as empty or includes any newline character, run the below update command:

update inventory.sddc_manager_controller set version = '3.7.2-RELEASE-13773680';

5. Exit the Cassandra DB by typing quit.
6. Run below API to verify that version is updated:

curl http://localhost/inventory/sddcmanagercontrollers | json_pp

Output:
[
   {
      "hostName" : "sddc-manager.vrack.vsphere.local",
      "privateIpAddress" : "10.0.0.4",
      "version" : "3.7.2-RELEASE-13773680",
      "managementIpAddress" : "10.0.0.4",
      "domainId" : "9d2200f0-0bbc-11ea-b45b-1fa33c12aa7e",
      "vmName" : "sddc-manager",
      "id" : "9e479531-0bbc-11ea-b45b-1fa33c12aa7e",
      "status" : "ACTIVE"
   }
]