Deleting Stereotypes

[JanK]

Hi Gurus,
I am working with EA7.5 using a database repository. I am trying to clean up the stereotypes, which have been created over the time. I found the UI UML Types under Settings -> UML... in the menu. From here I cannot delete a stereotype, even those which are not used in any object. What am I missing here? Are they used in any other context, which I did not figured out yet? How could I check? I found the tabel t_stereotype. What if I delete rows in this table?
Any answer is highly appreciated.
Thanks and regards
jan

[g.makulik]

Hi jan,

What exactly happens if you select a stereotype from the list in the right and press the 'Delete' button in the upper left section (I suppose you've tried this)?
For me this works even with EAs intrinsic sterotypes.

WBR
Günther

[JanK]

Hi,
nothing happens. No error, no message, just nothing. And the stereotype ist still there.
Regards
jan

[Geert Bellekens]

Just a guess, but couldn't it be that EA refuses to delete a stereotype when it is still in use?

Geert

[JanK]

Hi,
I checked and I am quite sure the stereotypes I am trying to delete is not used anymore.
Regards
jan

[Geert Bellekens]

Strange,...

I just tried that here and I can delete any stereotype I want, even the standard stereotypes like <<enumeration>>.
You wouldn't have security setup would you? I can imagine that being a problem as well.

Geert

PS. I'm on 7.5.850

[nestevao]

Same thing happens to me, in all versions and build I used for 3 years.
I'm only able to delete stereotypes never used, i.e, if a stereotype is used and afterward I remove that reference, I no longer can delete that stereotype.

Even, when I create a stereotype and I want to delete it immediately, for instance I misspelled it, sometimes I can not do it.

Other thing, if you create a stereotype with the same name of an existing one, you have problems, you're not able to delete it.

I've full administration permissions so, i don't think that's a permission issue.

[JanK]

Hi,
I set up security (sorry i did not mention before). I am working in Require User Lock mode. I am working as admin and the stereotype is not used anymore. Why isn't there any error message, if deletion is not successful?
regards
jan

[Oliver F.]

Hi,
I set up security (sorry i did not mention before). I am working in Require User Lock mode. I am working as admin and the stereotype is not used anymore. Why isn't there any error message, if deletion is not successful?
regards
jan

We live for a few years now with some stereotypes which have umlauts in their name. Those can not be deleted any more.
They came in with a transfer from a local EAP file to a SQL server storage and and I assume the database driver can not cope with those.

Oliver

[beginner]

DELETE FROM T_STEREOTYPE WHERE name = "to be deleted";

DELETE FROM T_XREF WHERE (forgot the table) LIKE "%whatever stereotype%";

The latter with caution. Use a SELECT to check what you delete.

Good luck.

b.

[KP]

I found the UI UML Types under Settings -> UML... in the menu. From here I cannot delete a stereotype, even those which are not used in any object.

I suspect that the delete command is trying to match an encoded version of either the stereotype name or the base class with an unencoded one, and these are different. Please send a bug report to Sparx support indicating the stereotype name and base class of the stereotype that you can't delete.

I found the tabel t_stereotype. What if I delete rows in this table?

Should be quite safe, I have done it myself in the past - backup your database before deleting anything though. As Beginner hints, there may also be some related information in the t_xref table. Rather than delete that, you are probably better off running Tools > Data Management > Project Integrity Check and letting that clear up any orphaned information for you.

[beginner]

Neil,
I was never sure about what that cleanup actually does. I run it from time to time and most of it, it tells me that orphaned stereotypes are being delete (and sometimes other things). Would you be able to shed a bit light on the cleanup process?

b.

[KP]

Would you be able to shed a bit light on the cleanup process?

There's not a lot to say really. I've had a look at the code and it just runs through 43 (currently) checks for inconsistent data in the database, the sort of thing that can occur if you have a powercut* in the middle of a non-atomic operation or if you delete records from a table using an SQL front-end rather than EA. It's actually more useful for Sparx's development team; for customers, I'd say the most useful part of the dialog is the progress bar.  


*We get a few out here, especially this time of year when the gum trees start drying out and dropping branches on power lines...

[Paolo F Cantoni]

[size=18]...[/size]
 for customers, I'd say the most useful part of the dialog is the progress bar.  
[size=18]...[/size]

Actually it's the [No Problems found] dialog at the end...

Seriously though, if you're developing Add-ins or "touching" stuff in the DB.  Running the checker before and after helps isolate "collateral damage".  If the checker had an extra mode that provided more information about exactly where it found problems, that would be cool...

Paolo