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

Pages: 1 2 [3] 4 5 ... 9
General Board / Re: History of lock/unlock
« on: August 08, 2018, 03:20:45 am »
Thank you Geert

why do you think programming those triggers would not be a good idea?

Such a trigger could ask the user about a Change Request ID - supporting reviews as well as quality and safety assessments.

I can close EA and get back in and still see whether a package or diagram is locked. That is why I think that information is stored somewhere in the database. If it is in the DB a trigger should be possible. Would be good using EA API for that. If API does not allow to register callbacks on lock/release-lock event, it should be possible on DB level (though I am completely blind in how to do triggers for SQL Server).

General Board / Re: unable to configure package
« on: August 06, 2018, 08:24:35 pm »
Ok, thank you Peter. Reading that it was so simple: I first have to get a lock, as I have put the whole model under "Require User Lock to Edit".

General Board / History of lock/unlock
« on: August 06, 2018, 08:19:54 pm »
For an SQL Server based EA model I enabled security with "Require User Lock to Edit".

Would it be possible to record all locks and lock releases together with the users issuing that function?

General Board / unable to configure package
« on: August 06, 2018, 07:55:04 pm »
I switched from .eap-file based model to SQL-Server based.
I enabled security and entered 2 groups: Administers and Designers.
As an Administer admin I got all securities.
However, when I right-click a package and select "Package Control/Configure" I get the information: "The current action cannot be completed as the necessary security is not available".

How can I configure a package in this case?

General Board / What about API support for Java 9+ and 64-bit systems?
« on: August 06, 2018, 12:59:49 am »
Oracle seems to be of no-compromise when it comes to switch to Java-11 and 64-Bit systems from 2019 on.
If SSJavaCOM.dll is as simple as stated, would that be a big issue?
Also having the Java_Sample ready would save a lot of learning time, nowadays using Eclipse Photon on Java-10

General Board / Re: Missing Cross References
« on: August 01, 2018, 05:23:50 pm »
This is still true for EA14.
If you ignore those messages it is likely that you violate your model - silently. You may notice only after printout or so.
One cause is that "Get All Latest" - for any reason - is not able to satisfy all inter-package references of controlled packages in all cases. I have not found out yet, in what cases external references get lost. It is seldom the case, but if I got it, I did not find a way to repair the situation. (Checking "For all packages, create placeholders for external references" is mandatory but does not hinder missing references.)
To be on the safe site in professional projects producing production software you may consider not using EA integration of Version Control at all. Define your own - tested - XMI based process.

General Board / automatic XMI export
« on: August 01, 2018, 05:05:53 pm »
Do you know a way to automatically export an EA model to its XMI representation?

I was able to identify only procedures which need manual interaction. What I am looking for is a command line in a Win batch file that I can start on a regular basis.

General Board / Re: SQL failure message after "Get All Latest"
« on: June 28, 2018, 09:32:11 pm »
Thank you, Geert.

I'll stay away from MariaDB in favor of SQL Server (or ... Express). For the same .eap file it worked without such messages.
Seems that EA is tested mainly for MS interfaces.

General Board / SQL failure message after "Get All Latest"
« on: June 28, 2018, 01:33:08 am »
I have imported an .eap file to a database created in MariaDB. The packages are version controlled via SCC/PTC. When I do a "Get All Latest" with the model based on MariaDB, I get an SQL failure:

Any advice what to do next in order to update the database from the packages stored in PTC?

General Board / How to distribute My Queries?
« on: June 27, 2018, 08:36:03 pm »
For distributing scripts and template diagrams to my colleagues I am offering an about empty .eap file as a template.
Recently I created useful SQL and "Query Builder" queries, too. They appear in my EA installation under "Find in Project"/My Searches.
However, they seem not to be part of the .eap file but my personal installation of EA.

How can I distribute "My Searches" to my colleagues?

Kind Regards


more details to the problem:

I lost several weeks of work and - that's worse - reputation in modeling by rolling back to older versions and manually had to re-enter change requests.
On check-in I used to use the window "Missing Cross References" too optimistically. It changed my model silently.
Currently I hope to survive and keep my model consistent in the following way - which is far not acceptable in the long run:

  • When I check out a package, immediately I try to check it back-in again. I cancel that check-in anyway.
  • If I get the window "Missing Cross-References" I also undo the check-out
  • I have to analyse the situation prior to try to check-out the package for change again

and ...
  • "Get Latest" on contributing packages. I can find the contributing packages by double clicking the count of missing cross references. A list of xmi:id appears.
    The xmi:id point to elements owned by contributing packages. How to identify the elements from their xmi:id is another story.
  • But: Now I never click "ok" in "Missing Cross-References" unless I exactly know what they are about.
  • Deleting the links by unchecking, or leaving them in - either may violate my model.

EA-SCC(-PTC) version control link:
Built an .eap file with the master package.
Issued "Get All Latest" - for 44 sub-packages, nesting depth is 3: master - view - package
Ran a query to find "External References", that is, missing links between elements in those packages: found more than 50.

Because I know, all the links shall be there I ran "Get Latest" on views: EA tells me that they are "up to date", but I checked "Force reload from XMI".
Forcing reload of one view solved 4 links, forcing reload of the other view solved the rest.

But not all missing cross references are related to connections: on some component diagrams components are missing. Force reloading of the containing package solved this. But how to find all diagrams missing elements, supposed to be there?

General Board / Re: Replace element
« on: June 24, 2018, 06:42:58 pm »
I ran to this question a lot of times.
I feel that question of KevinMcClusky and i4mdone has not been successfully addressed yet.

Couldn't be there a script or plugin helping with boring task of moving all links from on element to another. Restrictions may apply like "the new element should be kind of same classifier".

wonderful, Nizam - works out of the box. Now I learned e.g. that column Start_Object_ID is foreign key to t_object.

I will try to convince IT to install AnySQL Maestro on the company laptop I am using.

However: where to read further? Not so much SQL, but EA relational schema. Start_Object_ID does not appear in enterprise-architect-object-model.pdf. I am obviosly reading the wrong document. Which of the documents in holds that information?

However, I installed AnySQL on my private computer and it seems that I get all most needed information just from connecting to an .eap file. Thank you Geert.

Dear SQL specialist,
I would appreciate some help on creating a query. I am missing some very first steps.
I did SQL some decades ago, read some examples from Geert, scanned "enterprise-architect-object-model.pdf". I can do a query like

select c.Connector_ID as id, from t_connector c where"External Reference"

and get two columns. What I need is, for each row the name and type of ClientEnd and SupplierEnd.
A benefit would be the containing package name for each.
But if I add anything to my query I always get "Runtim error 3061. Too few parameters. Expected 1."
(e.g. the pdf says t_connector has a column Alias and ClientID, but c.Alias or c.ClientID leads to the error)

What did I miss?

Pages: 1 2 [3] 4 5 ... 9