'Plan sync failed. Please try again.' Error When Syncing a 'New Plan from OBS'

Products

• Clarity PPM On Premise

Issue/Introduction

When creating a 'New Plan from OBS', the plan sync fails with the following error: 'Plan sync failed. Please try again.'

ERROR [...] [Dispatch OBS work plan sync : bg@x (tenant=clarity)] service.OBSWorkPlanService (clarity:x:x:OBS work plan sync) () Unable to get defined depth for plan: 5xxxxxx
com.ca.ppm.rest.exception.APISystemException: Unable to sync investments for plan
               at com.niku.resource.service.OBSWorkPlanService.reInsertInvAndStaff(OBSWorkPlanService.java:114)
               at com.niku.resource.service.OBSWorkPlanService.syncInvestments(OBSWorkPlanService.java:68)
               at com.niku.resource.service.OBSWorkPlanService.syncTree(OBSWorkPlanService.java:349)
               at com.niku.resource.service.OBSWorkPlanService.sync(OBSWorkPlanService.java:186)
               at com.niku.resource.jobs.OBSWorkPlanSyncJob.scheduledEventFired(OBSWorkPlanSyncJob.java:87)
               at com.niku.njs.BGTask.run(BGTask.java:113)
               at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
               at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
               at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: com.niku.union.persistence.PersistenceException: 
SQL error code: 1
Error message: ORA-00001: unique constraint (CLARITY.SRM_RESOURCE_SNAPSHOTS_PK) violated

Environment

Clarity 16.2.1

Resolution

This issue cannot be reproduced after upgrading the environment to Clarity 16.3.1.