Author Topic: Phase property field (Read 7230 times)

atter · « **on:** January 30, 2013, 07:44:16 pm »

Hello everyone,

I'm using EA 9 Ultimate Edition to specify BPMN and UML diagrams.
I'm using the phase property of each process/activity as a version. It let me know the current version of some process. I'm also using it for extraction issues.
Therefore, i have a little problem, in some cases, when i have too many phases for the same process (too many characters i guess), the value of this field is troncated.
Can you please help me and let me know if there is any solution to my problem?
Thanks a lot

Geert Bellekens · « **Reply #1 on:** January 31, 2013, 07:43:28 pm »

On the database that field is defined as nvarchar(50), so anything larger then 50 characters would indeed be a problem.

If you are really adventurous you could change the size of that field, but that would be entirely on your own risk.

Geert

qwerty · « **Reply #2 on:** January 31, 2013, 11:03:22 pm »

Keep in mind that EA might use internal buffers at fixed length for that field. If you increase the DB size these might overflow and code/data might be corrupted. You should ask Sparx whether you can increase this size.

q.

atter · « **Reply #3 on:** January 31, 2013, 11:44:24 pm »

Thanks a lot for your help.
I will ask Sparks as you suggest, it's wiser!

I have though another question: where can i see the maximum length of all fields that i'm using in my models?
Is there any tutorial on that? I suppose all these information are stored somewhere in some XML file (or several).

Thanks again

Geert Bellekens · « **Reply #4 on:** February 01, 2013, 12:09:48 am »

EA stores the model you are working on in a database.
If you are using .eap file then you are in fact using an MS-Access database (renamed to .eap).
You can also store the EA model in a number of different DBMS's

Geert

atter · « **Reply #5 on:** February 01, 2013, 12:28:55 am »

I'm using DBMS actually to store all my models and i don't know how to retrieve these kind of information on DBMS (it's much more easier using .EAP format as XML file).
I thought that properties of the fields used in all EA models (like length or whatever) are stored as general EA propeties and don't depend on each project (.EAP or DBMS).
So for each .EAP file (project), we can customize these properties following specific project needs!

Thanks.

Geert Bellekens · « **Reply #6 on:** February 01, 2013, 01:38:38 am »

Each model is stored in a database, and the length of the fields depend on the database structure.

But if you don't know how to retrieve that kind of information then you better don't try to change it either.

Geert

qwerty · « **Reply #7 on:** February 01, 2013, 07:05:59 am »

Sparx has dedicated schemas to create the databases (EAP are copied from the default in the Sparx programs folder). You must not alter them. This way all fields have the the right size regardless which RDBMS you use.

q.

KP · « **Reply #8 on:** February 01, 2013, 10:40:49 am »

Quote

I have though another question: where can i see the maximum length of all fields that i'm using in my models?

You can find the DBMS setup scripts here: http://www.sparxsystems.com/resources/corporate/index.html#sql_scripts. They are human-readable and might have the information you're looking for.

atter · « **Reply #9 on:** February 01, 2013, 09:30:56 pm »

Thanks! It's just what i was looking for!

qwerty · « **Reply #10 on:** February 01, 2013, 11:47:51 pm »

Just a little ad: my book Inside EA has a cross reference from quite a number of GUI elements to database fields.

q.

Sparx Systems Forum

News: