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 ... 8
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?

General Board / Re: Get all latest - out of memory error
« on: June 20, 2018, 08:02:03 pm »
Geert, how is this a solution to the problem?
I am not developing any plug-in or the like. I am just getting this error a few times a day when I do "Get Latest" or "Undo Check Out" or the like with my SCC connection to PTC.
My solution so far is:
  • kill the EA app in Task Manager
  • forget the .eap file
  • reboot windows
  • re-build the .eap file from xmi packages, which are under version control by PTC - that is: Get All Latest

I also tried to repair the .eap file. This works in the first place. However, you may loose elements. I noticed the loss of inter-package connections. - silently!

General Board / Re: unchecked "Show Namespace" as default?
« on: June 13, 2018, 08:34:46 pm »
Thank you for pointing me to that feature - exactly what I was looking for.

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 / Re: different sets of Default Types
« on: June 13, 2018, 06:20:43 pm »
what about customizing the drop down list of default types?
this could also speed up the definition of parameters of operations of e.g. interfaces.
the project offers hundreds of types, but ~90% of parameter types are from a project-specific set of 10 or 20.

Currently I have to open the drop down of the type of the parameter, select "Select Type...", select "Search", type the beginning of the type name, press find, select the the type from the list. Imagine to do that for 50 operations with roughly 3 parameters each. Just to get "unit32_t" instead of "int" or "Integer".

Thank you Glassboy for your suggestion.
However, it does not help much and it happens on computers of several colleagues as well.

My current solution is to stay away fram any .eap file issuing deep and not understandable failure messages.
I created an empty template .eap file that is connected to PTC. Making a copy of it and do "Get All Latest" for a clean and refreshed .eap file.
I also stay away from using "repair" or "compress" as I lost dependencies between packages.

I know that I have not investigate the problems deeply to a proper result. But the effects are that divers, it is beyond my abilities. I wonder wether we are the only project with such problems with the default database an .eap file is using.

General Board / Re: SQL query: how to use "like" in "where" clause?
« on: May 04, 2018, 08:18:09 pm »
Found the answer:

as opposed to the link found in the book of Thomas Kilian, it is "*" to be used, not "%".

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.

Pages: 1 [2] 3 4 ... 8