Find Orphans has wrong results (build 1528)

[vladap]

Dear Community,

I am now facing a strange problem. If I go to Find Orphans options I received many results , where Objects actually exists in the Diagram.
If I right click these results , the Diagrams are listed and I can go there and see my Object in the Diagram. But still this Object is marked as Orpahant.

So I wrote my own Find Orphans select

Code: [Select]

SELECT obj.Name,obj.Object_ID, dia.Diagram_ID FROM
t_object obj left join t_diagramobjects dia on obj.Object_ID=dia.Object_ID
where obj.Object_Type != 'Package' and dia.Diagram_ID is NULL
order by dia.Diagram_ID;
and same results. If I go to the t_diagramobjects table , I can´t find these object (thats why we have these results)  But somewhere this information exist, if CTR+U find these diagrams (what is the key here? )

thanks for any tips, We have 1700 Orphans and false Orphans in our model and we would like to clean it somehow

thanks,
Vladimír

[Geert Bellekens]

Execute a project integrity check and test again.
This might just solve this problem.

Geert

[vladap]

thanks, for the Advice, I tried that and Ingegrity check is ok. Still around 17k worng results

[Geert Bellekens]

The only way an element can be shown on a diagram, is because there is a record of it in t_diagramobjects.

No record means no element on a diagram. There must be something else going on.

Geert

[vladap]

Yeah , that was my knowledge so far too . But in this case no record in that t_diagramobjects table , but  pressing CTR+U finds it in diagrams and it is really there.
I will think about it during christmas , maybe I will figure it out and bring answer here

[qwerty]

These might be classified object. I was puzzled by that once too.

q.

[Geert Bellekens]

These might be classified object. I was puzzled by that once too.

q.

Yep, probably this; well spotted.
The Ctrl-U dialog indicates whether it is used as classifier, or as link.

Geert

[vladap]

Guys you are probably right, the objects which are wrongly represented as Orphants for me are (ctrl+U) Usage Type - Classifier .
But I still dont know how to clean all findings except these  

[Eve]

As already established, all that search tells you is that the object doesn't appear on any diagrams.

I wouldn't recommend any wholesale deleting of those results. There are many other ways that they can be referenced. Aside from classifiers which were already mentioned, relationships, tagged values.

A starting point for determining if they have any use would be selecting each and then using the traceability window.

[vladap]

ahh ok, so far I lived in the idea, that cleaning unused diagram is easy steph with Finding all Orpahns and delete them, no I understand its more complicated, thanks