Hibernate unexpected end of subtree error

Question

hi i'm trying to do a query with JpaRepository and it launches the error in the title, the query is the following:

@Query(value="SELECT NEW com.example.dto.NotifichaDTO("
            + "(select count(*) from ComunicazioneEntity where fkRisorsa = ?1 and dataVisone is null), "
            + "(select count(*) from richiestaAssenza where fkRisorsa = ?1 and statoRichiesta is null), "
            + "(select count(*) from ritiroAssenza RA, richiestaAssenza AE where RA.statoRitiro is null and RA.fkAssenza = AE.idRass and Ae.fkRisorsa = ?1), "
            + "(select count(*) from Documento where fkRisorsa = ?1 and dataFirma is null)"
            + ")"
             )
List<NotifichaDTO> getNotifiche(Long matricola)

what could the mistake be? I'm legit confused. The names of the enities and field are all correct. The app doesn't even startup it launches the error on boot not on execution.

The complete error:

Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [SELECT NEW com.example.dto.NotifichaDTO ((select count(*) from com.example.demo.model.RichiestaAssenzaEntity where fkRisorsa = ?1 and statoRichiesta is null), (select count(*) from com.example.demo.model.RitiroRichiestaAssenzaEntity RA, com.example.demo.model.RichiestaAssenzaEntity AE where RA.statoRitiro is null and RA.fkAssenza = AE.idRass and AE.fkRisorsa = ?1), (select count(*) from com.example.demo.model.DocumentoEntity where fkRisorsa = ?1 and dataFirma is null))]
    at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:74) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
    at org.hibernate.hql.internal.ast.ErrorTracker.throwQueryException(ErrorTracker.java:93) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:282) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:192) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:144) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:113) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:73) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
    at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:162) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
    at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:613) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
    at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:725) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
    ... 85 common frames omitted