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 - Ian Mitchell

Pages: 1 2 3 [4] 5 6 ... 17
General Board / Archimate2 Metatypes and SQL
« on: March 24, 2016, 07:45:00 pm »
My customer is using Archimate2, and has a large model, developed over many EA releases.
They are now seeing some pain from how Archimate_Location elements are stored, as their model has saved them in two ways, and we don't know why.
Looking in the database, some Archimate_Location elements have Object_type="Class", some have Object_type="Location".
Has something changed across EA releases? This seems possible because when opening the properties of a 'Class' style element, then closing it (without changing any data), it got saved back in the database with object_type='Location', and a new 'modified date'.
This would normally not be a problem, because the UI makes everything look OK, but our model-quality analyser is flagging errors because we have the same 'thing' stored in two ways.
Has anyone seen this before?
Also, when I run a query to find these things in a test repository with a few brand-new Archimate_Location instances, the SQL seems to vary the results I get: for some queries, the object_type='Class' , for others object_type='location'. Sometimes both IN THE SAME QUERY. The Object_Type just seems to randomly say 'Class' or 'Location'.

Automation Interface, Add-Ins and Tools / Re: Another error using SQL
« on: March 16, 2016, 10:43:37 pm »
Ok - Geert's suggestion fixed that last one - of course - but it has uncovered others.
I've done some more research on this, and I think it may be to do with the size of the results set.
Queries which return large result sets (a 16Mb (string size) definitely throws the error) seem to throw this error - smaller ones don't.
Is there a restriction ?

Automation Interface, Add-Ins and Tools / Re: Another error using SQL
« on: March 16, 2016, 01:36:36 am »
Pure genius - it works now!
Thanks Geert

Automation Interface, Add-Ins and Tools / Re: Another error using SQL
« on: March 15, 2016, 03:29:25 am »
Honestly, I had no idea that DBError.txt existed. 12 wasted years using EA.
But anyway, it just contains an error from earlier today, just a simple SQL syntax error - nothing to do with this, so no help there.
So I'll try Helmut's suggestions- thanks.

Automation Interface, Add-Ins and Tools / Re: Another error using SQL
« on: March 14, 2016, 10:28:19 pm »
Update: Just tried using SQLServer, and that also works OK in a Search, but throws the same error when called via the Repository interface.

Automation Interface, Add-Ins and Tools / Another error using SQL
« on: March 14, 2016, 10:24:25 pm »
Trying to use the the SQL:
" Select, Object_Type, Stereotype, COUNT(*) from T_OBJECT  "
 group by, Object_Type, Stereotype "
(which finds duplicate elements in a model)
  • Works fine in the model search with EAP file
  • Works fine called via Repository.SQLQuery to EAP file
  • Works fine in a model search with mySQL
  • Doesn't work with Repository.SQLQuery in mySQL
..and the error is the one so often mentioned in this forum:
Error: Code = 0x0 Source Line: 0; Char : 0, Error Description = (null).

This is an especially nasty error because (a) it's very unhelpful and (b) keeps repeating until the use crashes EA.
Other forum items suggest changing the SQL a bit, but this really is what I need the query to look like. About the only change possible is to change the select(*) to a select(Name), but that doesn't work either.
Does anyone have an ideas either (a) how to get around this or (b) how to get more helpful error message from EA ?

General Board / Re: BPSim and intermediate event
« on: February 25, 2016, 04:23:17 am »
In the recent Webinar on BPSim, i asked if we could have a style-guide, so we can understand which BPMN constructs are acceptable to BPSim. Such a guide might help with questions like this ?

General Board / Re: When is an instance not an Object?
« on: February 25, 2016, 04:20:15 am »
Whilst I'm obviously fascinated by the discussion on how UML-compliant EA is (actually, that's a lie - I don't care at all), my question is still un-answered, despite Uffe's wonderful and helpful post - ( "this is weird:))
Simply re-stated, hoping Spaxians will answer:
  • which of the built-in EA element types create instances which have object_type= 'Object',
  • which create instances which have the same object_type as their Instance Classifier?
There must be some code somewhere in EA which makes this happen, and I'd just like to know what it does.

General Board / When is an instance not an Object?
« on: February 20, 2016, 02:04:07 am »
When we create EA Instances of EA things (Class, Use case, Actor etc) then EA creates a new entry in t_object, with Object_Type = "Object", and an instance classifier which points to the relevant 'thing'.
But when I create an instance of a 'DeploymentSpecification', I get the correct instance classifier pointer, but the instance 'thing' has an object_type="DeploymentSpecification", not "Object".
Are there other EA meta-types which create instances which aren't "Objects"?
Seems like the only way to distinguish between an instance and a 'thing' is the presence of the instance classifier, but that doesn't seem quite right....
If this a bug?
Or a feature?

Suggestions and Requests / Re: Improve text format options in notes field
« on: November 06, 2012, 03:43:24 am »
With my eaDocX hat on, I'd welcome your first point: richer text in the description field would add greatly to readability: so long as the HTML which Sparx keep in the database is well-formed (which it isn't always at the moment).
I also agree with the second point, but I can see how that would be hard for Sparx to implement given the DB structure. The alternative is to connect the elements with a connector, then the target element name can be printed in an eaDocX document, without maintaining the name. But that does move the reference from inside the Notes field, which changes your model structure.....:-(

Ian - Designer, eaDocX.

Suggestions and Requests / Re: Ability to change text direction
« on: May 22, 2012, 07:29:37 pm »
I can't give the changes you want directly in EA, but eaDocX will give you much greater control of text styles etc when documents are generated.
We also managed to get Vertical text into our Relationship Matrix!
So, have a look at eadocx
</product plug>

Suggestions and Requests / Re: Multi-item edit at the same time
« on: September 17, 2014, 02:25:13 am »
..which is why we wrote the Excel bit of eaDocX to solve exactly this problem. Export a whole load of stuff to Excel (eaDocX / Open in Excel) then edit it using all the Excel bells & whistles, then just save the result back into EA.

Suggestions and Requests / Re: EA 11 wishlist
« on: April 15, 2013, 02:10:38 am »
...and then, Sparx joined the discussion, and said.....

Suggestions and Requests / Re: EA 11 wishlist
« on: March 22, 2013, 10:26:53 pm »
There is also a discussion running on the LinkedIn EA User Group forum on "What I'd like to see in EA V11" .
It would be great if someone from Sparx could comment on it - there are some great ideas, and so far, it's just EA fans contributing.

Suggestions and Requests / Re: Image library showing its age
« on: July 10, 2013, 06:15:00 pm »
I'm sure one of those computers has a floppy drive :-)
(for those under the age of 40, Google it...)

Pages: 1 2 3 [4] 5 6 ... 17