Duplicate Key Error when Installing PMO

book

Article ID: 197917

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Installing the PMO addin after the upgrade to 15.8.1 fails with the following error: 

Applying jobs/CSK_INV_RoadmapTimeline.xml
ERROR 23-08 07:14:57,265 - Database Error thrown
com.niku.union.persistence.PersistenceException:
SQL error code: 0
Error message: ERROR: duplicate key value violates unique constraint "cmn_business_objects_u2"...

Cause

This can occur if the parameters on the report that the install is failing on are corrupt. 

Environment

Release : 15.8

Component : CA PPM INSTALLATION AND UPGRADE

Resolution

The current version of the report needs to be deleted from the UI under Administration - Reports and Jobs. The PMO addin can then be reinstalled.