AIP Console - Compute Snapshot - Fatal Error - Error while executing procedure - duplicate key value violates unique constraint dss_objects_pk

This page helps to resolve issues related to create snapshot step, when it fails with the following errors  " Error: Child task on exception
 and Error while executing Procedure, ERROR: duplicate key value violates unique constraint "dss_objects_pk".

1. Create an SQL tool in tools after analysis.
2. 

3. Add following lines in SQL editor:

   DELETE 
   FROM $(KBName).objinf obj
   WHERE obj.infval NOT IN
   (
     SELECT MIN(inf.infval)
     FROM $(KBName).objinf inf WHERE inf.inftyp = 4
     AND inf.infsubtyp = 0 and  inf.idobj = obj.idobj
   ) 
   AND obj.inftyp = 4 AND obj.infsubtyp = 0

4. Run tool.
5. Rerun snapshot without new analysis.

Relevant input

• CAST Support Tool (CST) - alias Sherlock export with the following options CAST Bases Checker, Export Logs, Export Configuration files, Export Computer Environment, Export CAST Bases with Management Base, Knowledge Base, Central base, Measurement Base  

Ticket # 44784