Problems with Oracle database

[ccampetto1]

I'm trying to upgrade from EJBCA 7.9.0.2 Community to EJBCA 9.3.2 Community, using an Oracle database. When I start the new ear i get the following error

2026-05-06 10:39:14,482 ERROR [org.jboss.as.ejb3.invocation] (TimerScheduler - 2) WFLYEJB0034: Jakarta Enterprise Beans Invocation failed on component CrlStoreSessionBean for method public abstract org.cesecore.certificates.crl.CRLInfo org.cesecore.certificates.crl.CrlStoreSession.getLastCRLInfo(java.lang.String,int,boolean): jakarta.ejb.EJBException: org.hibernate.exception.
SQLGrammarException: JDBC exception executing SQL [select * from (select max(c1_0.cRLNumber) c0,rownum rn from CRLData c1_0 where c1_0.issuerDN=? and c1_0.deltaCRLIndicator=-1 and (c1_0.crlPartitionIndex=-1 or c1_0.crlPartitionIndex=0 or c1_0.crlPartitionIndex is null)) r_0_ where r_0_.rn<=? order by r_0_.rn] [ORA-00937: not a single-group group function

https://docs.oracle.com/error-help/db/ora-00937/] [n/a]

It looks like an error in the query string. Could you please help me?

[primetomas]

Is it Oracle 12c?

[ccampetto1]

Diffusione Limitata It is Oracle 11.2.0.4 Da: Tomas Gustavsson ***@***.***> Inviato: mercoledì 13 maggio 2026 12:18 A: Keyfactor/ejbca-ce ***@***.***> Cc: CAMPETTO CLAUDIO ***@***.***>; Author ***@***.***> Oggetto: Re: [Keyfactor/ejbca-ce] Problems with Oracle database (Discussion #1047) Non ricevi spesso messaggi di posta elettronica da ***@***.******@***.***>. Scopri perché è importante<https://aka.ms/LearnAboutSenderIdentification> Is it Oracle 12c? — Reply to this email directly, view it on GitHub<#1047 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BD6TH4TOGVC76B5WQBDV3SL42RDUBAVCNFSM6AAAAACY22BKRCVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTMOJQGMZTENI>. Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>

…

________________________________ Le informazioni contenute in questo messaggio di posta elettronica sono da considerarsi riservate e confidenziali. Il loro utilizzo è consentito esclusivamente al destinatario in indirizzo e ne è vietata la diffusione in qualunque modo eseguita, salvo che ne sia data espressa autorizzazione dal mittente. Nel caso in cui il messaggio Le fosse pervenuto per errore, La invitiamo gentilmente ad eliminarlo in modo permanente dopo averne dato tempestiva comunicazione al mittente e a non utilizzare in alcun caso il suo contenuto. Qualsivoglia utilizzo non autorizzato di questo messaggio e dei suoi eventuali allegati espone il responsabile alle relative conseguenze civili e penali. This communication is confidential and the use of the contained information is allowed solely for the intended recipient. Its disclosure, distribution or copying is prohibited, unless expressly authorized by the sender. If you receive this communication by mistake please notify us and delete the message and its attachments. Anyone responsible for the unauthorized use of this message and its attachments is liable to face legal consequences.

[primetomas]

Newer versions of Hibernate, which is the persistence layer of WildFly seems to have this issue with old versions of Oracle.
"Extended Support ended for Oracle Database 12.1. 0.2 in July 2022 and for Oracle Database 11.2. 0.4 in December 2020", so your version is really old and not supported by Oracle any longer. I suggest to upgrade your Oracle database.