Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - jakson

Pages: 1 [2] 3
General Board / Remember user password in EA
« on: July 31, 2015, 02:03:45 am »
After enabling User Security I can check Remember UserID checkbox. I want to remember user password as well.
Is this possible? (EA v11 + MySQL 5.6)

General Board / ODBC error while Project Integrity Check
« on: July 30, 2015, 05:25:21 pm »
I'm porting EA database from MySQL 4.1.11 into 5.6.25.
After 2 hours run of Project Integrity Check I've got MySQL ODBC 5.3(w) Driver error:

Illegal mix of collations (utf8_general_ci) and (latin1_swedish_ci) for operation UNION

I can't do proper Project Integrity Check with this error?
How to get rid of this ODBC error?

General Board / Project integrity check - How many passes?
« on: July 08, 2015, 09:52:09 pm »
How many times should I do Project integrity check to get rid of all orphaned objects / elements?

"No problems found" (and no orphaned objects) shows after fifth pass.
Is it normal?

Why first pass of Project integrity check can't find all orphaned objects?

General Board / What MySQL grants (on what table) for EA users?
« on: July 08, 2015, 09:10:25 pm »
I'm preparing to do properly the following:
1. migrate EA database from MySQL 4.x to MySQL 5.6.x (InnoDB)
2. enabling EA security
3. create EA users and groups (with sufficient privileges)
4. create MySQL users and groups (with sufficient privileges)

What MySQL minimal privileges should I grant (on what EA tables) for:
1. EA "read-only" user
2. EA "standard" user (can modify packages/objects/elements)

General Board / How to know if and who deleted class or attribute?
« on: July 09, 2015, 07:07:41 pm »
How to know what user deleted any EA element (class, attribute, ...)?

Use Auditing Settings (I don't know how to set it) or something else?

General Board / Can't change stereotype "Message" into "message"
« on: March 06, 2015, 05:08:30 am »
I create new Class-element on a diagram and type "message" in stereotype field. After pressing "OK" the stereotype filed changes its contens into "Message" (first letter from lower to upper case).
When I dropdown stereotype combobox I can see "Message" and "message" items.

How to set / change element stereotype into "message"?
Where can I find (and edit) stereotypes popup list?

General Board / Painless transition from EA 9.2 to EA 11
« on: January 28, 2015, 06:04:29 pm »
We are using Enterprise Architect 9.2 (9.2.921.23) on MySQL v4.1.11
and want to smoothly migrate to Enterprise Architect 11 (11.1.1113.5) (first step) and MySQL v5.6.x (latter step).

Are there any "migration" issues I need to know about?

General Board / XMI file as read-only database (SQL access)?
« on: December 09, 2014, 12:55:06 am »
Is there any way to use XMI file as database
and then read form it with SQL queries?

I have to generate some documents from EA package
and it's much easier to do it through SQL than parsing XMI file.

General Board / Re: tags appeared after EA database export+import
« on: December 01, 2014, 10:10:32 pm »
Tagged values are applied to elements by means of stereotypes. Looking through the BPMN profiles, I see that BPMN 1.0 had a class stereotype "Message" which applied the tagged values "From" and "To". Presumably, when you imported your database, EA found a class with the "Message" stereotype and decided to add its associated tagged values. To prevent this happening, disable the BPMN 1.0 technology and re-import.

I think this is it:
'From=' and 'To=' tags has appeared only in objects (Classes) with Stereotype = 'Message'

I already managed with that problem in SQL-way:
Code: [Select]
DELETE ea_obp.*
FROM t_objectproperties as ea_obp
WHERE ea_obp.Property IN ('From', 'To');

I know that it is not "pretty" (messing directly on database, omitting EA client), but could it do any damages to EA (objects, diagrams, ... in EA)?
Should I revert my SQL-changes, uncheck BPMN Technology (1.0) and export/import database?
What about BPMN Technology v1.1 and v2.0?

General Board / Re: tags appeared after EA database export+import
« on: November 27, 2014, 07:14:24 pm »
You should use Tools/Data Management/Project Transfer.
It's not the solution I was looking for -
- I want to create EA database backup (as SQL file) everyday (at about 23:50)
and restore it when necessary (to main/origin database or rather to readonly database with -date/time suffix).

I've found that tags appeared in objects that have BPMN section in properties - when there wasn't BPMN in properties tagged values didn't appear.
Hm... I've never used BPMN or tags - how to get rid of it (automatically)?

General Board / tags appeared after EA database export+import
« on: November 26, 2014, 09:15:43 pm »
I'm trying to move EA database to another MySQL server - that is my main purpose.

EA version: 9.2.921 (Corporate Edition)
MySQL "source" server version: 4.1.11
MySQL "destination" server version: 4.1.22
(our EA doesn't work on MySQL 5.x)

In HeidiSQL (MySQL front-end tool) I export EA database to one large SQL file,
then I replace all "TYPE BTREE" in SQL file to "USING BTREE",
than I import it on "destination" MySQL server (using HeidiSQL).

Everything seems to be OK, but there is something wrong:
- on the bottom of several EA Class-objects appeared "tags" section with 2 tags:
"From ="
"To ="

I didn't use tagged values in my models/elements before exporting it do SQL file.

How to get rid of these tagged values?
- or -
How to export and import EA database properly?

General Board / Re: Default Diagram / Model for local user
« on: September 17, 2014, 05:06:33 pm »
Thanks for your comprehensive answer. It's strange, that I have to enable security to "personalize" default diagram on EA startup.
Unfortunately we have security disabled - I'll try to enable security and set appropriate permissions. Hope it doesn't take much time :)

General Board / Re: Default Diagram / Model for local user
« on: September 16, 2014, 07:11:38 pm »
Open the diagram and go to
Diagram|Advanced|Make user default

I have this option but it's disabled/grayed and don't know how to enable it :/

General Board / Re: Default Diagram / Model for local user
« on: September 16, 2014, 06:48:49 pm »
I don't know if that had been introduced in 9.2 already, but if so look into View/Model Views.
View/Model Views is already in EA 9.2, but it's not what I'm looking for.
I want EA to load particular diagram (+ go to the appropriate "branch") on startup, but I don't want to change other useres setting.

General Board / Default Diagram / Model for local user
« on: September 16, 2014, 06:10:35 pm »
We have EA 9.2 Corporate + MySQL database (ODBC).
Setting the Default Diagram
Diagram | Advanced | Make Model Default
makes it default or all users (global).

Is there any way to set the default diagram for each user (local)?

EA is connected (on each machine/computer) to MySQL database
through ODBC with the same settings (also same db user + password).
Should I create different users on database?

Pages: 1 [2] 3