Investment Allocation crashes BG with OOM due to SQL Curves (DE60926)
search cancel

Investment Allocation crashes BG with OOM due to SQL Curves (DE60926)


Article ID: 214949


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


When running Investment Allocation job, we get a Java Heap Space OutOfMemory error. 

Steps to Reproduce:  

  1. On a large Oracle environment with SQL Curve enabled run Investment Allocation job

Expected Results: The Investment Allocation job to complete successfully. 

Actual Results: The Investment Allocation job never completes and crashes the BG service with OutOfMemory error. 

ERROR 2021-04-14 16:47:17,566 [Dispatch 041421_Investment Allocation : xxxxxxxx (tenant=clarity)] niku.njs (clarity:345196:20692350__F3878325-8820-4388-BAC5-B860D88462AC:041421_Investment Allocation)
Error executing job: 5862051
java.lang.RuntimeException: java.lang.OutOfMemoryError: Java heap space
                    at com.niku.projmgr.service.staffing.job.InvestmentAllocationJob.scheduledEventFired(
                    at com.niku.njs.Dispatcher$
                    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(
                    at java.base/java.util.concurrent.ThreadPoolExecutor$
                    at java.base/
Caused by: java.lang.OutOfMemoryError: Java heap space


Release : 15.9.1, 15.9.2


This started happening in 15.9.1 with introduction of SQL Curves.  This functionality needs optimizations. 


This is DE60926, fixed in 15.9.3 and

Additional Information