Messages

1

Automation Interface, Add-Ins and Tools / Re: Access EA DBMS from Jenkins Build Job

« on: August 21, 2020, 12:14:07 am »

now its 2020, I use Windows Server 2019 now and this problem re-occurs

• I can start EA interop manually in system context, everything is fine
• I can start EA interop via Jenkins in system context, and it starts but it hangs in OpenFile and OpenFile2

By the way - it does not matter if I use system context or user context.
So EA obviously accesses keyboard/mouse input or UI output which was completely vanished in Win2019 (session 0 isolation) for services even if I explicitly allow Jenkins the interaction with the desktop.
This is the only difference between both use cases. BTW: https://kb.firedaemon.com/support/solutions/articles/4000106824 explains the technical background...

So the game starts again: how to use automation of EA in an highly automated build environment?


The ProCloud Server is not an option - it provides much more and much different functionality than required, I simply want to extract html out of the model.

Does anybody have an idea?

2

Automation Interface, Add-Ins and Tools / Re: HowTo: Get process id of COM Interop instance

« on: September 11, 2019, 04:37:50 pm »

This solution works but is really an odd hack

Code: [Select]

HashSet<int> previousEAids = new HashSet<int>();
foreach (System.Diagnostics.Process p in System.Diagnostics.Process.GetProcessesByName("EA"))
    previousEAids.Add(p.Id);
EA.Repository myEAInstance = new EA.Repository();
foreach (System.Diagnostics.Process p in System.Diagnostics.Process.GetProcessesByName("EA"))
    if (!ea.Contains(p.Id))
        System.Console.WriteLine("EA process ID=" + p.Id);


3

Automation Interface, Add-Ins and Tools / HowTo: Get process id of COM Interop instance

« on: September 11, 2019, 04:08:37 pm »

Hi,

is  there a way to figure out the interop EA process ID when I am using EA via COM interface?

The background is that I want to use EA for some background jobs and if the jobs being terminated (eg. cause of job timeout), the interop EA instance becomes orphaned.

The idea is to write the ID to the console and terminate the orphaned EA instance in the job. I can't just terminate all EA instances cause another job may runnning in parallel.

4

Automation Interface, Add-Ins and Tools / Re: Access EA DBMS from Jenkins Build Job

« on: March 18, 2019, 06:02:38 pm »

Jenkins is running under local system account.

Local system is not a user account.

Yeah, that's for sure. And?

Why does EA require a physical logged on user account if I pass the DB credentials via EA API (OpenFile2 instead of OpenFile) and disabled all UI dialogs?

5

Automation Interface, Add-Ins and Tools / Re: Access EA DBMS from Jenkins Build Job

« on: March 14, 2019, 07:54:14 pm »

For me it sounds pretty much like EA tries to create an invisible window or access a GUI resource and runs into an exception.

6

Automation Interface, Add-Ins and Tools / Re: Access EA DBMS from Jenkins Build Job

« on: March 14, 2019, 07:47:41 pm »

Jenkins is running under local system account. I entered the license data once by starting EA on the host via psexec under local system account.
Project transfer is working - so it is likely neither a license nor a DCOM issue.
Same setup works with a win7 host - if I allow Jenkins interaction with desktop

7

Automation Interface, Add-Ins and Tools / Re: Access EA DBMS from Jenkins Build Job

« on: March 13, 2019, 08:31:03 pm »

From an architectural point of view that is the right place for these type of things.
IIRC there are only a very limited (2?) of these type of tasks made available currently.

From an architectural perspective the right approach is not to try and behave like malware or provide vulnerabilities for malware.

I see - and what exactly do you want to tell us with this statement?

8

Automation Interface, Add-Ins and Tools / Re: Access EA DBMS from Jenkins Build Job

« on: March 12, 2019, 06:22:28 pm »

I think different - the cloud host is responsible to provide user access to the EA DBMS.
But maintenance tools shall be completely separated from users.
Usually companies have a complete infrastructure for things like quality or tracing reports and synchronization with other infrastructure entities.
Even when the EA cloud host provides reports a distinct maintenance access port is still required.

9

Automation Interface, Add-Ins and Tools / Re: Access EA DBMS from Jenkins Build Job

« on: March 12, 2019, 05:34:07 pm »

Yes I know - and it would likely not be a problem if EA would handle SuppressEADialogs / SuppressSecurityDialog correctly so it would run without any window context.
In bigger projects (>= 50) there are usually a lot of maintenance tasks related to the model (eg. integration into quality reports etc.).
My intention is absolutely legitimate and the lack of adequate maintenance access will certainly lead us to look for alternatives in the medium term.

10

Automation Interface, Add-Ins and Tools / Re: Access EA DBMS from Jenkins Build Job

« on: March 12, 2019, 05:48:49 am »

This solution will no longer work with Windows 10. I didn't find any solution working with Windows 10. OpenFile2 always terminates.

Is a PC with a logged on user and the windows task scheduler really the only solution for automated EA tasks? Really?

11

Automation Interface, Add-Ins and Tools / Re: How to delete elements correctly?

« on: March 06, 2019, 11:04:40 pm »

thanks!

12

Automation Interface, Add-Ins and Tools / How to delete elements correctly?

« on: March 06, 2019, 10:23:45 pm »

If I want to delete an Element from EA - via Package.Elements.DeleteAt() - do I have to take care of all diagram references and connectors and delete them beforehand?
I want to avoid orphans in the DB

13

Automation Interface, Add-Ins and Tools / ProjectTransfer to Firebird database fails

« on: February 26, 2019, 09:17:40 pm »

I tried everything to transfer a database to a Firebird file.

It is no problem to do this manually but EA.IDualProject.ProjectTransfer always fails ("Transfer failed") with no further information.
Neither DBMS->File, nor File->File.
I tried with and without an empty base destination DB .

The use case: I have a MySQL based DB hosted by EA Cloud Server and I want to spawn (read only) snapshots that are hosted by the Cloud Service as well. The snapshots are taken by a Jenkins build job.

Since the snapshots are not used so frequently I thought a Firebird file is the best solution - but somehow EA.IDualProject.ProjectTransfer seems to be a very weak replacement for the GUI project transfer...

14

Bugs and Issues / Re: EA using Wine and ODBC

« on: February 26, 2019, 12:16:35 am »

We observed serious troubles with 16.04 LTS (getting lots of errors 80040E07).
18.04 LTS and 18.10 + Wine 4.2 are working without any issues.

15

General Board / Re: Why does this SQL statement blocks my EA?

« on: January 23, 2019, 11:51:13 pm »

This query does not block EA - but it returns only objects that have the tag - and not the objects that are connected to objects with this tag.

The query shall fake somehow "tag inheritance" (EA.Element.TaggedValuesEx)