Share all details related to your problem, including any error messages you may have received.
We have been trying to troubleshoot issues in our lower environments. We try to run aggregations; however, they get hung and stall. We then have to restart Tomcat in order to stop the process completely. I looked up the connections in the database and they are too high for very minimal things running. I went to the database to check what the connections say and most of them have "set implicit_transactions on " and stay open. We have tried removing the applications and re-creating. I will say that our lower environment are set up with a single server and multiple databases. Each developer has their own database within the same server. The tasks were working fine, but they started hanging up so we had to completely remove them.
Seems more an performance issue to me. Can you share more details about one of the single servers/db/instance of IIQ? What are the Tomcat/JVM settings? Do you get any OOM error in the tomcat logs?
Please, first of all check if your envioroment and infraesture meets the requirements of database version, Tomcat version, JVM configuration, JDK , operation system etc…
There’s no simple answer to this kind of problems - there might be a lot of reasons why it’s happening,
I would start like colleagues before me mentioned with sharing this config but additionaly I’d like to see your config of the aggregation task, server object xmls and would be great if you could trace some logs that you have once the problem occurs.