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 - Arquesoft

Pages: [1] 2 3 4
I have created a MySQL 8 repository but when users connected to the repository it throws database errors for every update/insert action that users execute in the user interface.

Do you think this is a problem related to the MySQL version? or could it be another weird missconsideration (as the Cloud Server config).

The environment is:
ODBC driver 32 bits
Cloud server
Server contains: MySQLServer, Cloud Server, ODBC, Keystore server
Final users: EA 14.1 + TOGAF MDG. Floating licenses.

Bugs and Issues / Reverse engineering for ODBC in MySQL
« on: December 06, 2018, 09:13:27 am »
In a EAPX file I tried to reverse engineering a MySQL database in EA v 14.1 and the column types are wrong imported. For example, a column of type INT is mapped as type "494E54", which are the ASCII codes for the letters of the word INT (I=49, N=4E, T=54). The same happens for all the columns for all tables. It is the same when doing the reverse ODBC from the classic way or via "table diff" in the Database Manager.

Anybody having the same bug?

I would like to validate if the current user is enabled (by evaluating if belongs to a security group) to delete an element. It would be great if the workflow scripts had the function CanDeleteElement, but not.

I don't want to lock the elements to the given group because if you don't belong to the group, you can not edit or create connectors to this element. But I need to allow all users to edit or create connectors to the elements, but only allows some users to delete the elements. Any idea?

