Managing snapshot in Aria lifecycle manager fails to load the snapshot with "failed to fetch snapshot information"

Products

• VMware Aria Suite

Issue/Introduction

Unable to manage the snapshot of the products. We can see the below errors in vrlcm logs.

Path: /var/log/vrlcm/vmware_vrlcm.log

  "vmid" : "1111-2222-3333-4444-5555555555",
  "transactionId" : null,
  "tenant" : "default",
  "createdBy" : "root",
  "lastModifiedBy" : "root",
  "createdOn" : Date of creation,
  "lastUpdatedOn" : Date of creation,
  "version" : "8.1.0.0",
  "vrn" : null,
  "envId" : "globalenvironment",
  "productId" : "vidm",
  "nodeIp" : "X.X.X.X",
  "tenantId" : "",
  "vcSnapshotId" : "snapshot-172451",
  "productSnapshotId" : "1111-2222-3333-4444-5555555555",
  "parentProductSnapshotId" : null,
  "withMemory" : false,
  "quiesce" : false,
  "shutdown" : true,
  "exists" : false,
  "currentSnapshot" : false,
  "snapshotPrefix" : "Name of snapshot",
  "vcSnapshotName" : "Name of snapshot",
  "snapshotGeneratedTime" : null,
  "description" : ""
}, {

2024-08-02 14:23:45.954 ERROR [http-nio-8080-exec-9] c.v.v.l.l.c.SnapshotInventoryController -  -- Exception occurred while trigger product snapshot Request : java.lang.NullPointerException

Environment

Aria lifecycle manager 8.x

Cause

There is a null entry for the snapshot generated time in the database

Resolution

1.  Take a non-memory snapshot of Aria suite lifecycle manager appliance from vCenter.
   
   
2. Login to the SSH terminal of vRLCM appliance.
   
   
3. Access the psql (database client) prompt:
   
   psql -U postgres -h localhost -d vrlcm
   
   
4. Run the below command to update snapshotGeneratedTime in the vm_snapshot_inventory table:
   
   UPDATE vm_snapshot_inventory SET snapshotgeneratedtime='time' WHERE vmid IN ('ID can be obtained from the vrlcm log');

Note: Time should be mentioned in Epoch format.

Example: UPDATE vm_snapshot_inventory SET snapshotgeneratedtime=1708993027056 WHERE vmid IN ('xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxx');