Aria Suite Lifecycle 8.18 fails to load Environment details and shows a yellow warning (!) symbol

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

vmware-vrlcm.log - 

The below entries indicate corruption in multiple request IDs in vm_rs_request table due to which environment fetch fails with a "NullPointerException".

YYYY-HH-TTT######Z INFO vrlcm[1377] [http-nio-8080-exec-9] [c.v.v.l.u.RestHelper]  -- GET http://localhost:8080/lcm/request/api/requests/xxxxxxxxxxxxxxxxxxxxxxxx: 200 null
YYYY-HH-TTT######Z INFO vrlcm[1377] [http-nio-8080-exec-9] [c.v.v.l.l.u.SettingsHelper]  -- State of the request is: INPROGRESS
YYYY-HH-TTT######Z INFO vrlcm[1377] [http-nio-8080-exec-9] [c.v.v.l.l.u.SettingsHelper]  -- Sleeping for 500 ms and iteration count : 3
YYYY-HH-TTT######Z WARN vrlcm[1377] [http-nio-8080-exec-4] [o.h.e.j.s.SqlExceptionHelper]  -- SQL Error: 0, SQLState: XX001
YYYY-HH-TTT######Z ERROR vrlcm[1377] [http-nio-8080-exec-4] [o.h.e.j.s.SqlExceptionHelper]  -- ERROR: missing chunk number 0 for toast value xxxxx in pg_toast_xxxx
YYYY-HH-TTT######Z ERROR vrlcm[1377] [http-nio-8080-exec-4] [c.v.v.l.r.c.RequestController]  -- Exception while getting request details :
org.springframework.orm.jpa.JpaSystemException: could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet

.........................................  at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx
-5.3.42.jar!/:5.3.42]
        ... 206 more
Caused by: org.postgresql.util.PSQLException: ERROR: missing chunk number 0 for toast value xxxx in pg_toast_xxxx

YYYY-HH-TTT######Z ERROR vrlcm[1377] [http-nio-8080-exec-4] [c.v.v.l.l.c.EnvironmentController]  -- Exception while getting all Environment :
java.lang.NullPointerException: null

pg_dump -U postgres -h localhost -d vrlcm -c -Fp -v -f /dev/null fails with below error:

error: Dumping the contents of table "vm_rs_request" failed: PQgetResult() failed.
pg_dump: error: Error message from server: ERROR:  missing chunk number 0 for toast value xxxxx in pg_toast_xxxxx
pg_dump: error: The command was: COPY public.vm_rs_request (vmid, createdby, createdon, lastmodifiedby, lastupdatedon, tenant, version, vrn, errorcause, executionid, executionpath, executionstatus, inputmap, iscancelenabled, outputmap, requestname, requestreason, requestsource, requestsourcetype, requesttype, resultset, state) TO stdout;

Environment

Aria Suite Lifecycle 8.18

Cause

This happens due to the corruption on 'vm_rs_request' or any other table due to partition extension, database file movement etc.

Resolution

Check the table 'vm_rs_request' for corruption. Please open a case with Broadcom Support to review the database.

If a snapshot/clone/backup is not present for Aria Suite Lifecycle and the extent of corruption is unfixable, redeploy Aria Suite Lifecycle and import the products again.