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

General Board / GetRelationSet
« on: March 15, 2018, 11:50:59 pm »
I am trying to write a script (VBScript) that deletes all dependencies of an element. I tried to use GetRelationSet, but can not understand what I am doing wrong: if I put the constant rsDependStart as a parameter I get the failure Object required: '[string:""]'. Shall I pass a string?

BTW: As a "sporadic scripter" in a number of scripting languages, I would like to have a big set of examples that I can search quickly - just to remember the syntax and basic sequences of statements. Currently I am only able to search one script at a time. Any recommendation?

General Board / Exchange Elements by new Imports
« on: March 12, 2018, 07:51:00 pm »
By parsing existing code, I managed to import interfaces and data-types.
However, I found my current procedure to import a new version of the same interfaces and data-types too complicated and not automatic enough.

What would be your solution or recommendation to achieve a somewhat automatic solution?

Kind Regards, Rolf

p.s. for re-engineering I am using SRCML, as well as libclang, resulting in XMI for import.
My current procedure for exchange is: in the model flag old elements as "old" by changing the name, import new elements from XMI, and do the exchange manually. I am also omitting elements from the import-XMI that already exist in the model by the same name and type.

General Board / Not enough storage is available to complete this operation
« on: February 20, 2018, 10:31:46 pm »
I am using EA together with PTC.
Prior to checking out, I used to "Get All Latest" in "Package Control", in order to have all latest changes available.
Sometimes - most probably at times when I have worked some time with EA e.g. on other projects - I get the failure
"Error: Code=0x8007000e Souce=Line:0;Char:0 Error Description=Not enough storage is available to complete this operation."
The only way I found to get out of this problem - other error windows pop up when I close it - is, to kill the EA process using Task Manager.
It does not help to restart EA, but to restart Windows.

Sometimes after restarting, EA tells, that there is some data base problem an I have to repair the eap file.

I am using Win7 with 16GByte, Task Manager Performance show less the 8GByte have been used.

Any advice to avoid this problem (looks like a memory leak somewhere).

Kind Regards


General Board / EA refuses to show diagrams
« on: February 20, 2018, 10:15:53 pm »
Sometimes, ~ 2 times a day, I ran into the situation that EA constantly shows one diagram. If I click any other diagram a new tab shows up and seems to be selected, but the content of the screen does not change to the selected diagram. Still the same that is constantly shown.

I can click any other tab - representing an opened diagram - the tab has changed color, looks like if it is selected, but the content of the main area of the window has not changed - still showing the constantly shown one.

One exception is, when I select the "Start Page" tab, that one shows up - but now this is the constantly shown main window content. I am not able to change the window content regardless what I am doing in EA.

It does not help to close and re-open the project in EA. The only work-around I found so far is closing and re-opening EA. Is there any better advice?

I am using EA build 1351 on Win7.

Kind Regards


General Board / different sets of Default Types
« on: January 30, 2018, 08:00:24 pm »
Why are the default types used for parameters and returns in operations different from those used with action pins and object-nodes?

The problem:
I used to explain an algorithm designed for an operations by one or a tree of activity diagrams. Traceability "by-name" requires to have action-pins or parameter-object-nodes in activity diagrams as of the same name and type as those used for the definition of the explained operation e.g. in an interface specification.

Many of these data flows are of simple types. I would like to use default types as to be quick in specifications. Taken the two different sets of default types, this is not possible. I got forbit to use default types for all designers.

Alternatively - and even better - I would like to populate the default types selection drop-down menu, in order to use my own set of base types.

Example using default types:

operation(par: int): boolean

(input) action-pin: Integer
(ouput) action-pin: Boolean

This can hardly be sold as traceability, at least it would be needless added complexity.

General Board / SCC interface to PTC of EA does not find Unique IDs
« on: January 10, 2018, 06:26:46 am »
What I did:
check-in the top-most and other packages as items in PTC, PTC has an SCC integration by a Unique ID for this EA project.
in PTC enabled SCC integration on a colleagues PC (as win7 administrator)
created a sandbox of that PTC folder on that PC.
created a new empty project in EA.
tried to configure Version Control by selecting the local path of the sandbox.
selected "MKS SCC Integration" for the field "SCC Provider" (the only choise)
opened the "Unique ID" pull-down to select it for the given EA project stored in the given PTC sandbox.

What I expected:
a list with just the Unique ID to appear in the pull-down - as known by PTC and probably derived by SCC and EA from the sandbox.

What I got:
an empty list - I cannot have EA to link to the Version Control Settings of the EA project found in the sandbox.

What I checked:
I can - and some colleagues can do also - create a new project from the PTC sandbox on the original PC and colleagues PCs.
I checked every step on my and on the colleagues PC to be sure they are the same.
I restarted EA, I rebooted the PC, ...

Nothing helped.

It seems that sometimes or for some reason EA is not able to find the available Unique IDs associated with the PTC sandbox.

What could cause this missing linking?
Or: what would be a next step to find out?

General Board / Plugin of Script?
« on: October 18, 2017, 05:12:21 am »
In order to speed up my everyday work I need to automate (put on a shortcut key)
- right-click on an element / Advanced /  Use Circle Notation (preferably for the set of selected elements)

As I do not have any experience in writing a plugin or a script I tried to find out, what would be the best.
However, I found several tutorials that would bind me a day or so, but I could not find out whether it is possible what I am trying to achieve.
Is it possible?
If so what the closest example to choose?


Pages: [1] 2 3 4