SDDC UI fails to load Workload Domains Inventory Summary with error : Utilization details are not available

Products

• VMware SDDC Manager

Issue/Introduction

SDDC UI fails to load Workload Domains Inventory Summary with error : Utilization details are not available

Metrics like CPU Usage/Memory Usage will be blank.

In some cases, there will be another warning banner regarding : "The scheduled auto-rotate workflow could not run due to another operation blocking the resources"

Cause

This issue can happen when failed tasks set the vCenter to ERROR state in platform DB.

Resolution

To resolve this issue, please follow the steps below.

 

Take Snapshot of SDDC manager.

SSH to SDDC and run the below query.

psql -h localhost -U postgres -d platform -c "\x" -c "select * from vcenter;"

Sample :

Now run the below query to get the failed password rotation tasks:

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';"

Sample :

As we can see there are failed tasks, and we need to remove these. Follow the steps below to remove the failed tasks.

• Connect to the SDDC UI
• Click on Developer Center > API Explorer > APIs for Managing Credentials
• Go to DELETE/v1/credentials/tasks/{id}
• Paste the id xxxxxxxx-xxxx-xxxx-xxxx- ----> identified from the step above.
• Click EXECUTE

 

Once done, check the platform db to check if the vCenter status is set to ACTIVE.

psql -h localhost -U postgres -d platform -c "\x" -c "select * from vcenter;"

Sample :

If the status is set to ERROR, then run the below query to manually update the status to ACTIVE.

psql -h localhost -U postgres -d platform -c "UPDATE vcenter SET status = ACTIVE WHERE id = ID;"

Once done, restart the services 

/opt/vmware/vcf/operationsmanager/scripts/cli/sddcmanager_restart_services.sh

Try to login and the UI should load the inventory details.