Unable to convert baseline-managed cluster to image based from SDDC manager in a VI workload domain

Products

• VMware SDDC Manager

Issue/Introduction

• Attempting to reconfigure a cluster from baselines to an image-based cluster using a PowerCLI script as outlined in Transition to vSphere Lifecycle Manager (vLCM) Images using SDDC Manager fails with the following error:

  Invoke-VcfGetClusters  500: Internal server error calling GetClusters
  {"errorCode":"VCF_RUNTIME_ERROR","arguments":[],"message":"Something went wrong. Please retry or contact the 
  service provider and provide the reference token","referenceToken":"7SRAM3"}
  [Error] No vLCM baseline (VUM) managed clusters detected in connected vCenter(s).

• Example:

         

• All the pre-requisites have met as per document Prerequisites for Transitioning to vSphere Lifecycle Manager Images (VCF 5.2.2).

Environment

VMware Cloud Foundation 5.2.2

Cause

The value for the parameter 'isImageBased' is 'null' for the cluster table in the SDDC manager DB.

This is a boolean field, therefore the PowerCLI script expect it to be either true ('t') or false ('f'), but cannot handle if it is empty.

Resolution

To fix this issue, please  ensure to have a fresh backup, then take the following steps:

1. Open an SSH connection to the SDDC manager
2. Open psql and connect to the SDDC manager platform database:

   # psql -U postgres -h localhost
   
   \c platform

3. List the clusters:

   select * from cluster;

4. Review the column "is_image_based" and identify any clusters, where this field is empty or has the value ' ' (null).
5. Not down the name(s) of those cluster(s)
6. Using the names from step 5, update the table (replace <cluster_name> against the correct one(s)):

   update cluster set is_image_based='f' where name='<cluster_name>';

7. Exit psql:

   \q

8. Retry the transition process using script.