Manual backup via API failed and SDDC Manager UI doesn't show the inventory with "Failed to fetch inventory details"

Products

• VMware SDDC Manager

Issue/Introduction

• Backup SDDC Manager via API fail
• SDDC Manager UI shows  "Failed to fetch inventory details" popup after login GUI

vcf-commonsvcs.log
yyyy-mm-ddThh:mm:ss.xxx+0000 WARN  [common,119f4fa6778745c8,f599] [o.h.e.jdbc.spi.SqlExceptionHelper,http-nio-127.0.0.1-7100-exec-1853] SQL Error: 0, SQLState: null
yyyy-mm-ddThh:mm:ss.xxx+0000 ERROR [common,119f4fa6778745c8,f599] [o.h.e.jdbc.spi.SqlExceptionHelper,http-nio-127.0.0.1-7100-exec-1853] HikariPool-1 - Connection is not available, request timed out after 40000ms.
yyyy-mm-ddThh:mm:ss.xxx+0000 ERROR [common,604d93701f134517,e73c] [c.v.e.s.i.d.s.client.TypedClientImpl,http-nio-127.0.0.1-7100-exec-1846] Server Error
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction

Environment

VCF5.x

Cause

It cause of known issue with commonsvcs and APIs were not executed properly and a lock remains

Resolution

This is known issue on SDDC Manager.

Workaround:

Restart commonsvcs services.
# systemctl restart commonsvcs