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 - Shegit Brahm

Pages: [1] 2 3 4
Hi there,

while exploring the world of RAS (Reusable Asset Service), I stumbled upon this error while I do the mandatory dependency check before registering an asset:

Microsoft OLE DB Provider for ODBC Drivers [-2147217865]

[MySQL][ODBC 5.3(w) Driver][mysql-5.7.24-0ubuntu0.16.04.1]Table 'EA_RAS_Client.t_taggedValue' doesn't exist

the creation code says:
Code: [Select]
CREATE TABLE `t_taggedvalue`
`PropertyID` VARCHAR(40) NOT NULL,
`BaseClass` VARCHAR(100) NOT NULL,
CONSTRAINT `pk_taggedvalue` PRIMARY KEY (`PropertyID` ASC)
COLLATE utf8_general_ci


This page indicates, that there might be a problem with different OS and their settings - just the EA script uses only lower case.

And the DB also shows me the table, all lower case.

Any idea what I could do about it?
Searching for first error line brings up (mostly) "you are connecting to a mispelled table" - so the mysql statement might be all.
Just ... the table created by Sparx' script is lower case.

I would claim that after the initial setup, there was no such error.
Maybe it was only an error on one of three DB's and while I moved assets from a to b to c and vice versa - this error got "exported"?

Or is it a bug inside RAS feature?

Thanks, Shegit

General Board / Re: How to setup a RAS (Reusable Asset Service)? [solved]
« on: November 15, 2018, 11:40:33 pm »
    @Graham_Moir: thanks for your encouragement.

    I digged deeper and will post some major "ah"-moments.

    • smallest unit: empty package
    • => package is general unit
    • => no single element can become an asset
    • latest version is the highest version number EA says - not always the newest
    • change an asset?  - make a new version!
    • merge: only from baseline (e.g. one asset version) into local model - there is partial / elementwise merge=import possible (local delete as well)
    • access different version: the dropdown does appear only if you know to look in the version column
    • same guid? - "crashes/ mixes up" more or less like an xmi import with same guid on different elements

    • will be treated as separat assets - and dependent version will be saved, too

    • password(s) can be set - once all passwords are gone / never set => no new password(s) can be set
    • as long as you have access to a storage, you can easily copy it
  • lost password? guess this is the encrypted version (xmi export):
