Error "Alert: Error Found: duplicate key: Uptime Status General"

Problem

During an upgrade from Uptime Infrastructure Monitor v7.3 to v7.5, you may receive an error message similar to, Alert: Error Found: duplicate key: Uptime Status General.

Solution

1. Execute the following query to get Uptime status service monitor("up.time status general" and "up.time status performance") definitions.
   

   select * from uptime.erdc_base where name like '%time St%';

2. Delete the duplicate service monitor definitions using the following query. This base_id should be identified using the first (above) query.
   

   delete from erdc_base where erdc_base_id in (<base_id>);

   Before deleting the duplicate service monitors, make sure that there are no service monitors associated with the duplicate erdc base ids. We can confirm by executing the below query:

   select * from erdc_configuration where erdc_base_id = '<erdc_base_id value we get from the first query>'

   
   

3. For such erdc_base_id value where the above query is returning empty result set we have to consider it for deletion.
4. After deleting duplicate service monitors, restart all the uptime services.