Cleanup stale tasks after SDDC Manager recovery.

Products

• VMware SDDC Manager

Issue/Introduction

After SDDC manager recovery from backup, bundle related tasks in the taskbar are shown as "Fetching subtask info" with "In progress" state and never change.

Reference Screenshot :

In some cases no task would be running. Though we will see few tasks in the running state under Task status.

Reference Screenshot :

Environment

SDDC Manager 5.2.1.2

Resolution

1. Upload clean_tasks.sh on SDDC manager appliance
2. Navigate to location where the script is and execute 'chmod +x clean_tasks.sh'
3. Connect to SDDC Manager as the root user, first, log in via SSH as the vcf user. Then, switch to the root user using the su - command
4. Execute script 'clean_tasks.sh' as root user.

NOTE: At the location where the script is you can find the table backup file.
If the script execution is successful this file is no longer needed and can be deleted.

Additional Information

If you see the below entries, follow KB : https://knowledge.broadcom.com/external/article/366949

mm dd Hr:min:sec ##-###-###.####.##### sosrest [2197]: During handling of the above exception, another exception occurred:
mm dd Hr:min:sec ##-###-###.####.##### sosrest [2197]: Traceback (most recent call last) :
mm dd Hr:min:sec ##-###-###.####.##### sosrest [2197] :
mm dd Hr:min:sec ##-###-###.####.##### sosrest [2197] :
mm dd Hr:min:sec ##-###-###.####.##### sosrest [2197]: framework.dbinterface.db_api. DBException: Converting from db to json failed
mm dd Hr:min:sec ##-###-###.####.##### sosrest [2197]: During handling of the above exception, another exception occurred:
mm dd Hr:min:sec ##-###-###.####.##### sosrest [2197]: Traceback (most recent call last) :
File "sosapi/controllers/statusapi2.py", line 72, in sos_status
File "framework/workflowhandler.py", line 129, in get_workflow_status
mm dd Hr:min:sec ##-###-###.####.##### sosrest [2197] : AssertionError: Convert from db to json failed