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

Products

• VMware Aria Suite

Issue/Introduction

• VMware Aria Suite Lifecycle should not show notifications for products patches/upgrades which are already installed.

Symptoms:

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

• Inventory sync does not resolve the issue.
• Clearing the notifications still sends new notifications after sometime on the UI. 

Environment

VMware vRealize Suite Lifecycle Manager 8.x

Cause

• This happens because there are old notifications schedules left over from earlier deleted environments on VMware Aria Suite Lifecycle, which do not show up in UI.

Resolution

• There is a workaround.

Workaround:

• The workaround is to find the notification schedules from old deleted (rogue) environment of  the VMware Aria Suite Lifecycle and delete them
• Steps below :

1. Ensure proper snapshots and the backup of the VMware Aria Suite Lifecycle appliance and database. 
2. Login to the VMware Aria Suite Lifecycle as root.
3. Navigate to its database:

su - postgres
cd /opt/vmware/vpostgres/11/bin/
./psql -d vrlcm

3. We could see from the database the old entries for environments which does not exist on UI. 

 select environmentname from vm_lcops_environment;

4. Lets say my deleted/rogue environment is  'vRealize' and notifications are coming from this environment.
5. Find out the notifications from this old deleted environment by running query: 

 select vmid from vm_engine_scheduledrequest ;

6. Delete those old notifications schedules (lets say the problematic notification schedule is 'vra,8.11.0,productPatchingNotification,vRealize'):

delete from vm_engine_scheduledrequest where vmid='vra,8.11.0,productPatchingNotification,vRealize' ;

7. Monitor the notifications on VMware Aria Suite Lifecycle UI for next 24 hours and it should not be triggered any longer.

Additional Information

Impact/Risks:

• No major impact.