ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Investment Allocation / Portfolio Sync fails: ORA-03106: fatal two-task communication protocol


Article ID: 129660


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


One or more jobs intermittently fails with error ORA-03106: fatal two-task communication protocol error in Clarity. Jobs that fail with this error include: Investment Allocation Job, Portfolio Sync, Post Timesheets job

Error found in bg-ca.logs:

ERROR 2019-03-13 19:00:02,676 [Dispatch Investment Allocation : [email protected] (tenant=clarity)] niku.njs (clarity:admin:.....:Investment Allocation) Error executing job: 5034781 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( at com.niku.njs.Dispatcher$ at java.util.concurrent.ThreadPoolExecutor.runWorker( at java.util.concurrent.ThreadPoolExecutor$ at Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-03106: fatal two-task communication protocol error


This issue is caused by DE49805


Release: All Supported Releases

Component: Clarity Environment


This issue is targeted to be fixed in Clarity 15.9. For a fix on prior versions (where the workarounds below do not work, please reach out to Broadcom Support for a fix for this issue. 


  1. Run the job more than once per day (recommended during outside business hours where possible), as the amount of times it is run increases the probability of at least one successful run per day.


    • The Investment allocation job is one that is normally recommended to be run only once daily as it does process all investments, so this would be a temporary workaround. See KB How often should I run the Investment Allocation Job? for more details.
    • If a XOG write action is perform for updating an existing project, the action triggers slicing and the execution of the Investment Allocation job for the specific projects so that the project manager is able to immediately see all updated data on the projects updated from that action without having to manually execute the job for all investments.
    • To check the scheduled frequency: 
      1. Navigate to the Home > Reports and Jobs > Scheduled jobs page.
      2. Find out the frequency of the Investment Allocation job.

     2. Check to see if there are any other jobs running at the same time when the issue occurs. It's recommended at a minimum to make the Investment Allocation job incompatible with the Time Slicing job.

To check if the jobs are already incompatible:

  1. Go to Administration > Data Administration > Reports and Jobs
  2. Click on the Investment Allocation job
  3. Click on the Incompatible Jobs tab

On Premise customers: You can also check the job's incompatibility list with the below query:

Where I.Job_Definition_Id = J.Id
and J.JOB_CODE in ('inv_alloc_job')
order by J.JOB_CODE

Additional Information