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.

Topics - Richard Freggi

Pages: [1] 2 3 ... 5
EA 16 on *qea file, Wiundows 10 32GB RAM

Just wondering is this is something normal, something due to the interface between Sparx and SQLite, or some bug in EA16.

On EA 13 with *feap files it was rock stable, never had any issues.

I can't keep a good log of crashes on EA16 but one occurred when I mistakenly ran an old Firebird query on the query window in EA; another when I was dragging a class from one diagram to another and clicking 'paste as link'.  Another time my fingers slipped on the keyboard while I was writing a query on the query manager, don;t know what keys I pressed.

Is anyone else experiencing similar issues?

General Board / EA16 what's the setting for double click = open properties?
« on: September 17, 2022, 12:37:00 pm »
In EA 13, when I double clicked on an object in a diagram or in the browser, the properties window would open.  In EA 16 the only way to open the properties window is to right click and use the context menu.  Is there a setting somewhere in EA16 to set double click as open properties?  I looked and could not find it.

General Board / EA16 bug? Project browser does not auto scroll
« on: September 17, 2022, 12:33:52 pm »
Hello in EA13 if an element name was too long to be displayed in the browser window, the browser would auto scroll to the left when hovering/clicking on the object, so you could always see the beginning of the object name, click on the expand triangle and move up/down its parents and children.  This is not happening in EA16: I have to use the browser's scroll bar manually.  Is there a setting to enable browser auto scroll, or is it a bug in EA 16?

I want to display the object ID on the Properties window because the GUID is too long for human use.
My WebEA field is blank because my projects are all local *.qea.  So I thought I could override the field with an UPDATE statement on the qea database.
Did not find the entry for WebEA in qwerty's excellent "Inside EA".  Could anyone advise what table and field, and is it safe to override its data or not?  Thanks!

General Board / EA 16 no menu to "Find in all diagrams" for packages?
« on: September 02, 2022, 04:15:13 pm »
I can right click on an objects to find in all diagrams... except for packages!  I have package diagrams and also packages appear in some of my component diagrams.  Is this a bug or am I missing something?  Thanks for advice!

... new operations?  (ran out of space in the subject field)

In EA 16.5 when I create a message in sequence diagram and I double click it to show properties, the "Operations" button next to the Message box is grayed out.  I can see the existing operations of the class, but to create a new one I need to navigate from participant object to the parent class and then add the operation to the class, then go back to the sequence diagram.  Am I doing something wrong?  Why is the Operations button grayed out?  Thanks!

General Board / Evaluating EA 16: UML 2.x XMI export incredibly slow
« on: August 02, 2022, 01:49:25 am »
I downloaded eval copy of EA 16, imported some models from my old EA 13 via UML 2.1 XMI, no problem.
Now I'm exporting them back from EA16 to UML 2.1 XMI and it's incredibly slow, minutes per object and I have 10K objects in the model

Before I submit a bug report I'd like to check if others are seeing the same thing?
PS I know there's native XMI now, just wanted to know if UML 2.x is a bug or what

General Board / Is EA 16 noticeably faster than previous versions?
« on: April 27, 2022, 03:28:43 pm »
I'm using v 1310 and my *.feap (Firebird) model is about 1GB.  The PC is Win10 Intel i7 16GB RAM,  500M SSD.
It takes me about 15 hours to import total 500K elements (classes, attributes) into my model using Geert's importer.
It takes about 20 seconds to delete a single element from the project explorer.
It's possible that EA is slowed down by some antivirus thingy from my work PC, but I don't think so.

One hope of V16 is that using the lighter footprint SQLite (and maybe Sparx can find a way of letting us use SQLite 'memory' mode, with database loaded fully in RAM?) , I can reduce these times significantly.  Can anyone comment on performance improvement with *.QEA files compared to *.eap or *.feap?

On EA 1310 I cannot reverse engineer PostgeSQL, I remember seeing posts that explained that there was a bug in EA.
Is anyone evaluating v 16 able to confirm if PostgreSQL reverse engineering works on this version?  Thanks!!!

Bugs and Issues / Strange bug in diagram legend EA v. 1310
« on: January 10, 2022, 09:18:53 pm »
I am using v13 (eagerly awaiting to update to v16) and I have strange behaviour on diagram legends.  I'd like to know if anyone knows a workaround?
In sequence diagrams I need to color code messages to highlight some business semantics.  I use legend-connectors-filter-tagged values with preset codes in a custom tagged value to determine the message color.
Every time I close the diagram and reopen it, the color coding disappears and I have to reopen the legend dialog to set again the tagged value that determines color.  The legend still shows 'apply auto color', 'apply line' etc. but the filter is not pointing to the custom tagged value any more.  Does anyone have a workaround?  Thanks!!

