For more specific/precise assistance we can probably follow-up through the support ticket you raised on this subject.
In general terms: since the version you were on previously, which (if left unchecked) allowed custom configurations to make such huge demands on the system that they could essentially break it and cause an outage, a number of 'governor' properties have been added to put a cap or limit on how much data can be consumed in one go.
For On-Premise customers, the location of the file that has most of these controls can be found at $NIKU_HOME/config/governors.properties
E.g for the default value on this particular setting:
#Maximum GEL rows allowed
MAX_SQL_GEL_ROWS=100000
So it would seem you are running a query in your process that is taking more than 100k rows at a time - quite an excessive burden for both the application and database - and could benefit from being refactored with a loop and pagination.
For the short term, you may want to raise the value temporarily in the properties file and restart your bg services.
However I would stress that this should only be for the short term - I would say that as inconvenient the governors might seem, the amount of outages that occur due to careless configurations has been reduced significantly since their appearance.