VCF Operations is showing alert Management Lifecycle - Product upgrade is available for products already upgraded

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

• Upgraded VCF product stack to a later version
• Sign into VCF operations → Click on Infrastructure Operations → Click on Alerts  → The alert "Management Lifecycle - Product upgrade is available" is visible → Clicking on the alert shows alert symptom similar to the below extract depending on the product and version you have upgraded to:

  The Info symptom Management Lifecycle - Product upgrade is available has been observed on Management Lifecycle
  managementLifecycle-ProductUpgradeNotification : Operations-logs 9.0.1.0 is available for environment ########-####-####-####-############

• Triggering inventory sync for the component does not resolve the issue
• The alert retriggers after 24 hours of cancelling the alert by navigating to Infrastructure Operations → Click on Alerts  → Select the alert "Management Lifecycle - Product upgrade is available" → Click on Actions → Cancel Alert

Environment

VCF Operations 9.x

VCF Automation 9.x

Fleet Management 9.x

VCF Operations for Network 9.x

VCF Operations for Logs 9.x

Cause

This issue can occur due to residual notification schedules associated with previously deleted environments in Fleet Manager. Although these legacy entries are not visible in the user interface, they may still persist in the system and impact its behaviour.

Resolution

Note: Prior to applying the steps below please take snapshot of Fleet Management as per KB How to create a snapshot for VCF Operations Fleet Manager appliance

1. Login to the Fleet Management ssh session as root

2. Access the Postgres database: su - postgres and change directory to: 

   cd /opt/vmware/vpostgres/current/bin/

3. Enter in the command: 

   ./psql -d vrlcm

4. Query the database for the alerts by running the command: 

   select environmentname from vm_lcops_environments;

5. Take note of the vmid(s) that are listed in the database and compare it with the alert you receive in the UI an example of an alert notification in the database is:

   ########-####-####-####-############,vrli,9.0.1.0,productUpgradeNotification

   or

   ########-####-####-####-############,vrops,9.0.0.0,productUpgradeNotification

6. Delete the old notifications schedules for example: 

   delete from vm_engine_scheduledrequest where vmid='########-####-####-####-############,vrli,9.0.1.0,productUpgradeNotification';

   Note: Replace ########-####-####-####-############,vrli,9.0.1.0,productUpgradeNotification with the vmid(s) you get in step 6 above.

7. Monitor for 24 hours

Additional Information

Find out the name of the ID along with the product by running the below command on the Fleet Management appliance: 

select vmid from vm_engine_scheduledrequest;

VMware Aria Suite Lifecycle keeps showing notifications for products patches/upgrades which are already installed