Show Posts
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
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