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 eu-m12-vcf.pneu. local sosrest [2197]: During handling of the above exception, another exception occurred:
mm dd Hr:min:sec eu-m12-vcf.pneu.local sosrest [2197]: Traceback (most recent call last) :
mm dd Hr:min:sec eu-m12-vcf.pneu.local sosrest [2197] :
mm dd Hr:min:sec  eu-m12-vcf.pneu.local sosrest [2197] :
mm dd Hr:min:sec eu-m12-vcf.pneu.local sosrest [2197]: framework.dbinterface.db_api. DBException: Converting from db to json failed
mm dd Hr:min:sec eu-m12-vcf.pneu.local sosrest [2197]: During handling of the above exception, another exception occurred:
mm dd Hr:min:sec eu-m12-vcf.pneu. local 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 eu-m12-vcf.pneu. local sosrest [2197] : AssertionError: Convert from db to json failed