Purpose
This page describes about the method to find duplicate object GUIDs
Applicable in CAST Version
Release | Yes/No |
---|---|
8.3.x |
Details
(1) Activate AMT saving debug mode
(2) Run the following query on the KB:
select o1.OBJECT_ID as "ID of object 1" , o2.OBJECT_ID as "ID of object 2" , o1.NAME_ID as "GUID of object 1" , o2.NAME_ID as "GUID of object 2" from IN_OBJECTS o1 join IN_OBJECTS o2 on (o2.NAME_ID = o1.NAME_ID and o2.OBJECT_ID > o1.OBJECT_ID)
The rows returned by the query contain the objects having duplicated GUIDs.
In order to delete the duplicate objects in the KB use example : SQL Queries - CAST Knowledge Base - Queries on objects - How to get and delete GUID of duplicate objects in KB
Note that more diagnostic queries can be found on SQL Queries - CAST Knowledge Base - Queries on objects - How to get object GUID
Notes / Comments
Related Pages