Messages

1

General Board / Re: Lock does not restrict access to custom "memo" tagged value

« on: January 27, 2025, 09:48:22 pm »

I am using EA 16.0.1605

2

General Board / Lock does not restrict access to custom "memo" tagged value

« on: January 27, 2025, 09:47:36 pm »

Please, I am facing this weird situation: I have a number of custom stereotyped elements that feature tagged values I have also defines. Some of these tagged value types are of type "memo". For a couple of such "memo" custom types, locking access to parent folder does not restrict their editing. All non-memo fields of the same elements have access restricted and other tagged values also of "memo" type are restricting access.
What have I done differently for these types, please?

3

General Board / Re: Realization link created on diagram takes more time

« on: February 21, 2024, 08:15:44 pm »

I learnt it is called 'Overrides and Implementations' dialog and it is described at https://sparxsystems.com/enterprise_architect_user_guide/16.0/modeling_fundamentals/overrideparentoperations.html
It can be disabled from ''Start > Appearance > Preferences > Preferences : Links'

4

General Board / Realization link created on diagram takes more time

« on: February 21, 2024, 07:50:47 pm »

I have a large server-hosted project, with many (500+ each) Collaborate and Requirement elements (and components and interfaces), linked by Realization. When I  drag a new Realization on a diagram (from Collab to Req elements) it takes 10+ seconds for EA to create it (like it is searching among connectors trying to resolve what methods apply - what happens when a component realizes an interface).
Is there a way to disable such searching, please?

5

Uml Process / Modeling C++ exceptions

« on: November 09, 2023, 03:21:45 am »

I thought of using Events to model C++ exceptions: an interruptible region (corresponding to C++ try) would have an "unlinked" receive event in it (corresponding to C++ catch) that out-flows into catch-body activities. BUT, events are added as links to a diagram and thus a diagram cannot hold multiple instances of a (same) event. So, different catches cannot be modeled.
I then thought of using Signal, but I cannot really differentiate between "sent"/"received" Signals (thrown/caught).

Do you have an example of how to model C++ exceptions, please?

6

General Board / Generate Documentation - cannot filter by Element Status for Report Package

« on: September 20, 2023, 11:07:52 pm »

I am trying to use "Options->Filter elements with Status" option of report/document generation.
If I do it on <<model document>> it works like a charm, but if I try on <<master document>> or <<report package>> then it does not appear to work - all elements appear in generated doc, regardless of their Status.
What am I missing, please? Thank you!
I am using EA 16.0

7

General Board / Re: [MDG] Add tagged value to operations/methods in class-like stereotype

« on: July 26, 2023, 05:55:35 pm »

Thank you, it seems to make sense but I was unable to find examples how to link this new operation stereotype into my class-stereotype

8

General Board / [MDG] Add tagged value to operations/methods in class-like stereotype

« on: July 25, 2023, 05:27:54 pm »

I am defining a new MDG stereotype starting from a class and I would like to add a tagged value to operations of this stereotype. How can I do this, please?

9

General Board / MySQL v8 transfer via Connection fails

« on: June 17, 2023, 12:35:53 am »

Hi!

We were using MySQL v5 with success (ODBC 32bit, correctly set the two options there), Transfer via Connection to local .qea worked fine. We now set up a MySQL v8 and migrated EA db there. During testing all 'regular' operations seem to work, but Transfer via Connection (from mysql server to local .qea) - with error 'All EA tables in the SOURCE repository are missing, please confirm it is an EA repository [...]'.

Any ideas, please?

PS: I observed Transfer via Native XML works fine.

10

General Board / Re: Server has gone away during creating baseline

« on: June 13, 2023, 04:48:09 pm »

Problem solved, MySQL server was configured with a too-low value for max_allowed_packet

11

General Board / Re: Server has gone away during creating baseline

« on: June 12, 2023, 11:12:33 pm »

Update: If I transfer DB locally, adding baseline works fine, so it must be a remote comm issue, I think

12

General Board / Server has gone away during creating baseline

« on: June 12, 2023, 10:59:01 pm »

Creating a new baseline is unsuccessful at the very end, with error "server has gone away". This happens on only one of the root packages, and it works just fine with others.
Exact query seems to be: "insert into t_document ('DocDate', [...]) values ([...])"
VPN connection to MySQL, this was never a problem in the past and other colleagues have the same issue only on this package.
What could it be the root cause, do you know, please?

13

General Board / Re: Sql queries extremley slow on .qea (SQLite)

« on: June 09, 2023, 06:12:56 pm »

Hoisting inner-most select worked like a charm, thank you!

14

General Board / Re: Sql queries extremley slow on .qea (SQLite)

« on: June 08, 2023, 11:28:44 pm »

I have reduces the problem to this query:
select t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE, t_object.Name
FROM (
    (((t_object as MetaObj) inner join t_objectproperties as MetaOpPhase on (MetaOpPhase.Object_ID = MetaObj.Object_ID and MetaObj.Name = 'MetaSql_#UserName#' and MetaOpPhase.Property = 'ReqPhase')) inner join t_objectproperties as MetaOpSwArchPkg on (MetaOpSwArchPkg.Object_ID = MetaObj.Object_ID and MetaOpSwArchPkg.Property = 'SwArchPkgGUID'))
    inner join t_object on (t_object.Phase = MetaOpPhase.Value))
