Messages

31

General Board / Re: Finding Triggers of AcceptEvent (Actions)

« on: November 10, 2023, 06:58:36 pm »

A shot in the dark: t_xref.behavior can have Trigger andEvent as content.

q.

Correct:

Code: [Select]

select o.Name as ActionName, tr.Name as TriggerName
from t_object o
inner join t_xref x on x.Client = o.ea_guid
and x.Behavior = 'trigger'
inner join t_object tr on tr.ea_guid = x.Description
where o.ea_guid = '<guid of the Action>'
Geert

32

Bugs and Issues / Re: How to update a bpmn diagram from Camunda 7 by importing it and keeping the link

« on: November 10, 2023, 06:26:06 pm »

Thank you very much for your reply, but I am not so proficient that I could make such a script myself. Could you give me some advice on this matter? Is there any such script that could be used for such purpose? How to run such a script (outside EA or after running)?

In that case, the best advice I can give you is to hire someone that knows how to do that.
It's not a major undertaking for an experienced EA consultant, but it will take you a lot of time if you have to figure out everything yourself.

Geert

33

Automation Interface, Add-Ins and Tools / Re: Change Stereotype for an ArchiMate 3 Element

« on: November 10, 2023, 06:24:16 pm »

As Sunshine indicates, the trick is to use StereotypeEx with the fully qualified stereotype.

So something like

Code: [Select]

myElement.SteretoypeEx = "ArchiMate3::ArchiMate_ApplicationComponent"
myElement.Update
But before you do that, check that the myElement.Type corresponds the the expected basetype for the stereotype you are setting.
Make sure to update() the element after changing the type, or EA won't be able to set the stereotype correctly

Geert

34

Bugs and Issues / Re: How to update a bpmn diagram from Camunda 7 by importing it and keeping the link

« on: November 10, 2023, 01:51:15 am »

EA will only update existing elements if you import an xmi file with recognisable (for EA) id's.

In this case that will be a challenge.

There are a few options you can take:

- Import the new version of the process (as a new process), and then use a script to move the connections to the new version
- Import the new version in a temporary package, and use a script to update the original process

Geert

35

Automation Interface, Add-Ins and Tools / Re: JScript DLGInputBox with scrollbar

« on: November 09, 2023, 09:24:25 pm »

No, I'm afraid not.

Geert

36

PCS General Board / Re: PCS performance

« on: November 09, 2023, 09:22:43 pm »

I'm not surprised. No matter how you look at it, you are still using a WAN connection to your database.

To rule out PCS as the source of the problem, you could experiment using a direct database connection instead (if you can get the infra guys to agree to open up the necesarry ports on the firewall)
I would expect the direct connection to performance the same at best, but probably worse.

The only real solution I know is to put the client application as close to the database as possible.

I have a lot of clients using either Citrix or Microsoft Terminal Services technology (Remote Desktop, AVD, WVD, whatever they call it this week)
The client is then installed in the same datacenter as the database, so as close as you can get.

It's still not as fast as a when I run tests on my laptop using a locally installed database, but usually fast enough.
My performance tests show a difference of factor 2 or 3 (so 100 seconds locally on my testmachine is 200 to 300 seconds on the production client)

Yours is a factor 20 difference (200 ms -> 4000 ms)

Another big thing is to circumvent the API as much as possible.
I recently refactored a big part of my framework to use only database queries (Repository.SQLQuery) for anything that is not writing.
This was a major improvement to the performance of my tools.

The next thing I'm working on is to use my own database connection instead of relying on Repository.SQLQuery.
Initial tests show this might improve performance with a factor 10 or more.

Geert

37

Automation Interface, Add-Ins and Tools / Re: How do you version control your scripts?

« on: November 08, 2023, 09:25:03 pm »

I'm using EA-Matic to automatically save my scripts to disk when updating them.

Then I use Github desktop to commit them.

Before EA-Matic I used a script to save all my scripts to disk. (and then Github Desktop)

You can't create submenus in the context menu. I try to only keep the most commonly used scripts available in the context menu.
And also make sure to use things like element or package groups instead of project browser group.

Geert

38

General Board / Re: Concept diagram

« on: November 07, 2023, 03:58:48 am »

I don't think there's an MDG yet to support these types of diagram, but it looks simple enough to make it yourself.

Shouldn't take more than a couple of days I guess.

Geert

39

Bugs and Issues / Re: #DB=<DBNAME># macro in SQL Search not works in EA 16.1

« on: November 06, 2023, 09:01:30 pm »

I just tried it in v16.1.1628 and it worked perfectly

Code: [Select]

SELECT p1.Package_ID, p1.Parent_ID, o1.Stereotype
FROM T_PACKAGE p1
#DB=SL3# inner join t_object o1 on o1.PDATA1=p1.Package_ID #DB=SL3#
#DB=ORACLE# inner join t_object o1 on o1.PDATA1=TO_CHAR(p1.Package_ID) #DB=ORACLE#
#DB=SQLSVR# inner join t_object o1 on o1.ea_guid = p1.ea_guid#DB=SQLSVR#
WHERE p1.Package_ID = #Package#
Did you by any chance test it in the scratch pad instead of the actual SQL Search?
Those are not the same. In the scratch pad I got the same error you mentioned.

Geert

PS. you can join t_object and t_package on the field ea_guid, which don't require any conversions.

40

Automation Interface, Add-Ins and Tools / Re: Is it possible to disable alphabetic sorting?? - blows up my autogenerated code

« on: November 04, 2023, 02:10:07 am »

Yes, if you Ctrl+Arrow UP on an attribute in the Features window, you'll get a popup message asking if you want to disable alphabetic sorting.

Geert

41

Bugs and Issues / Re: #DB=<DBNAME># macro in SQL Search not works in EA 16.1

« on: November 03, 2023, 08:39:54 am »

The manual says to use #DB=ORACLE#, not #DB=Oracle#.

These macro's tend be be case sensitive.

Geert

42

General Board / Re: MDG - QuickLink not working in EA16 after upgrading from EA13

« on: November 03, 2023, 12:09:34 am »

I have defined my own type of Stereotypes for the activities with a different shape etc.

The stereotype I defined for a activity is called: Activity - Funct & Feat

How would I update the Quicklink entry to reflect this?

Activity,,Activity,,,,,ControlFlow,,Directed,,,TRUE,,TRUE,,,0,,,,,0&#

We still have users using older version of Enterprise Architect and I would like a solution that can work on all the versions.

Thank you for your help.

Regards

I'm sorry I can't help you with that. I'm trying to erase all memories of the horrors of the quicklink CSV.

I guess you'll need to specify the fully qualified stereotype in the quicklink CSV somehow.

Geert

43

General Board / Re: Unable to drag and drop an item to the feature matrix

« on: November 01, 2023, 07:21:32 pm »

As mentioned by EA, you need to drop packages, not elements.

Geert

44

General Board / Re: Unable to drag and drop an item to the feature matrix

« on: November 01, 2023, 05:20:54 am »

Are you sure you want the feature matrix? I don't see any features (attributes or operations) in your model. There is also a relationship matrix, that is meant for elements.

Geert

45

General Board / Re: Unable to drag and drop an item to the feature matrix

« on: November 01, 2023, 05:19:36 am »

That means that nothing underneath those packages matches with the filters set on the types.

Geert