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

Pages: [1] 2
PCS Bugs and Issues / Re: SBPI registry key warnings in the PCS logs
« on: March 31, 2020, 07:38:48 pm »
Hi Guillaume,

I had the same issue and solved it by adding the data manually to the registry, see below.
Somehow it was still giving the warning: "[WARNING]: Failed to read SBPI server port from registry, assuming default value of 8080"
After installing the latest Version 4.01.0044 this warning is now gone as well.

Windows Registry Editor Version 5.00

[HKEY_USERS\.DEFAULT\Software\Sparx Systems\SQLBridge\SBPI]

[HKEY_USERS\.DEFAULT\Software\Sparx Systems\SQLBridge\SBPI\Server]

Automation Interface, Add-Ins and Tools / Re: ApplyUserLockRecursive
« on: November 14, 2018, 05:17:18 pm »
Hi Paolo and Geert,

thanks for your replies.

It seems that calling ApplyUserLock on Diagram objects does lock all elements, so seems we have to implement ApplyUserLockRecursive by ourselves.

Paolo, would it be possible to share some further details with respect the queries you run?

Thanks again.

Automation Interface, Add-Ins and Tools / ApplyUserLockRecursive
« on: November 13, 2018, 11:27:56 pm »

we wanted to automate the transfer of a small package from one EA model to another one via XMI-export/import.

The target model has security enabled, therefore we lock the according target package via ApplyUserLockRecursive(true, true, true).
But we found the XMI import into the target model is failing because it seems not all elements within the target package got locked.

When analyzing we came across that apparently ApplyUserLockRecursive (via EA13.5 API) doesn't lock diagram elements like note-elements or text-elements which are part of diagrams. But then this seems to make it impossible to import a XMI file to the according package via automation API.

Anyone knows a solution / different approach to this?

Thank you

General Board / Re: Using SSL with CloudServer
« on: April 15, 2015, 03:54:38 pm »
Thanks a lot Simon!

Must have accidentally removed this file and could restore it from the installer. Now the server does provide the SSL connection.


General Board / [SOLVED] Using SSL with CloudServer
« on: April 14, 2015, 04:42:42 pm »

I created a self signed SSL certificated using the openSSL commands described at (see last page)

The server.pem is successfully generated but I am getting following error when starting the CloudServer-Service:
[WARNING]: Unable to create secure server on port 805. CA Cert file not found not found at C:\Program Files (x86)\Sparx Systems\Cloud Services\Service\cacert.pem

SSCloudServices.config contains following:

Do I need to create a CA certificate as well?


Automation Interface, Add-Ins and Tools / Re: Orphan locks
« on: November 20, 2015, 07:57:48 pm »
Hi Geert,

no, integrity check does not consider that. So I guess I head for rephrasing the query to a DELETE...


Automation Interface, Add-Ins and Tools / Orphan locks
« on: November 20, 2015, 06:02:19 pm »

we make use of EA's security feature and I just got curious about the number of entries within t_seclocks. So I ran query below and it gave me a lot of results, means it seems that there are a lot of orphan locks.  Did I miss something wrt my query?

Code: [Select]
SELECT l.entityid, o.Object_id, o.Name, o.Package_Id, u.userlogin, l.timestamp
FROM t_seclocks l
LEFT OUTER JOIN t_object o on o.ea_guid = l.entityid
LEFT OUTER JOIN t_secuser u on u.userid = l.userid
WHERE o.Package_id is NULL


If you run a batch then include all code you need.
That's exactly what I wanted to prevent and was looking for an alternative and use the trigger EA_FileOpen for supporting automation from within my add-in.

BTW, why was LoadAddins() added if there would be no need for it?

Thanks a lot, totally missed that when browsing the help...

Anything else to consider?
I added the LoadAddins() (tried before and after OpenFile2) to the PS script and now the Addin is in state enabled but still events seem not to be triggered and menu entry of the Addin is missing.

Using EA 11.0.1106


just wrote me a Powershell script to open an EA model and realized that my add-in is not enabled when running EA via the PS script.

Snippet from powershell script:
Code: [Select]
  $dbConnection = "DBType=3;Connect=Provider=OraOLEDB.Oracle.1;Password=XXXXX;Persist Security Info=True;User ID=YYYYYY;Data Source=eadb;"
  $EaApp = New-Object -ComObject "EA.App"
  $EaRepo = $EaApp.Repository

After calling the OpenFile2 I expected the event EA_FileOpen to be fired and my Add-In (C# DLL) to do some action but it didn't happen. Then I added $EaRepo.ShowWindow(1) to the Powershell script and found that my Add-In is in state "disabled" within the Addin-Manager.

Any way to enabled it?


I have some strange behaviour regarding the scheduling of scripting...
There are two powershell scripts accessing EA COM object:
No. 1 calling the ProjectTransfer function and running a transfer from Oracle-DB to standalone eap file.
No. 2 opening the model (via OpenFile2) then saving the Auditing log (SaveAuditLogs)

Both scripts run fine when called by a logged in user. Then I did setup two triggers via Windows TaskScheduler to trigger each of the scripts regularly. Both tasks are setup to be run using one of the local users.
Script 1 runs fine when called via TaskScheduler
Script 2 stops with the call of OpenFile2, EA process does not show any activity and I have to kill the process using TaskManager (did let it run for several hours)

Several things I tried:
* Running cmd.exe from TaskScheduler to start EA to see whether license is acquired correctly -> Yes it is
* Wrote a service to setup EA for Windows-System context -> Successfully done but still script 2 does get stuck
* Changed "Identity" for EA.App via comexp.msc to interactive user -> Script 2 now runs - but if I understood correctly it requires the user to be logged into the server permanently (at least when script shall run), right?

Can anybody explain that behaviour?
Is there any way to keep the powershell scripts or do I need to implement it via a service?


Automation Interface, Add-Ins and Tools / Re: Disable security
« on: February 11, 2015, 09:51:12 pm »
Both of you - thank you very much!


Automation Interface, Add-Ins and Tools / Re: Disable security
« on: February 11, 2015, 09:09:59 pm »
Disable security - doesn't sound like such a good idea.

Well that's depending on the use case. We have a model within an Oracle DB and from time to time we trigger a project transfer to get a .eap JET DB. For the created JET DB we want to disable security and remove all locks automatically.

Could the unlocking be also achieved by removing all entries from the t_secklocks table (instead of looping and calling ReleaseUserLock)?

Automation Interface, Add-Ins and Tools / [solved] Disable security
« on: February 11, 2015, 08:25:11 pm »

is it possible to disable project security using the automation interface?
And/Or is it possible to trigger the unlocking of all current locked elements via the automation interface?

Thank you!

Best Regards,

Thank you very much Aaron!

Any chance to also set the option "Scale to one page" for a diagram via the automation interface?

Pages: [1] 2