Error 'Fetching requests failed' when attempting to access Requests in Aria Suite Lifecycle

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

• After a failed product deployment from Aria Suite Lifecycle, 'Requests' page fails to load and the following message is reported:
  
  
  
  
  
• The browser's developer tools display a '404 Not Found' status code:
  
  
  
  
  
  
• In ‘/var/log/vrlcm/vmware_vrlcm.log’ on Aria Suite Lifecycle appliance, you see entries similar to:
  
  INFO vrlcm[3963] [http-nio-8080-exec-7] [c.v.v.l.c.l.MaskingPrintStream]  -- * SYSOUT/SYSERR CAPTURED:  -- com.fasterxml.jackson.core.JsonParseException: Unrecognized token 'string': was expecting (JSON String, Number, Array, Object or token 'null', 'true' or 'false')at [Source: (String)"string"; line: 1, column: 7]
INFO vrlcm[3963] [http-nio-8080-exec-7] [c.v.v.l.c.l.MaskingPrintStream]  -- * SYSOUT/SYSERR CAPTURED:  -- at com.fasterxml.jackson.core.JsonParser._constructError(JsonParser.java:2477)
INFO vrlcm[3963] [http-nio-8080-exec-7] [c.v.v.l.c.l.MaskingPrintStream]  -- * SYSOUT/SYSERR CAPTURED:  -- at com.fasterxml.jackson.core.base.ParserMinimalBase._reportError(ParserMinimalBase.java:760)

ERROR vrlcm[14962] [http-nio-8080-exec-10] [c.v.v.l.r.c.RequestController]  -- Exception while getting request details : java.lang.NullPointerException: null    
at com.vmware.vrealize.lcm.requestservice.service.RequestServiceImpl.localizeErrorCause(RequestServiceImpl.java:626) ~[vmlcm-requestservice-core-8.18.0-SNAPSHOT.jar!/:?] 
at com.vmware.vrealize.lcm.requestservice.service.RequestServiceImpl.getAllRequests(RequestServiceImpl.java:116) ~[vmlcm-requestservice-core-8.18.0-SNAPSHOT.jar!/:?]         
at com.vmware.vrealize.lcm.requestservice.service.RequestServiceImpl$$FastClassBySpringCGLIB$$4722ae0e.invoke(<generated>) ~[vmlcm-requestservice-core-8.18.0-SNAPSHOT.jar!/:?]         
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.17.RELEASE.jar!/:5.1.17.RELEASE]
  
  

Environment

Aria Suite Lifecycle 8.x

Cause

This issue occurs when 'errorcause' field for a 'lcmgenricsetting' request contains 'string' as it's value

Resolution

To resolve this issue, perform the following actions:

1. Ensure you valid backups or recent snapshots of the Aria Suite Lifecycle Manager appliance
2. SSH to Aria LCM appliance and stop the lcm service:  
   
   systemctl stop vrlcm-server
   
   
3. Establish connection to ‘vrlcm’ database:
   
   /opt/vmware/vpostgres/current/bin/psql -U postgres -d vrlcm
   
   
4. To query 'vm_rs_request' table for  'lcmgenricsetting' requests with 'errorcause' value = 'string':  
   
   select count(*) from vm_rs_request where requesttype='lcmgenricsetting' and errorcause='string';

select * from vm_rs_request where requesttype='lcmgenricsetting' and errorcause='string';
   
   
   
5. Cleanup entries identified in step.4. using the following query:
   
   delete from vm_rs_request where requesttype='lcmgenricsetting' and errorcause='string';
   
   
6. Exit the vrlcm database: 
   
   \q 
   
   
7. Start the lcm service:
   
   systemctl start vrlcm-server