Messages

1

PCS General Board / Re: DBMS recomendations

« on: August 29, 2022, 05:26:11 pm »

We moved from Oracle to SQL Server and noticed a major performance improvement.
Working from home with EA directly connected to a database was very slow, I received a lot of complaints. We added the Pro Cloud Server and that solved the issue.

2

Bugs and Issues / EA15 to 16 migration recent connections

« on: May 05, 2022, 12:32:57 am »

Hey,

I'm currently testing the migration from EA15 to 16.
I've noticed that when I open EA16 I have to re-enter de license key and my recent connections list is empty.

This seem to be cause by a different registry location that is used, due to 64bit?

OLD: Computer\HKEY_USERS\xxx\SOFTWARE\Sparx Systems\EA400
NEW: Computer\HKEY_USERS\xxx\SOFTWARE\Sparx Systems\EA64

Is this something known? Is there a solution for this?
I want to impact the end users in my company as little as possible.

3

General Board / Re: HTML Exports from Enterprise Architect

« on: March 23, 2022, 08:56:53 pm »

We used to export the whole repository daily to a web server. Works great.
Last year we installed the Pro Cloud Server, which gives direct web access to the repository. We are very happy with the results and added benefits.

4

Automation Interface, Add-Ins and Tools / Re: [EA 16] - work in team cababilities

« on: February 21, 2022, 10:08:54 pm »

...
Use a terminal solution (citrix, WVD, RDS) if the performance of connecting the EA client to the database is an issue
...

We switched from direct database access to the Pro Cloud Server connection and remote connections performance (for example from home) increased dramatically. I can highly recommend it.
This also allowed us to limit database access to only the PCS service account, which increases security considerably.

5

Bugs and Issues / Re: Double stereotypes

« on: September 27, 2021, 05:13:55 pm »

I can confirm that running the project integrity check did not remove the double stereotypes.

Furthermore, I noticed that any stereotypes that contains uppercase characters in the AppliesTo field, when I make any changes to them, are duplicated upon saving. The new record has all lowercase. (on Oracle DB) So I will also update the database and force all AppliesTo to lowercase.

update:
After doing the above, I also had to remove the Audit log (850k records). Running the project transfer I first received an out of memory error, and after moving to more powerful computer I received an internal server error. After removing the Audit log the transfer was successful. Although it still took 2h45m, even though our repository isn't that big.

We will now test if the removal of the stereotypes has much impact....

6

Bugs and Issues / Re: Double stereotypes

« on: September 21, 2021, 06:19:29 pm »

It is possible to have case sensitive databases in SQL Server. It is just a matter of changing the database collation, CS on a SQL Server database collation means Case Sensitive whilst CI means Case Insensitive.

Thanks, but I also tried transferring the database to file, and that failed for the same reason. This makes me believe that EA doesn't want double stereotypes. And so I think it would be best to remove them.

@Geert, thanks, I'll try that.

7

Bugs and Issues / Double stereotypes

« on: September 21, 2021, 05:17:00 pm »

I'm trying to migrate our Oracle repository to a SQL Server repository and I encounter issues because apparently we have double stereotypes. In Oracle the primary key on t_stereotypes (stereotype, appliesto) is case sensitive, while in SQL Server the primary key is case insenstive.

We have 5 doubles:

Code: [Select]

Sterotype               AppliesTo         Description        mfenabled    metafile    style                ea_guid    Visualtype
Application             Component         Application        0                                            {843C0C...   
Application             component         Application        0                        <STYLE fill="...    {5E4AB0...
document                Artifact          document           0                                            {54D888...
document                artifact          document           0            (BLOB)      <STYLE fill="...    {BD5E9D...
Functional requirement  Requirement       UML Profile Notes  0                        <STYLE fill=..."    {05B213...  Profile=D1A4427B-1;
Functional requirement  requirement       UML Profile Notes  0                        <STYLE fill=..."    {BD439D...
TimingEvent             Event             TimingEvent        0                                            {D94638...
TimingEvent             event             TimingEvent        1            (BLOB)      <STYLE fill="...    {69A58C...
Update vessel           InformationFlow    Update vessel     0                                            {3C1687...
Update Vessel           InformationFlow    Update Vessel     0                                            {C14E60...
Any suggestions on how to can decide which I should remove?

thanks

Michael

8

General Board / EA Global Summit recordings

« on: September 13, 2021, 10:15:33 pm »

Hey,

I registered to the EA Global Summit but only managed to attend a handful sessions, most were during the night, meetings, ...
Will a recording be provided? There are several more sessions I wanted to watch.

Thanks

Michael

9

PCS Frequently Asked Questions / Re: WebEA token usage

« on: August 12, 2021, 06:38:23 pm »

Thanks for the reply Skiwi!

They time out after 30 minutes.

Timeout after 30 min is also something I've noticed not to be correct.
I opened browser and went to the website on a pc. I locked the pc. The day after the token was still in use.
Only after I manually logged out or closed the browser (and waited 30 min), the token was released.

10

PCS Frequently Asked Questions / Re: WebEA token usage

« on: August 11, 2021, 11:38:15 pm »

I'm interested in this aswell. How can we see who is using tokens and how do we manually release a token?

11

General Board / Re: HTML Reports

« on: November 20, 2017, 11:22:23 pm »

I've had problems loading the exported html locally (= files on my local disk), once i upload the files to a webserver it usually works. I think it has to do with java not loading in that scenario, see comments from other users above.

12

General Board / Re: default line style changed

« on: February 27, 2017, 06:10:14 pm »

Thanks for the tip Paolo.

I found the issue, someone created a "BPMN2.0:SequenceFlow" entry in the UML Types -> Stereotypes. This entry was not in our backup from a while ago.
Removing it fixed the issue.

Thanks all for helping resolve this issue!

13

General Board / Re: default line style changed

« on: February 24, 2017, 08:57:49 pm »

Thanks for the reply, unfortunately I haven't found a solution yet.
I can't find any scripts that change line styles and I don't have Geert's add-in, nor have I found a collegue that has the add-in.

14

General Board / Re: default line style changed

« on: February 23, 2017, 10:49:49 pm »

No, but maybe a colleague tried it...
Do you know in what table/record this data is stored? Then I could compare it with the backup database.

Michael

15

General Board / default line style changed

« on: February 22, 2017, 08:27:26 pm »

Hello,

Since recently the default line style in BPMN 2.0 diagrams seem to have changed from "Orthogonal - Rounded" to "Direct".
We use a central repository (oracle dbms) and this problem only occurs in this repository. If I create a local file then I do not have this problem. If I use our test-environment-repository (backup from a few months ago) then I also do not have this problem.

We have a "Project Template Package", but it's practically empty and I also set the package to "<none>" and the problem still occurs.
The only addins that are active (on my computer anyway) are "ActivityAddin", "Visual Studio" and "Eclipse", I disabled all 3 and the problem still occurs.

We use EA 13.0.1307, it seems unrelated to this version as this issue didn't occur immediately after the release.

I found a topic with the same issue (http://sparxsystems.com/forums/smf/index.php?topic=26201.0) however the proposed solutions didn't work for us.
Before the problem occurred we wanted to change the line style from "Orthogonal - Rounded" to "Orthogonal - Square" (http://sparxsystems.com/forums/smf/index.php/topic,37750.0.html). However, the change to the XML file was only done on the computer of 1 user. All our users experience the issue now, so it seems unrelated.

We have quite a few users, so maybe someone changed something?

Any help would be appreciated.

Kind regards,

Michael