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


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".





8.3.45  (tick)


AIP Console


1.28.3  (tick)



  1. Create an SQL tool in tools after analysis.
  2. Add following lines in SQL editor:

    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


  3. Run tool.
  4. 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




Have more questions? Submit a request


Powered by Zendesk