Missing Data Types in Enterprise Architect

If you've used Sparx System's EA, you might know that its a quirky little program at times. I've come to love the power it gives me to document designs and interactions, even if I've had to give myself a crash course on UML just to get my head around it.

One thing I hate though is that sometimes things just don't work and its not obvious why its not working. When trying to create a Data Modeling Diagram to display the database objects involved in a proposed update, I found that the Data Types selection for my columns was empty: all the entries were missing. I was getting really frustrated until I checked on the table entity itself and found that Database for this table was not set. Once I changed to SQL Server 2000, my Data Type drop downs populated with the correct values.

In short, if you're using EA for a database diagram and your data type selections are blank, you need to check the database setting on the table itself.



Chris McKay's Gravatar Thanks mate, saved me a few hours!
TBC's Gravatar Ah I was lookin' for that!
Thanks, still don't know how i missed it :)
Péter's Gravatar Thanks man!
Jon Hartmann's Gravatar @Chris, TBC, and Peter: Glad I could be of help. EA is awesome, but its easily to get tripped up on something like this.
Thank's Gravatar thank you!
Alb's Gravatar Thank you very much.
I didnt remember that issue, and I was spining like a hamster...

Very usefull help!
Atul Kumar's Gravatar Thanks Buddy.It helped me.
Dan's Gravatar Thanks, this was driving me mad.
Joël's Gravatar Thanks! That saved me a lot of time.
Jen's Gravatar Thank u so much!
Jon Hartmann, July 2011

I'm Jon Hartmann and I'm a Javascript fanatic, UX/UI evangelist and former ColdFusion master. I blog about mysterious error messages, user interface design questions, and all things baffling and irksome about programming for the web.

Learn more about me.

Post a job. Find one. authenticjobs.com

Interested in becoming a sponsor? Contact me.