Investment Allocation job Fails Intermittently

Products

• Clarity PPM On Premise

Issue/Introduction

The Investment Allocation job fails intermittently when scheduled.  

ERROR 2019-03-24 19:49:32,730 [Dispatch Investment Allocation : [email protected] (tenant=clarity)] niku.njs (clarity:admin:11070333__7946A8EE-AAAF-4EDB-9385-011F42FA2628:Investment Allocation) Error executing job: 5012026
java.lang.RuntimeException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-03106: fatal two-task communication protocol error

    at com.niku.projmgr.service.staffing.job.InvestmentAllocationJob.scheduledEventFired(InvestmentAllocationJob.java:100)
    at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:657)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-03106: fatal two-task communication protocol error

Environment

16.0.1 and Prior Releases

Oracle Database 

Cause

Check the scheduling of the Investment Allocation job.
 

Resolution

Release 16.0.2:

• Job Name = 'Update Investment Allocations and Usage' 
• The job has been enhanced and parameters added so the job can target a specific investment, investments associated with a specific investment manager or investments associated with specific OBS Units.
• Refer to additional articles for more details. 

   

Prior to 16.0.2:

• Reschedule the job to run once daily as the job processes all investments so ideally should only be running once daily. 
• Set jobs that run at the same time to be incompatible.
   

Additional Information

See also:

• Investment Allocation Job - Purpose & Overview  
• Investment Allocation Job Schedule Frequency