The Personality Upload task in SDDC Manager failed during an image export from the vCenter server

Products

• VMware SDDC Manager

Issue/Introduction

• Lifecycle manager fails to find the personalityUploadId in the personality table and throws an exception. 
• On SDDC Manager, in /var/log/vmware/vcf/lcm/lcm-debug.log , the below log messages are seen:
  
  YYYY-DD-HHTHH:MM:DD.###+#### DEBUG [vcf_lcm,################################,####] [c.v.v.l.r.a.c.i.InternalTaskController,http-nio-###.#.#.#-####-exec-#] Fetching the personality task for id:########-####-####-####-############
YYYY-DD-HHTHH:MM:DD.###+#### INFO  [vcf_lcm,################################,####] [c.v.v.l.a.a.ActivityLoggingInterceptor,http-nio-###.#.#.#-###-exec-#] {"username":null,"timestamp":"YYYY-DD-HHTHH:MM:DD.###Z","clientIP
":"###.#.#.#","userAgent":"Apache-HttpClient/5.3.1 (Java/17.0.12)","api":"/lcm/internal/umds/tasks/sync/########-####-####-####-############","httpMethod":"GET","httpStatus":200,"operation":"Get UMDS sync task specified
by task Id","remoteIP":"###.#.#.#","duration":0}
YYYY-DD-HHTHH:MM:DD.###+#### ERROR [vcf_lcm,################################,####] [c.v.e.s.e.h.LocalizableRuntimeExceptionHandler,http-nio-###.#.#.#-####-exec-5] [######] PERSONALITY_UPLOAD_NOT_FOUND Personality Upload
not found; uploadId: ########-####-####-####-############
com.vmware.evo.sddc.common.core.error.ResourceNotFoundException: Personality Upload not found; uploadId: ########-####-####-####-############
        at com.vmware.vcf.lcm.rest.api.controller.v1.common.ExceptionAssemblers.toRestExceptionFromLcmException(ExceptionAssemblers.java:302)
        at com.vmware.vcf.lcm.rest.api.controller.internal.InternalTaskController.getPersonalityUploadTask(InternalTaskController.java:230)
        at jdk.internal.reflect.GeneratedMethodAccessor413.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:569)
        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:255)
        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:188)

Environment

VMware Cloud Foundation 4.x
VMware Cloud Foundation 5.x
VMware Cloud Foundation 9.x

Cause

SDDC Manager fails to remove the task corresponding to the personality upload failure

Resolution

1. SSH into the SDDC Manager as the vcf user, then run su to obtain root privileges.. 
2. Copy the attached lcmTaskFixer.py script to the /home/vcf/ directory
3. Run the lcmTaskFixer.py script to cleanup the stale personality tasks, lcm upgrade tasks, and stale manifest files.
   python lcmTaskFixer.py