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

My model is stored in version control (SCC connected PTC) as XML files. I used to reconstruct the .eap file from that version control in case of failure messages from EA, Windows, DOA, ... that I do not understand, in favor of repairing the .eap file.

Sometimes after I do a "Get All Latest" I can find diagrams with connections labeled as "External Reference" - by chance. When I do a "Get Latest" to the contributing packages EA tells me "package is up to date". However, I check "force reload" and - unbelievable - the connections turn to the expected ones, while the label "External Reference" disappears.

Sometimes a known connections is simply missing in the diagram. "Force Reload" on one of the packages hosting the start or the end brings it back - without checking anything out or doing any other change.

When I did not check all diagrams for "External References" I may loose the connections from the model when I check-out a contributing package and check it back in again after some changes. So I have to be sure all(!) connections are there.

Can you imagine a reason and a workaround for this behavior of EA/SCC? Would it be a safe recommendation always to do a "Get All Latest" with "Always import" a second time after the first "Get All Latest"?

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.

General Board / Re: GetRelationSet
« on: March 16, 2018, 01:37:38 am »
Thank you for your help, qwerty, Geert.

I am not at the point identifying the links of an element, just trying to find what elements are linked.
Thank you for the link to Git. However it seems that GetRelationSet is never used there? Perhaps it is the wrong idea using that one to find and later delete relations to other elements?

That is the code leading to 'Object required: '[string:""]' on line 18.

Code: [Select]
option explicit

!INC Local Scripts.EAConstants-VBScript
sub OnDiagramScript()
dim i
dim source as EA.Element
dim currentDiagram as EA.Diagram
set currentDiagram = Repository.GetCurrentDiagram()
if not currentDiagram is nothing then
dim selectedObjects as EA.Collection
set selectedObjects = currentDiagram.SelectedObjects
if selectedObjects.Count > 0 then
dim currentElement as EA.DiagramObject
set currentElement = selectedObjects.GetAt( 0 )
set source = Repository.GetElementByID(currentElement.ElementID)
If(source.Type = "InteractionOccurrence") then
dim all as EA.Collection
set all = source.GetRelationSet(rsDependStart)
Session.Output all.count
end if
end if
Session.Prompt "This script requires a diagram to be visible", promptOK
end if

end sub


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 / Re: EA refuses to show diagrams
« on: March 15, 2018, 11:35:47 pm »
Thank you Sunshine and Cantoni, good to know that the size is not big.
However, I have not seen the obstacle for a few days now - since I converted to Win10.

On Win7 I used an eap file totally local, and repaired and compressed it from time to time.

General Board / Re: EA refuses to show diagrams
« on: March 12, 2018, 07:59:49 pm »
I can have 2 or 10 diagrams open - each should be selectable by its tab. Diagrams usually shall show a few to moderate number of elements (<20). However, the model is not small in size - 50MByte after compression.

I will monitor whether certain open diagrams are part of the open diagrams in order to follow the idea, that a specific diagram is causing this strange behavior.

However, I would like to know if any other has noticed a similar behavior of EA UI.

Pages: [1] 2 3 ... 6