I pretend to create a hyperlink in a diagram that runs a Jscript located in a Normal group (not really want to create a Diagram group script because I don't want this option in every diagram).
I note when you create a hyperlink, there is a Type called "EA command" and in the next option you can choose "Run". How does this "Run" option works? does it work for running my script?

If using Spanish version, the script debugger doesn't work (ver 13.5). You can test it easly openning the script window, Console tab and writing: !JS. The expected behavior:
Code: [Select]
JScript console opened

The actual behavior:
Code: [Select]
JScript console opened
console closed

So, it is impossible to run any script. In order to work, we had to install the trial version in English and it worked. Tested in several computers with the Spanish version with the same result.

I have a MDG based on a profile containing only connectors. When I create a new connector between elements, the stereotype in the connector is shown as <<MyProfile::MyStereotype>> instead of only <<MyStereotype>>.

Previous versions of MDG (a year ago) had generated <<MyStereotype>> connectors. It is supposed we have not made any change in the profile definitions, but now the connectors are generated as <<MyProfile::MyStereotype>>.

Any ideas what could be changed? (I've already checked any custom stereotype in the UML Types window.)

Do you know any feature or plugin that allows, given a class model (classes with attributes and relationships), convert it to a database model of classes (classes stereotyped as <<table>> with columns and foreign keys)?

We don't have a ERD model, but a simple class model.

General Board / Where is the now?
« on: July 18, 2018, 11:02:36 pm »
Did you notice the Sparx site has a new look? well, in this new webpage I can not find the download of the (in the registered user site). Can you help me to find it?

A client with a very restrictive environment has implemented Citrix VPN in order workers can connect and work from home in the corporative network. Everything works well except EA (tested in version 10 and 13). In the simplest scenary I tested, we have a fresh EA instalation (never have had EA installed previously), and a site license (not dealing with database repositories nor eap files).

When connected via cable in the network (as they  normally do everyday), EA opens instantly, as all of us are used to. BUT, when you unplug the cable, use a data cell phone connection (in order to simulate you are out of the corporative network), and connect to the Citrix VPN, if you try to open EA, it delays the opening about 2 to 5 minutes (you can see the app listed in the Windows task manager, but the splash screen just opens 2 to 5 minutes after double clicking the shortcut).

We tested and noted that within the 2 to 5 minutes of "doing nothing", the PC actually tries to connect to the LDAP/Active directory server and this servers seems to be slow to answer in such circumstances. Some of this calls are delayed, other rejected and finally, when the answer is returned, the delay time ends, and EA finally opens.

The question is: why does EA invoke the LDAP server? We supposed it is related to resolve "the user opening EA" through the permissions in the VPN, but, why other apps does not work like that? I mean: Window calc, Paint, Word.... all of them are apps running in the same conditions but only EA delays opening.

Any idea? Anyone with the same or similar issue?

I need to access to the data in the clipboard in a Jscript in the model. Is this possible?

Hi. After several tests and reading several posts in the forum about different versions of EA, I'm a bit confused about the ultimate right way to change a stereotype programatically. In a simple scenary as follows:
-There are two stereotypes, from the same profile, extending the same metaclass
-Both stereotypes add the same tag values to the elements.

Sometimes you create the element with the wrong stereotype (A), and later you want to change it to the stereotype B (with a script). What is the right procedure?

I'm particulary confused with: element.Stereotype, element.StereotypeEx, element.FQStereotype, element.MetaType, element.SynchTaggedValues.

Thanks in advance.

Bugs and Issues / Tag values mixing groups (ver 13.0)
« on: June 06, 2018, 07:52:18 am »
I have a MDG containing profiles. I created a stereotype called "Application" and another one called "Platform", both extend Component metaclass. Both have the same tag values, and the tag values are organized in groups (as both extends the same metaclass, the groups definitions is in the single metaclass element).

I have made several versions of the MDG (every 3 months it happens an update), so I have different elements in different versions of the profiles. The situation about versioning is similar as described here:,39829.msg245210.html#msg245210

Then, I changed some elements, changing their stereotypes from Platform to Application. To do so, I have a script that allows to do it for a large number of elements simultaneously, selected from a diagram.

After doing that (and experimenting some issues as described in the post of the link above), I manually "fix" the data in the stereotype, and in the t_xref table. It seems to be simple: I had to erase the reference to the Platform stereotype in the t_xref row related to "Stereotypes" and I noted that there is a row in t_xref related to "CustomProperties" containing the tag grouping definition for the element. As the two profiles has the same tags and groups, it is not required to change the t_xref CustomProperties data (there is no reference in this rows related to the profile name.

So, the issue is: after changing the stereotype of the element, the tag grouping is showing the tag values grouped in a weird way, like this:

-Group A
--Tag 1
--Tag 2
--Tag 3
-Group B
--Tag n
--Tag n1
--Tag n2
--Not grouped tags

What is expected:

-Group A
--Tag 1
--Tag 2
--Tag 3
-Group B
--Tag n
--Tag n1
--Tag n2
--Not grouped tags

The Description in the t_xref for this cases is: @STEREO;Name=Application;FQName=ProfileName::Application;@ENDSTEREO;
(previously it had two definitions of @STEREO (one for Application and one for Platform), so I fixed it manually directly in the database)

General Board / How to set page size in RTF templates (ver 14)
« on: June 04, 2018, 08:20:18 am »
I'm creating Virtual Documents (master and model documents) and the default page size for all is A4. I need to set the page size as "Letter", but can not find the option in the master document template nor the model document templates. I did know how to do it in version 12, but can't find the option now. Do you know how to do it now in version 14?

Hi, I would like to read your opinions about a good strategy in order to let different users to generate a profile (or MDG), having in mind the icons are defined as local file for the user is creating the profile.

The scenary and restrictions are:
  • There is a shared model in a database
  • Multple users want to update the profiles via re-generating the profile files and the MDG files
  • The profile definition exist in the same model (so, we have to generate the MDG and import the MDG in the same model)
  • It is not possible to have a shared folder to share the icons

Do you know any way to define the icon folder via a parameter or something not depending on the user creating the stereotype in the profile?

I created a C# console app that works fine in development environment and in production environment (windows server 2008 R2 64 bits) but only when executed manually. When scheduled in Windows Task Manager it throws the following exception:

Retrieving the COM class factory for component with CLSID {67F4E0FA-46A7-4255-B084-69A9433D08C3} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)).

I followed the instructions described in:

But when trying to find the EA.App component in the Component Services windows, it is not listed, as shown:

Even in my local PC (windows 10, 64 bits), the EA.App is not listed. Note the shortcut of the comexp executable:

I followed all the instructions in the previous links, even in my local PC but the EA.App is never listed in the Component Services window, so it becomes imposible to configure full launch permissions to this component.

Any ideas?

Pages: [1] 2 3 4