VMware SDDC Manager Workload Domain greyed out > ProVirtualzone

In this VMware SDDC Manager Workload Domain greyed out a quick tip I will explain how to fix this issue.

When you try to do any task in your SDDC Manager, like create a new Workload Domain, or add a Commission Hosts, etc., all the options are greyed out and with the message “Disable due to deployment lock”. This should be a standard message if the SDDC is running a task, but if nothing is running and you wait some time, and the option is not back to enable state, then we have a problem.

There was a task running that left SDDC locked and was never finished or appropriately canceled. In that case, we need to double-check what task is locking the SDDC Manager and delete it.

First, we need to check the SDDC database and the task. To do that, login to your SDDC ssh console with vcf account and just run the following command with the root user: psql –host=localhost -U postgres -d platform -c “select * from lock”

Note: Use the root account to run the command.


root@sddcm01 [ ~ ]#
vcf@sddcm01 [ ~ ]$ su -
Password:
root@vcf-01-m01-sddcm01 [ ~ ]# psql --host=localhost -U postgres -d platform -c "select * from lock"
id | creation_time | modification_time | error | locking_context | resource_id | resource_type | status
--------------------------------------+---------------+-------------------+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------------+--------
ae6fe331-65f6-4d1a-b614-2b4f1b0e4a30 | 1664047850838 | 1664047850838 | | {"serviceIdentifier":"OTHER","description":"Password management operation in progress. Please wait for completion","pollingInterval":0,"expirationTime":0} | | deployment | ACTIVE
(1 row)

root@sddcm01 [ ~ ]#

vcf@sddcm01 [ ~ ]$ su -

Password:

root@vcf-01-m01-sddcm01 [ ~ ]# psql --host=localhost -U postgres -d platform -c "select * from lock"

--------------------------------------+---------------+-------------------+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------------+--------

ae6fe331-65f6-4d1a-b614-2b4f1b0e4a30 | 1664047850838 | 1664047850838 | | {"serviceIdentifier":"OTHER","description":"Password management operation in progress. Please wait for completion","pollingInterval":0,"expirationTime":0} | | deployment | ACTIVE

(1 row)

As we can see in the above information task, the process was a password change that got stuck and was never appropriately deleted by the SDDC.

So now we need to delete the task using the id shown in the previous command.


root@sddcm01 [ ~ ]# psql --host=localhost -U postgres -d platform -c "delete from lock where id='ae6fe331-65f6-4d1a-b614-2b4f1b0e4a30'"
DELETE 1

root@sddcm01 [ ~ ]# psql --host=localhost -U postgres -d platform -c "delete from lock where id='ae6fe331-65f6-4d1a-b614-2b4f1b0e4a30'"

DELETE 1

After I checked if any process was still locked, the command returned empty.


root@sddcm01 [ ~ ]#
root@sddcm01 [ ~ ]# psql --host=localhost -U postgres -d platform -c "select * from lock"
id | creation_time | modification_time | error | locking_context | resource_id | resource_type | status
----+---------------+-------------------+-------+-----------------+-------------+---------------+--------
(0 rows)
root@sddcm01 [ ~ ]#

root@sddcm01 [ ~ ]#

root@sddcm01 [ ~ ]# psql --host=localhost -U postgres -d platform -c "select * from lock"

----+---------------+-------------------+-------+-----------------+-------------+---------------+--------

(0 rows)

root@sddcm01 [ ~ ]#

Back to the SDDC Manager GUI, I checked if all the options were now available, and we see that all are ok.

Important note: If you are performing these tasks in your production environment, first do a backup of your Postgre DB and/or do a snapshot of your SDDC VM and then always double-check if you are deleting the correct process.

This is it. With this simple tip, you can release the lock on your VMware SDDC Manager.

Share this article if you think it is worth sharing. If you have any questions or comments, comment here, or contact me on Twitter.