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

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

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(InvestmentAllocationJob.java:100)
                    at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:740)
                    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.OutOfMemoryError: Java heap space


Environment

Release : 15.9.1, 15.9.2

Cause

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

Resolution

This is DE60926, fixed in 15.9.3 and 15.9.2.1

Additional Information

• Reference 15.9.3 Clarity Release Notes > Resolved Defects 
• Reference 15.9.2 Clarity and Jaspersoft Cumulative Patch README Files 
• SQL Curves - Known Issues  
• Investment Allocation Job - Purpose & Overview