Code: [Select]
<code header1="dY1h8mpERIOE5cRGig3Leiq+RWBnsPe1BbwouUEf6TE=" header2="dY1h8mpERIOE5cRGig3Leiq+RWBnsPe1BbwouUEf6TE="/>

    be careful
    • you update two assets and the second is dependency of the first and you register new version of first asset?
      • please avoid using "use latest version in registry"
      • that would ignore your current local changes of second asset
      • untick it and register second asset with a new version from local project
      [li] take a look, if the "latest version" is really the newest - the dropdown has them in created-order

    • the version name permits these characters <>;:“/\|‘,?*
    • well, it checks in advance to registering on these only
    • it DOES NOT check on any non-english characters BEFORE saving into registry server
    • it does realize this error few seconds later while the storage got reloaded to show changes
    • that crashes entire registry server regarding read and write (all storages)
      • I was lucky and could just delete the storage in registry server ea model (because nothing else was in it)

    HTH, Shegit

    General Board / Re: How to setup a RAS (Reusable Asset Service)?
    « on: October 11, 2018, 01:13:48 am »
    Was easier than expected.

    the "registry server" is nothing more than a simple EA cloud connection with a model stored as real DBMS instead eap.

    That means:
    • set up a cloud based EA model.
    • have your second model at hand (with sufficient rights)
    • go to Publish -> (model Exchange) -> Reusable Assets-> Registry: select the EA model set up in first step
    • now you are connected to the central registry server

    That said - I can't tell you right now the sufficient rights to do what inside RAS etc.

    Assets can become what I create locally and "register"=export them into the cloud model.
    And importing from cloud model creates local copies.

    As far as I digged until now: GUIDs will be "central" at the cloud model and whereever you import from there, EA will (try to) set the central GUID.
    Which implies: can't tell you now what happens if I have a local GUID for a different element and the import it from cloud.


    General Board / How to setup a RAS (Reusable Asset Service)? [solved]
    « on: September 12, 2018, 09:26:22 pm »

    this RAS feature sounds nice. So my object is to find out - what is possible, which (technical) limits exist etc.
    (Have EA Enterprise 13.5 at hand)

    I started reading on Sparx' page to get started (setting up)

    My problem starts in the second sentence of the first step (identify registry):
    - The Registry server holds the Storages of the Reusable Asset Service.
    - It will have been previously configured by your system administrator, to be accessed through a Cloud Connection.

    Because - I am in that case the system administrator and - I struggle to find any "next" page what I need to do to get a "registry" up and running.

    I have a server, where the Sparx EA service is running.
    I can create a database (MySQL), initialize it as an EA repository.
    Take the connection details, open an local EA on a client machine and connect. And model my way through.

    So my first question is:
    - Which components must be up and running to create a registry server? (And how do I connect to it?)

    I am able to open the RAS view on my local EA, right now it is empty.

    Than there is the second part: also notes that I should do it on the Registry Server
    - How do I get there?

    After anything is up and running, I guess this is more easy:
    - Do I create a storage from my local machine? The part of "Create Storages" implies it.

    Many thanks,

    Hi Patrick,

    thanks for your offer.
    In between I downloaded Yakindu EA-Bridge and checked the tutorials, worked in over 90 % of the steps.

    I was not able to connect to a selfmade eap file and my focus is in the first step not a full semantic check. I thought I start low to just read EA elements, make them in Eclipse diagrams visibile and manipulate them. And vice versa.

    I got the example from Sparx' automation page running and load a small eap file as Repository class into eclipse - however that is far from "import an UML model".

    If I understand you correct, you say that your current work will result in something like this?
    In that case I'm looking forward to your personal message in this forum to talk about how I might get hands on your new feature.

    Thank you very much,

    Hi there,

    I have an EA 13.x with MDG to evaluate how to combine an EA model with Eclipse (photon), like the UML models or code stuff.

    My aim is to get a vice versa connection between these two "UMLable" platforms. To add stuff here and edit it there and an update has both on same level.

    My (main) question is:
    • What did / do you use successfully and which way?
    • What would you recommend to use / have a look at?

    The build-in extension from Sparx cannot cope with declarations like "static class Swapper implements Sorter.Swapper" - EA kills "Sorter." which is not nice.  And it shows eclipse warnings as errors, at least it builds the project anyway. And if I change code, the build transfers it - it is just not offered while using "merge with eclipse".,37328.msg234218.html#msg234218 pointed out how to get the feature inside EA running to get a connection itself to eclipse (copy sparx jars into eclipse folders). It just did not appear inside eclipse gui - only under "installed software - plugins" are two mentioned.
    The official guide does not tell anything that or how I could use it from eclipse side. And it is from 2008.

    Regarding this post,39647.msg244365.html I tried also Luna (=4.4), but behavior was the same with photon. (mentioned above)

    openArchitectureWare with EclipseLink like suggested here,28169.msg212539.html is no option any longer since it is discontinued in 2008 with 4.3.1 and no download available - and I don't understand how the "successor" Xtext and Xpand fill the "gap" between EA and eclipse. They seem to focus on DSL building instead.

    I tried to get in contact with the guys from modelbus (see,30833.msg223984.html), but they lack time to answer. Just their descriptions sound more than wanted.
    The Yakindu EA Bridge I still need to look at. As well as on "export UML to eclipse" suggestion

    Thanks for reading and some ideas,
    Shegit Brahm

    Hi there,

    I try to generate a documentation on package_1 by using virtual documents, see project browser structure:
    • Package_1
      • UC diagram
    • (...)
    • Package_5
      • sub package_5.1
        • sub sub package_x.y.z
          • UC1
            • AD (Composite of UseCase)
              • Activity
                • Action1
                • (...)   
                • Final
                • Initial
          • UC2

    • UC diagram - UC: UC imported as “Link” in diagram
    • UC - AD: AD is composite child diagram of UC, stored in same package as UC
    • AD - AD elements: AD elements have the activity as parent and are stored in same package

    There's need to get UC diagram, UCs, AD, activity, action, (…), initial and final included in that documentation.

    The first approach to get that done was to use template and fragments. The resulting documentation contains UC diagram, UCs, but neither AD, activity nor anything being a child-child of the UseCase.

    So I turned to virtual documents. In order to grab the missing AD and its diagram elements and get them reported, I tried to create a model search applied as tagged values of a model document.

    But it turned out that my created model search doesn't work. I think, my approach of implementing a model search into a model document isn't correct.
    Beside any general solution to my context I think I need to understand first:
    How to use model search in model document?
    Where do I have to write what? The modal search as a query is a custom sql of a fragment within the template that is chosen for the modal document?

    I was unable to use the help in to get a working virtual document that uses a modal search. The semi-automated approach published there by Geert is not “copyable” for me because I need to start on a package, not a diagram.


    PS: If you prefer to revitalize the old thread as it seems to be the topic: short notice and I will to so.

    General Board / Re: How to create / design completely new elements for EA?
    « on: February 09, 2018, 03:22:49 am »
    Thanks for your hint.

    Do I understand it correct that the EA uses the UML as base for any of the listed technologies?
    At least XML is used to describe everything while exporting it.


    General Board / How to create / design completely new elements for EA?
    « on: February 09, 2018, 01:12:42 am »

    in my understanding there is a vast variety of toolset available for EA.
    OMG modeling like UML, SPEM, SoaML, BPMN and others like ICONIX, DatabaseModeling, Win32 User Interface, NIEM.
    These come with there own element description the EA can work with.

    I already configured UML profiles and created toolboxes, providing them via MDG Technology.

    How to create something "new" that is not derived from existing models?

    Own elements with there own shape and stuff.

    The problem I want to solve?
    Well there is an new interface description in research and I'd like to model with it.
    Right now I would use an UML Profile which comes up with stereotypes and stuff, but it is not "right" as it is yet not based on the UML.


    As far as I understand is ctrl+f the project wide search where I could test the select step by step as it "grows".

    Well, did that already.

    And I also add some text outside the custom> <custom tags to see if I entered the fragment (everything inside these angle brackets gets printed only if the fragment query itself returned something.

    I understand that I need simple fragments that return only #objectid# etc. to use that knowledge and replace #OBJECTID# inside search with hard numbers.
    => Instead " ob1.object_id = #OBJECTID#" I transform it for the search into " ob1.object_id = 524 "

    Because my fragments usually start on a package that contains only a diagram and no elements - so I'm unable to start the search on the package or the diagram as there is no "CurrentElementID" if there is no element the search starts on  (

    Unless someone knows any other options, I mark it as solved with workaround.


    Hi there,

    I'm writing template fragments and need to play around with the SQL queries as I'm not that familiar with it.

    Now it happens that I get more or less useful error messages from EA and I wonder: which way could I use to debug a template fragment?

    I tried to create a search first and use it. It seems that it's not always possible - should it be?
    (like usage both of #PACKAGEID# and #OBJECTID# inside a query)

    Even if I don't get an error, the fragment does nothing because my query didn't deliver anything - so I need to evaluate why.


    Hi you three,

    thank you very much for your suggestions and links.

    I will take a look at it and if I have specific questions, I will post them in new topics :-)

    @Nizam: I read that page from Sparx, I just didn't manage to have the script-called fragment to insert anything inside PDF

    @Geert: I avoided RTF until now, so I will try to forget RTF experiences from outside EA and start over again.

    @Nabil: thanks for providing a full eap, will take a look.


    Hi there,

    I have following situation:
    I'd like to use as much onboard mechanics as possible to create a customized PDF of a package's content.

    EA has build in the way: F8 on a package and selecting some templates (front, toc, main) and set some options and ... voila, a PDF is generated.

    What I think I don't want: write my own addin. Because the more "wysiwyg" is visible via template and the less code, the better for maintenance by other people (I suppose).

    The tricky part already started that the achieved PDF is that individual, that I start with a template, go over to a fragment with TemplateSelector and run specific fragments.

    In my attempts I figured out that a TemplateSelector can only decide by element type and a sql query misses something like "if then else". Because I would need for each table a fragment - otherwise the tables got mixed up.

    So I'd like to point the template to a JScript-fragment which should point to a fragment again. (JScript instead VBScript by flip of a coin)
    Because I want to decide e.g. on element's colour which I cannot so far by using a template selector.

    My questions:
    - Is that possible, to go from a template to JScript then to a fragment and having everything inside the PDF which is created by the template in the first place?
    - Where can I read about it?

    I'm able to pass the object id and package id from template to JScript  - main(#OBJECTID#, #PACKAGEID#) - and create a separate document (Class EA.DocumentGenerator).
    I just tried to read through EA pages and examples and don't know which keywords I need to look for.

    Thanks, Shegit

    @Simon M:

    Thanks for your answer, that fits to my intention of my question.
    So the license management of a company decides to have everywhere e.g. the same minimum off functionality over all users (or whatever the reason finally was).

    In mentioned situation it was already a service based keystore as I had to enter a server address the very first time and never again.
    So support fixing the problem also did nothing else than installing new on top.

    Thank you!


    I was working on a costumers notebook with EA and one day I was told that my EA version / build does not fit the requirements to gain a license.

    Support just installed the newest version and everything was fine.

    Now I want to know: as for my own company - do "I" as the license server owner configure it that way? Or does it come together with bought (corporate, floating) licenses as a default feature?
    I didn't find any answer on sparx or google.

    In earlier scenarios a file based keystore allowed EA 7 as well as  and EA 9 and EA 11.

    So who decides which version I need to have in a floating license environment? Sparx or the company?


    Pages: [1] 2 3 4