Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: philchudley on July 28, 2011, 12:46:26 am

Title: SQL Search failing on Model Document
Post by: philchudley on July 28, 2011, 12:46:26 am

Hi All

Having read the user guide, it is very specific as to what MUST be included in a custom SQL search for use with a Model Document element (search specified by a tagged value)

Here is my search

from  T_Object a, T_Object b, T_ObjectProperties
where b.Name = '<Search Term>'
and a.Object_ID = T_ObjectProperties.Object_ID
and T_ObjectProperties.Property = 'DBApplicationModuleRef'
and b.ea_guid = T_ObjectProperties.Value

When run from the search view, all is well and I can select the items listed in the result, right-click and generate my documentation using a rather simple RTF template

BUT, when set as a tagged value in a model document, a suitable value entered in the search term tagged value, it fails every time with a rather unhelpful message

"Documentation Generation Failed"

I have checked the usual suspects

I have not got any packages in my Model Document element
The search most definately returns a list of elements

Any ideas?

I did also try a very simple sql search (the one in the user guide), that also failed in the same way!

I using the latest build of Version 9.0, but it also fails in Version 8.0

Cheers

Phil

Title: Re: SQL Search failing on Model Document
Post by: philchudley on July 28, 2011, 12:58:30 am

Sorry all,

My SQL search on the initial post was not the right one!

Here is the complete search that is failing

select activity.ea_guid as CLASSGUID, Object_Type as CLASSTYPE
from T_Object activity left join T_ObjectProperties taggedValues on activity.Object_ID = taggedValues.Object_ID
where taggedValues.Property = 'DBApplicationRef'
and taggedValues.Value = (select ea_guid
                                         from T_Object where name = '<Search Term>')

Title: Re: SQL Search failing on Model Document
Post by: snoack on August 22, 2011, 10:29:18 pm

Same situation here.
All model documents with SQL queries that used to work perfectly with v7.5 now fail with v8.0.

This is a major bug because sql queries are the only way to evaluate specific information that cannot be seleted otherwise.
As a result we now have to change the templates and spend hour deleting unwanted stuff from our documents.

 >:(  >:(  >:( - S. Noack