Messages

1

General Board / Re: DDL Import  / Reverse Engineering DDL

« on: August 04, 2014, 11:53:22 pm »

The ability to reverse engineer DDL seems like a commonly requested feature since 2002.  As far as I can tell, the functionality does not exist within EA v11.  Instead loading an actual DBMS schema w/ DDL is required.  The ability to import DDLs is important in facilitating collaboration with DBAs and maintaining traceability and synchronization throughout the entire design stack.

• Why has it not been implemented yet?  
• Will it be implemented?   If so, when?
• Is there a way to to view the product pipeline?

2

General Board / Re: "Get All Latest" is potentialy dangerous

« on: July 18, 2014, 12:40:49 am »

Can you clarify?  I did create a local.eap importing .xmi files to reconstitute  the model that we had in the DBMS.  I did not attempt to connect those imported branches to version control (SVN).

In attempt to fix the "get all latest" issue, the DB became corrupted.  We ended up dropping all the tables in the DB, reloading the schema and reimporting the model (form the revisioned XML).  We did not re-connect SVN, all members of our team are currently working from DB model w/out revisioning.

3

General Board / Re: "Get All Latest" is potentialy dangerous

« on: July 15, 2014, 11:44:16 pm »

My posts started @ "Re: "Get All Latest" is potentialy dangerous
Reply #5" and yes I reported the issue.

When a user clicks "Get All Latest" in v11, while in a centralized team configuration (EA v11 + SQL DBMS + SVN).. links get broken.  To restore the links,  I've had to "check out" and then "undo check out" on packages with missing content.  Similarly importing the latest revision of a problem package from XMI also restores the link, but this also has been found to cause collatteral damage, breaking links to other packages (seperate but related issue).    

It seems to me that problems arise with the synchronization between XMI imported data and DBMS data if the entire model isn't imported all at once.   From what I read, "Get All latest" only updates the packages that have changed and that aren't locked.

4

General Board / Re: "Get All Latest" is potentialy dangerous

« on: July 15, 2014, 03:57:58 am »

Hi Simon,

We migrated from a distributed team environment to the centralized team environment about 2 months ago. At the same time we migrated from v10 to v11.  We were not losing links in the previous configuration (v10 + SVN, no central DBMS).  

Tim

5

General Board / Re: "Get All Latest" is potentialy dange

« on: July 09, 2014, 01:28:18 am »

Thanks Simon.   I do believe that we are seeing some kind of bug. Consistently, when we perform a "Get All Latest" while in our our "Centrailized" mode (DBMS +SVN),  data elements, relationships and hyperlinks go missing. This occurs even when there are no other packages checked out.  We are using EA v11 r 1107.  

We now have an internal policy that instructs people not to use this function.

6

General Board / Re: "Get All Latest" is potentialy dangerous

« on: July 04, 2014, 06:54:41 am »

Thanks for the quick reply.   Yes.. returning to working with individual EAPs w/ VC is the next step I was considering.

while the specific xml changes that occur as a result of the UML process are not very meaningful to human-readers, the resulting states of the models are important.  If there is a better way to capture those states when a modeler is "done" editing, than I'd love to hear about it.  

There is a very good chance that I am fulfilling the role of said "blockhead" since there are still quite a few things I don't understand about how EA works.

7

General Board / Re: "Get All Latest" is potentialy dangerous

« on: July 04, 2014, 03:46:52 am »

Thanks Qwerty..  

We have many (>15) users logging in and making changes.   It is important for us to keep a revision history for each change and be able to revert back to specific revisions.  Nightly snapshots is not sufficient version control for us.   Is there a way to accomplish this using a DBMS and no VC?   If so that would be ideal.  

Otherwise.. I'm considering getting rid of the DB altogether and moving back to a distributed SVN only configuration.   We have been hitting a lot of problems w/ this combined Central & SVN configuration.

Thoughts?

8

General Board / Re: "Get All Latest" is potentialy dangerous

« on: July 04, 2014, 12:02:58 am »

We are currently EA v11 w/ a central DBMS & versioning w/ Tortoise SVN.  In "Version Control Settings" for the DBMS managed project we have the "This is a private model" checkbox UNCHECKED.    "Get All Latest" is still available to all of our users.  

The "Get All Latest" action has been performed a number of times causing links in our diagrams and packages to be broken.

According to this thread, Get All Latest" is supposed to be disabled for "shared."  Have we found another bug?  Are we configuring the project properly?

9

General Board / Re: Errors after migrating to EA11

