AIP Console - Compute Snapshot - Fatal Error - Error while executing procedure - duplicate key value violates unique constraint dss_objects_pk
Purpose (problem description)
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”.
Applicable Platform or
| CAST AIP | Yes/No |
|---|---|
| 8.3.45 | ✅ |
| AIP Console | Yes/No |
|---|---|
| 1.28.3 | ✅ |
Action Plan
Create an SQL tool in tools after analysis.
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)](https://help.castsoftware.com/hc/en-us/articles/203751708-CAST-Support-Tool-CST-alias-Sherlock) [-](https://help.castsoftware.com/hc/en-us/articles/203751708-CAST-Support-Tool-CST-alias-Sherlock) [alias Sherlock](https://help.castsoftware.com/hc/en-us/articles/203751708-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
**Notes/comments**
Ticket # 44784
**Related Pages**