Upgrading SDDC Manager fails with the error: "Failure while executing SDDC Manager drift app"

Products

• VMware SDDC Manager

Issue/Introduction

• Upgrading SDDC Manager fails with the error: "Failure while executing SDDC Manager drift app"
• Reviewing the log file at /var/log/vmware/vcf/lcm/thirdparty/upgrades/########-####-####-####-########/sddcmanager-migration-app/logs/sddcmanager_migration_app_upgrade.log, the following entries were observed:

YYYY-MM-DDTHH:MM:SS.868+0000 ERROR [vcf_lcm,0000000000000000,0000] [c.v.e.s.o.model.error.ErrorFactory,pool-4-thread-18]  [AL5O1N] FETCH_DATA_FAILED Failed to fetch data - 
Tasks com.vmware.evo.sddc.orchestrator.exceptions.OrchTaskException: Failed to fetch data - Tasks at com.vmware.vcf.migration.util.RestUtils.getDataWithHeaders(RestUtils.java:142)

• When executing an API call for Tasks GET in the API center of the SDDC UI, an error message is displayed.

"errorCode":  
"FIND_RESOURCE_WARNING_BY_TASK_IDS_FAILED",
"message":  
"Failed to retrieve resource warnings associated to task IDs [########-####-####-####-##############]",
"referenceToken":  
"######",

Environment

SDDC Manager 5.2.2

Cause

Entries in the table task_and_subtask_and_resource_warning contain information regarding the status of tasks, their corresponding subtasks, and warnings.

Resolution

Workaround:

• Take a snapshot of the SDDC Manager.

• Connect to the database using the following command:
  psql --host=localhost -U postgres -d platform

• Run the command to view the data:
  select * from task_and_subtask_and_resource_warning;

• Verify that the table contains rows and matches the ID shown in the API GET call.

• Truncate the table using the command:
  truncate task_and_subtask_and_resource_warning;

• Restart the SDDC Manager upgrade task.