The Query is not valid. A derived table query must start with Select and contain at least 4 words or attributes placeholder.
<Please see attached file for image>
When you write a query using below as example or doesn't start with SELECT * FROM TABLENAME.
(the aggregation SQL statement)
(query naming subquery_name);
This is a known bug with Jaspersoft and the bug number is JS-27554
CA PPM 14.2 and above with Jaspersoft
Please alter your queries and start with SELECT * FROM TABLENAME.
Note: This impacts only writing queries at Domain Designer and doesn't impact writing queries using Jaspersoft Studio