I have a model query that lists all messages in a sequence diagram and their message number.
The diagram has new message groups, so the message numbers are: 1.0 1.1 1.2 2.0 2.1 2.2 2.3 2.4 3.0  etc etc

I query t_connector.SeqNo and the result is: 1.0 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 etc

New message groups are ignored.  Everything else is OK.  Any idea where I can get the message numbers the way they are displayed in the diagram?  EA 13.10  Thanks!!!

I held off upgrading from my version 1310 because I wanted to avoid the trap of "where did my menu go?" and did not see much benefit overall.  But I'm very eager to upgrade to EA 16 with SQLite repository.

However I just found out that my 1310 has a bug for "Import schema from ODBC" for PostgreSQL (I'm reverse engineering from v. 12.02).  The trace log shows ERROR(ERROR) 42702 'column reference "oid" is ambiguous' at this stage: 

Code: [Select]
[53.579]PQsendQuery: 09C69420 'BEGIN;declare "SQL_CUR09FBCC88" cursor with hold for SELECT
    n.nspname                                       AS ObjectSchema,    --1
    c.relname                                       AS ObjectName,      --2
WHEN c.relkind = 'r' THEN 'TABLE'
        WHEN c.relkind = 'v' THEN 'VIEW'
        WHEN c.relkind = 'S' THEN 'SEQUENCE'
    END                                             AS ObjectType,     --3
    COALESCE(OBJ_DESCRIPTION(c.oid),'')             AS Remarks,     --4
    COALESCE('TABLESPACE=' || t.spcname || ';','')  AS Properties     --5
    (SELECT *, oid
    FROM pg_class
    WHERE relkind IN ('r','v')
    ) c   
    (SELECT *, oid
    FROM    pg_namespace
    WHERE nspname IN ('schema_names') --WHERE   nspname NOT IN ('other_schema_names')
    ) n
    ON  c.relnamespace = n.oid
    pg_tablespace t
    c.reltablespace = t.oid
Order By n.nspname, c.relkind, c.relname;fetch 100 in "SQL_CUR09FBCC88"'
[53.822] ok: - 'C' - BEGIN
[53.822] ERROR(ERROR) 42702 'column reference "oid" is ambiguous'
[53.823]PQsendQuery: 09C69420 'ROLLBACK'

I don't have access to EA16 since my registration expired: can anyone confirm if EA16 has no issues reverse engineering from PostgreSQL?  Thanks!!!!

I'm working on extending a data model and I realized that if I drag a class attribute from a class already in the diagram or from any class in the project explorer to another class in the diagram, I'm creating a new copy of the attribute.  Which is very convenient for me so I can reuse the attribute names and datatypes.  And faster than copying/pasting in the project explorer. 

I'd like to check if this causes any risk at all for model integrity?  I don't think this is normal way to use EA but hey if it works...  Thanks for advice!

My database has MFA authentication and seems like the EA default SQL Server drivers don't support it.  Does anyone know if suitable driver can be obtained and how to install for EA reverse engineering?  Cheers!

I downloaded Belleken's excellent EA Mapping extension and I can easily map attributes of one table into another (it is for a data ETL exercise).  I can export the mappings to Excel.

But I can't see the mappings in my data model diagrams (either ERD or class diagrams), for example as shown in EA user manual here:

I tried googling around and setting all kind of settings in the diagram menu, and changing the stereotype of the elements from <<table>> to <<class>> but I cannot see the mappings in the diagram.  I have EA version 13.10.  I can see the mappings in the diagram if I create them manually by right clicking in the association.  Any suggestions on how to show the mappings in the diagram when created via the Mapping add-in?  Thanks!

[Edit] In the EA Mapping Settings, Link Type and Mapping Logic Element Type are grayed out...  So now it only created tagged values for the mapping and the Mapping Logic Type is only Activity.. I was able to change the defaults to Link to element feature and In-line by editing the EAMapping.dll file, but still only the the tagged value to show the mapping, nothing in diagram... Geert do you know how to display the mapping in the diagrams?  Thanks!

Pages: [1] 2 3 ... 5