Page History

Problem

During an upgrade from Uptime Infrastructure Monitor v7.3 to v7.5, you may get receive an error message like: "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.
   

   Code Block
   language sql
   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.
   

   Code Block
   language sql
   delete from erdc_base where erdc_base_id in (<base_id>)

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

   ;

   NOTE:

   Info
   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: Code Block language sql 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.