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

 

 

CAST AIP

Yes/No

8.3.45  (tick)

 

AIP Console

Yes/No

1.28.3  (tick)

 

 

  1. Create an SQL tool in tools after analysis.
  2. 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

     

  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

Comments

Powered by Zendesk