Unable To Decommission Hosts in SDDC Manager due to Failed or In-progress Password Task

Product : VCF 5.2

Issue : Unable to perform decommissioning hosts in SDDC Manager, error reported "This operation is not allowed because the system lock is held by the Password Manager operation in progress. Please unselect the host to proceed further."

Error from the SDDC UI, and "Decommission Selected Hosts" tab is grayed out due to the error.

Ovserved no tasks running or failed in SDDC UI:

Resolution:

1. Take a snapshot(without memory) of SDDC Manager

2. SSH to SDDC Manager VM and change to root

3. Run the below command to view and get password operations in FAILED, In-progress and PREVALIDATION_FAILED state if any.

# psql -h localhost -U postgres -d operationsmanager -c "select workflow_id,

operation_type, transaction_status from passwordmanager.password_operations

where transaction_status='FAILED' OR

transaction_status='PREVALIDATION_FAILED';"

we can see above in screenshot, one "Failed" task reported.

4. Delete the password operation task from SDDC Manager using API Explorer

Reverify by running the command again from SDDC CLI, we can see now in below screenshot task has been successfully deleted.

Now, the tab is available to perform decommission the hosts.

Congratulations!!!