WHERE
  t_object.Stereotype like 'SwArchNeed' AND
-- search for links of type realisation
t_object.Object_ID not in (select link.Start_Object_ID from (t_connector link inner join t_object srcNeed on srcNeed.Object_ID = link.End_Object_ID) where link.Connector_Type = 'Realisation' and
-- these are Needs from Arch package linked by realisation
(srcNeed.Stereotype in ('SwArchNeed') AND
 srcNeed.Package_ID in
  (select p.Package_ID
   from ((((((((t_package p
   left join t_package p2 on p.Parent_ID = p2.Package_ID )
   left join t_package p3 on p2.Parent_ID = p3.Package_ID )
   left join t_package p4 on p3.Parent_ID = p4.Package_ID )
   left join t_package p5 on p4.Parent_ID = p5.Package_ID )
   left join t_package p6 on p5.Parent_ID = p6.Package_ID )
   left join t_package p7 on p6.Parent_ID = p7.Package_ID )
   left join t_package p8 on p7.Parent_ID = p8.Package_ID )
   left join t_package p9 on p8.Parent_ID = p9.Package_ID )
   WHERE (p.ea_guid=MetaOpSwArchPkg.Value)
   )
)
)

If I replace MetaOpSwArchPkg.Value on last line with a fixed value like '123', then everything runs in a blink. Mind this MetaOpSwArchPkg.Value 'comes' from the very top select and it is used in the inner-most condition

15

General Board / Re: Sql queries extremley slow on .qea (SQLite)

« on: June 08, 2023, 04:40:50 pm »

Here is a typical query taking less than 1 second on remote MySQL and 45 seconds locally (qea):

select t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE, t_object.Name
FROM (
    (((t_object as MetaObj) inner join t_objectproperties as MetaOpPhase on (MetaOpPhase.Object_ID = MetaObj.Object_ID and MetaObj.Name = 'MetaSql_#UserName#' and MetaOpPhase.Property = 'ReqPhase')) inner join t_objectproperties as MetaOpSwArchPkg on (MetaOpSwArchPkg.Object_ID = MetaObj.Object_ID and MetaOpSwArchPkg.Property = 'SwArchPkgGUID'))
    inner join t_object on (t_object.Phase = MetaOpPhase.Value))
WHERE
 (t_object.Stereotype like 'SwArchConsumptionObjective' and t_object.Status not like 'Obsolete') AND

t_object.Object_ID not in (select link.End_Object_ID from (t_connector link inner join t_object srcNeed on srcNeed.Object_ID = link.Start_Object_ID) where link.Connector_Type = 'Realisation' and srcNeed.Stereotype in ('SwArchNeed', 'SwArchConsumptionObjective') AND
 srcNeed.Package_ID in
  (select p.Package_ID
   from ((((((((t_package p
   left join t_package p2 on p.Parent_ID = p2.Package_ID )
   left join t_package p3 on p2.Parent_ID = p3.Package_ID )
   left join t_package p4 on p3.Parent_ID = p4.Package_ID )
   left join t_package p5 on p4.Parent_ID = p5.Package_ID )
   left join t_package p6 on p5.Parent_ID = p6.Package_ID )
   left join t_package p7 on p6.Parent_ID = p7.Package_ID )
   left join t_package p8 on p7.Parent_ID = p8.Package_ID )
   left join t_package p9 on p8.Parent_ID = p9.Package_ID )
   WHERE (p.ea_guid=MetaOpSwArchPkg.Value or p2.ea_guid=MetaOpSwArchPkg.Value or p3.ea_guid=MetaOpSwArchPkg.Value or p4.ea_guid=MetaOpSwArchPkg.Value or p5.ea_guid=MetaOpSwArchPkg.Value or p6.ea_guid in (MetaOpSwArchPkg.Value) or p7.ea_guid in (MetaOpSwArchPkg.Value) or p8.ea_guid in (MetaOpSwArchPkg.Value) or p9.ea_guid=MetaOpSwArchPkg.Value)
   )
) AND

 t_object.Package_ID in
 (select p.Package_ID
 from ((((((((t_package p
 left join t_package p2 on p.Parent_ID = p2.Package_ID )
 left join t_package p3 on p2.Parent_ID = p3.Package_ID )
 left join t_package p4 on p3.Parent_ID = p4.Package_ID )
 left join t_package p5 on p4.Parent_ID = p5.Package_ID )
 left join t_package p6 on p5.Parent_ID = p6.Package_ID )
 left join t_package p7 on p6.Parent_ID = p7.Package_ID )
 left join t_package p8 on p7.Parent_ID = p8.Package_ID )
 left join t_package p9 on p8.Parent_ID = p9.Package_ID )
 WHERE (p.ea_guid=MetaOpSwArchPkg.Value or p2.ea_guid=MetaOpSwArchPkg.Value or p3.ea_guid=MetaOpSwArchPkg.Value or p4.ea_guid=MetaOpSwArchPkg.Value or p5.ea_guid=MetaOpSwArchPkg.Value or p6.ea_guid=MetaOpSwArchPkg.Value or p7.ea_guid=MetaOpSwArchPkg.Value or p8.ea_guid=MetaOpSwArchPkg.Value or p9.ea_guid=MetaOpSwArchPkg.Value)
 )