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

Pages: [1] 2 3 4
General Board / empty t_seclocks.EntityIF, what to do about it?
« on: August 23, 2018, 06:22:33 am »
Switched from .eap-files to SQL Server based storage of EA model.
Transfer to .eap-file worked fine till today.

I got the message: "An error has occurred: DAO.Recordset  [3314], The field 't_seclocks.EntityID' can't contain a Null value because the Required property for this field is set to True. Enter a value in this field. [Select * from t_seclocks], Field: locktype. Press OK to continue to next row (this record will be lost). Cancel to abort

Ok, I entered the SQL query and got 5 lines as a result. In one of them the field below the column heading EntiyID is empty. Guess that causes the problem. (I do not know how it got there, I was using EA heavily, but interactivily only.)

What shall I do about it? Transfer the result back, so that that record disappears from table t_seclocks? What will be the consequences?

General Board / EA14 and non-modal windows
« on: August 10, 2018, 12:14:20 am »
I love to work with non-modal windows, e.g. Features & Properties in EA14. There too many modal windows in earlier versions.

However, I ran in to a situation where the attributes of any data type or enumerations are not shown. Restarting, even rebooting Win10 did not solve the problem. The attributes are still there, I can see them in the project browser.

Do you got any idea what I missed?

Meanwhile I switched back to modal windwos and EA13.5 - there I can do with the attributes what I like to do.

General Board / Project Integrity Check
« on: August 08, 2018, 03:28:20 am »
When I do a Project Integrity Check, I got one issue: The top-most package, the model itself, is flagged as "Orphaned object" and the check proposes the action "Delete Package Object". Obviously I do not follow that recommendation.

How to get a clean integrity check?

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


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?

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?

General Board / unchecked "Show Namespace" as default?
« on: June 13, 2018, 06:47:31 pm »
Is it possible to have "Show Namespace" unchecked as the default when creating a new diagram?

General Board / SQL query: how to use "like" in "where" clause?
« on: May 04, 2018, 08:13:49 pm »
I tried like

select * from t_xref where Description like "%stereo1%stereo2%"

without success. I could not find any "like" example on Geert Belekens website or in the book of Thomas Kilian.

I remember that there was a way to show just the topics I have created. But I forgot how and can not find the button or procedure.

After logging in, to the Sparx Systems Form
when clicking on "" I get the failure "Database Error: Please try again. If you come back to this error screen, report the error to an administrator."

It is the same behavior regardless of OS (tried Win10 and Debian Linux) or browser (tried IE, Firefox. With Chrome on Win10 I am not able to login.)

Also I would be able to search for latest entries of a certain person, without specifying a subject. Is that possible?

Pages: [1] 2 3 4