« on: June 26, 2014, 11:38:06 pm »

Hi,

Thanks for your research!

Is there a bug #, or link that shows EA has recognized this as a bug?  We want to track it to see which release its fixed in. z

It looks like this issue might be addressed in v11 r 1107:

http://www.sparxsystems.com/products/ea/history.html#1107


Can anyone confirm?

10

General Board / Re: Association of a WSDL type element witits XSD

« on: April 02, 2014, 07:17:15 am »

Is this conclusion accurate?  I have not found a way to import an xsd into the wsdl via sparx ea.

11

General Board / Re: Share XSD among WSDLs

« on: April 02, 2014, 07:14:08 am »

I have the same issue.  any new information on this?

12

General Board / Re: WSDL generation

« on: April 02, 2014, 04:00:57 am »

I am experiencing the same issue.   Has this been solved in more recent versions of EA (v10 or v11)?  

I am unable to get EA to generate a wsdl that defines an external xsd.

13

Bugs and Issues / Re: Blue Screen of Death after latest OS update

« on: August 27, 2014, 12:27:26 am »

I would like to confirm the same behavior.

When trying to navigate to (or generate report from) a BPMN diagram, the operating system crashes!

Is there a patch for this?
Is there a Bug ID for this?

14

Automation Interface, Add-Ins and Tools / Re: Automatically link Physical and Logical attrib

« on: September 10, 2014, 08:05:31 am »

I am now able to resolve the identity (GUID) of objects that were transformed by the MDA transformation. With this mapping data I can create realization associations between the PIM and the PSM and export JPA annotation data (from tagged values in logical model).

Here is an ugly solution   since there is evidently no Automation interface for XREF data:

Code: [Select]

     //returns an EA.Element (table column) that was generated from a logical models class logicalClass
      function getTransformedClass(classElement) {            
            
            var logicalClass as EA.Element;
            logicalClass = classElement;
            var guid= logicalClass.ElementGUID;
            
            //Session.Output("logicalClass: "+logicalClass.Name+" guid: "+ guid);
                  
            var qry ="select * from t_xref where t_xref.Type='Transformation' and t_xref.supplier='"+guid+"';";       
            var result = Repository.SQLQuery(qry);
      
            //Session.Output("qry for'"+logicalClass.Name+": "+ qry);
            //Session.Output("result: "+ result);
            
            /*
            //Example Dataset result from Repository.SQLQuery() method
            <EADATA version="1.0" exporter="Enterprise Architect">      
            <Dataset_0><Data><Row><XrefID>{23837F97-084A-400f-A51D-1AC275D71EA9}</XrefID><Name>Table</Name><Type>Transformation</Type><Visibility/><Namespace>DDL</Namespace><Requirement/><Constraint/><Behavior/><Partition/><Description/><Client>{243D969E-1F71-47e4-B388-9040F5A73A42}</Client><Supplier>{748E0ED8-4A83-4a4a-8B8E-97598C469DE6}</Supplier><Link>{3FC9840B-3507-4ff8-9E4A-3B64CA18329B}</Link></Row></Data></Dataset_0></EADATA>
            */      

            var startTag = "<Client>";
            var endTag = "</Client>";
            var clientGUID = getXMLValue(result, startTag, endTag);
            //Session.Output("client guid: "+ clientGUID);
            
            /*
            var startTag = "<Supplier>";
            var endTag = "</Supplier>";
            var supplierGUID = getXMLValue(result, startTag, endTag);
            Session.Output("supplier guid: "+supplierGUID);
            */
            return Repository.GetElementByGuid(clientGUID);
            
      }
      
      function getXMLValue(xmlString,startTag,endTag){
            var start = xmlString.lastIndexOf(startTag);
            var end = xmlString.lastIndexOf(endTag);
            
            start= start+ startTag.length;  //adjust for
            var len = end-start;
            leng = len -endTag.length;
            var value = xmlString.substr(start,len);
            return value;
      }


15

Automation Interface, Add-Ins and Tools / Re: Automatically link Physical and Logical attrib

« on: September 10, 2014, 05:54:42 am »

I determined that the "Link Element To Feature" can be mimicked by creating a new connector of type 'Realization'.

Example (javascript):

Code: [Select]

newConnector = supplier.Connectors.AddNew("test binding", "Realization");
      newConnector.ClientID = supplier.ElementID;
      newConnector.SupplierID=client.ElementID;
      newConnector.StyleEx="LFSP="+clientAttribute.AttributeGUID+"R;LFEP="+supplierAttribute.AttributeGUID+"L";