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 - Paolo F Cantoni

Pages: [1] 2 3 ... 394
1
Bugs and Issues / TAM - Incorrect item cloned!
« on: Today at 12:57:13 pm »
We've found what we consider a SERIOUS defect in TAM (Time Aware Modelling).

Scenario:  We have a set of current items, in diagrams in a branch versioned "Curr".

We intend to make a RoadMap branch indicating the "To Be" state.  We clone the Current Branch - which gives us new Folder structure and Diagrams (but not the items) - which is what we want; to a branch versioned "RdMp".  Since we only want to clone items that will change in the future.  We clone an item in a RdMp diagram to version "RdMp".  The item is cloned correctly; so far, so good.

As part of our on-going repository management, every year (at the end of the year) we intend to clone Current into a "Past" "snapshot" that describes the state at the end of that year; giving us the ability to "compare and contrast" over time.  So I select the Current branch and say Clone structure (in this case, to a folder structure versioned "Past").  Again, folders and diagrams cloned, no items, as desired.  This time, however, to achieve our goal of snapshotting the entire Current branch we have to clone ALL the items in the "Curr" version.  We select all the items in the diagram in "Past" diagram (which are all namespaced "Curr::") and say Clone to new version (to "Past").

Imagine our surprise when for the item in "Curr" that had been cloned to "RdMp", instead of getting a new item in "Past", we got the "RdMp" item on the "Past" diagram!  :'(

We confirmed that the original item on the Current diagram was still the "Curr" item and that that item WAS NOT CLONED into Past as a new item.  This is a defect, the original "Curr" item (on the diagram) should have been cloned, not the "RdMp" item (which was nowhere to be seen).  We also confirmed it's not a caching problem since we exited Sparx and re-entered and then cloned the structure. This needs to be fixed urgently!

Paolo

2
Thanks, Nabil,

On a related note, say I have previously cloned an item, but on another diagram, I have the original item.  If I attempt to clone that second original item on the second diagram (to the same version as the existing clone), will EA create a new clone or substitute the existing clone for the original item in the second diagram?  Have explained the use case correctly?

TIA,
Paolo

3
I Believe updating external elements on every diagram is not handled by EA.
Also doing this via script is also bit tricky as you know the id of element is changed but it has a connector relation to its previous version so we can update on other diagrams

Best Regards,
Nabil
Thanks, Nabil,

That's what I thought.  We have a consolidation process which already knows how to substitute one item in a diagram with another.  I'm sure it can be modified to do this.

I guess I have to respond to the EA_MenuClick event to intercept the cloning and add the additional functionality.

It seems to me that this would be a common requirement and maybe I should put in a Feature request.

Thoughts?
Paolo

4
We are about to embark on a serious implementation of Time Aware Modelling (TAM) in our corporate repository.

As we understand TAM, if we have the different versions (of items) in their individual branches, we can use items from another version in the diagrams for a specific version.  So far, so good.

When we clone an element (from another branch from within a diagram in this branch), a clone of the external element will be created in the current diagram branch.  The external element in the diagram will be replaced by the cloned element in that diagram.

Question:  Is there any mechanism to replace the external element in every diagram in the appropriate version, or will we have to "roll our own"?

TIA,
Paolo

5
Hi Daniel,

I haven't checked for QuickLinker, but for other elements of the MDG, we don't have to restart EA to get the updated MDG installed.  The QuickLinker is a global structure (to which each MDG supplies a portion), so I suspect that it is not possible to unload the existing QuickLinker for a specific MDG (probably because each entry is NOT tagged with the MDG(s) that provided it).  Hence a restart is required.  You can append (as you load MDGs dynamically), but you can't remove.

HTH,
Paolo

6
General Board / Re: View indexes script
« on: January 18, 2018, 05:41:38 pm »
I don't know what "materialized views" are, but here's an example on how to create indexed views in SQL server.

https://docs.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views

Geert
Thanks, Geert,

It looks like a SQL Server "Indexed View" is functionally equivalent to an Oracle "Materialized View" and consequently is a dynamic table in all but name.  Like Trump's Media Spokesperson calling a non-fact an "alternative fact".  It's either an objective fact or it isn't.  These kinds of objects are tables whose contents are maintained by means of triggers in other tables that respond to the "query specification".  They are VERY USEFUL but are just tables - dynamically maintained by the RDBMS.

