Failed to fetch inventory details . The system may not behave in an expected manner. Reload the SDDC Manager UI by clicking the Refresh icon on your browser. If the problem persists, contact VMWare support

Products

• VMware SDDC Manager

Issue/Introduction

• Accessing SDDC UI is resulting in error - Failed to fetch inventory details  The system may not behave in an expected manner. Reload the SDDC Manager UI by clicking the Refresh icon on your browser. If the problem persists, contact VMWare support.
• Operations Manager service is down.

curl -X GET http://localhost/inventory/vcfservices | json_pp

[
   {
      "description" : "Platform services",
      "id" : "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
      "name" : "COMMON_SERVICES",
      "serviceUrl" : "http://localhost/commonsvcs",
      "status" : "ACTIVE",
      "version" : "5.2.1-24680353"
   },
   {
      "description" : "Domain Manager",
      "id" : "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
      "name" : "DOMAIN_MANAGER",
      "serviceUrl" : "http://127.0.0.1/domainmanager",
      "status" : "ACTIVE",
      "version" : "5.2.1-24680353"
   },
   {
      "description" : "Sddc Manager UI App",
      "id" : "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
      "name" : "SDDC_MANAGER_UI",
      "serviceUrl" : "http://127.0.0.1/sddc-manager-ui-app",
      "status" : "ACTIVE",
      "version" : "5.2.1-24680354"
   },
   {
      "description" : "Operations Manager",
      "id" : "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
      "name" : "OPERATIONS_MANAGER",
      "serviceUrl" : "http://127.0.0.1/operationsmanager",
      "status" : "ERROR",
      "version" : "5.2.1-24680353"
   },

 

• /var/log/vmware/vcf/operationsmanager/operationsmanager.log
   
  xxxx-xx-xxTxx:xx:xx.xxx+0000 INFO  [vcf_om,0000000000000000,0000] [c.v.e.s.c.c.l.l.LogLayoutWithHeader,main] THIS LOG FILE IS MANAGED BY SDDC MANAGER
xxxx-xx-xxTxx:xx:xx.xxx+0000 DEBUG [vcf_om,692ef33acde1201b20046a83aa161820,f8b1] [c.v.v.p.v.u.ValidateCredentialsTranslationTaskExecutor,om-exec-1] Exception occurred during validate credentials translation task : Error creating bean with name 'spring.cache-org.springframework.boot.autoconfigure.cache.CacheProperties': Could not bind properties to 'CacheProperties' : prefix=spring.cache, ignoreInvalidFields=false, ignoreUnknownFields=true

 

• /var/log/postgres/postgresql-yyyy-mm-dd.log

could not execute statement [ERROR: value too long for type character varying(255)] [update passwordmanager.master_password_transaction set credential_type=?,diagnostic_message=?,entity_id=?,entity_name=?,entity_type=?new_password=?,old_password=?,service_id=?,service_type=?,target_type=?,transaction_status=?,update_stage=?,user_name=?,workflow_id=? Where transaction_id=?];

Environment

SDDC Manager 5.2

Cause

Inconsistency in passwordmanager.master_password_transaction table 

Resolution

1. Take snapshot of SDDC Manager VM.

     2. Truncate the passwordmanager.master_password_transaction table by executing below command

psql -U postgres -h localhost -d operationsmanager
TRUNCATE passwordmanager.master_password_transaction CASCADE;

     3. Reboot the SDDC manager and the UI is now running.