Messages

1

Bugs and Issues / Enterprise Architect Database SQL Issue

« on: February 27, 2025, 08:43:15 pm »

Hi,

we plan to switch from SVN Version control to a Enterprise Architect Database.

Unfraternally most of our Dashboard SQL-Statements are not functional any more since we switch to a Microsoft SQL Database.

One example is this SQL Statement:

select
   sum((select count(*) from t_operation a where a.object_id = o.object_id)) as Operations_count,
   sum((select count(*) from t_object a where a.object_type = 'Activity' and a.ParentId = o.object_id)) as ActicityDiagram_count
from t_object o
where o.Object_Type = 'Class' and o.Name Not Like '%_t%' and ( o.Stereotype <> 'Specification' or o.Stereotype is null)


We got the Error:
SQL API Open FAILED: Cannot perform an aggregate function on a expression containing an aggregate or a subquery.

Is there a workaround available?
Are there options available to enable aggregate functions?
Why is this statement functional on File-Based EA?

EA Version: 16.1.1622
Microsoft SQL Database

Regards Axel