The problem appears to be that EA doesn't recognise them as "tables" and, consequently, doesn't reverse engineer their indexes.

Paolo

7
So I changed the ODBC driver to SQL Server Native Client 11.0 and things started to improve.  But I've just noticed that Reflexive (that is back to the same table) FK associations aren't being imported.  They are present in the DB and will show up under the SQL Diagramming section.  They are present on the imported table as stereotyped FKs, but associations are nowhere to be found.

Anyone confirm or deny this?

Paolo

8
General Board / Re: How to become and Enterprise Architect.
« on: January 18, 2018, 11:23:09 am »

Generally those titled Enterprise Architect are very entitled leading to poor engagement with the business and other architects :-)
To paraphrase Descartes:
"In titulo, ergo sum" - I am thus entitled, therefore I must be...

Paolo

9
In response to Paolo's question, the instructions provided to us were to run up MS Access and Open the EAP file, which converts the  EAP to a .aacdb file, so my use of the term 'export' was misleading.

Geert (Sherlock) thx for your efforts, but the suggested change doesn't produce the missing items. What I intend to do next is compare the output columns for the original query and the new query and identify the EAP elements that it isn't finding and deduce why the select statement isn't finding these 13 items.
We use MS Access with Linked Tables so that the source EAP (or another repository) file doesn't need to change.  We DO use .accdb MS Access DBs but they still link to the repositories via Linked Tables.

If the intent was to transfer the repository from a .eap to a .accdb repository, then the Transfer Project functionality should have been used.

Paolo

10
General Board / Re: View indexes script
« on: January 18, 2018, 10:40:30 am »
As I read the whole set of responses, my original assertion stands.  (If you accept that "materialised views" are dynamic tables - as per response #5 in the link).

What is the syntax for defining an index directly on a view (that is not materialised)?

Paolo

11
Hi there,

Some time ago an SQL query was devised to parse an exported EA DB to Microsoft Access: The query took 30 minutes to run:

[SNIP]
(my emphasis)
Exactly what does the highlighted phrase mean?

Paolo

12
General Board / Re: View indexes script
« on: January 17, 2018, 05:43:03 pm »
I didn't know Views had indexes.  They use indexes (in the underlying tables), but don't have any themselves.  Even "Materialized" Views aren't Views, per se, but dynamic tables.

Paolo

13
Daniel
To verify a stereotype definition -> once you save your profile, you can import it in your Resources Window -> UML Profile, this will allow you to drag and drop your stereotypes into a diagram and verify your results.


FWIW - I've noticed that The color of your extended stereotype goes to the native color is due to the order of stereotype (in the stereotypeex field), When we remove the Archimate stereotype and reapply the color will be usually corrected.  But this isn't always a reliable solution.

Nizam
(my emphasis)
Which is (one of the reasons) why we stopped using multiple stereotypes getting on for a decade ago.  Each element has only ONE stereotype (used to define the metatype).  All other uses of "stereotypes" are catered for by using various properties (including tagged values).

Paolo

14
General Board / Re: Diagram Details hide when publishing
« on: January 17, 2018, 10:47:59 am »
Hi!

Is there an option or setting where I can show Diagram Details in Enterprise Architect but when I copy to clipboard or publish that I can hide the details?

Eamonn J.
Hi Eamonn,

We have forsaken the Diagram Details feature for the use of the Diagram Note Element.  We make it non-selectable and so it WON'T appear in the clipboard (unless we want it to by making it selectable).

It's been SO long since I use the Diagram Details that at first, I wasn't sure what you were talking about.   ::)

Paolo

15
General Board / Re: Hyperlink as an element in Project Browser
« on: January 11, 2018, 10:45:05 am »
We would like to make a list of hyperlinks, and refer to these hyperlinks from multiple diagrams, like other elements. Is this possible?
You can collect the hyperlinks you want to share into one or more diagrams and then get your users to copy and paste into the relevant diagrams.  As qwerty says, you can't "see" them directly in the browser, but this can be the next best thing.

Paolo

Pages: [1] 2 3 ... 394