Loading RA Solution fails with a PRIMARY KEY error against PK_OVW

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Loading RA Solution fails with a PRIMARY KEY error against PK_OVW

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Symptoms

When attempting to load a new solution, the load fails and gives an error similar to:

U0003592 Status: '23000' Native error: '2627' Msg: 'Violation of PRIMARY KEY constraint 'PK_OVW'. Cannot insert duplicate key in object 'dbo.OVW'. The duplicate key value is (114, JOBS.FTPAGENT.FTPJOB).'

---

Cause

This is due to record(s) remaining within the UC_OBJECT_TEMPLATE (referenced as 114) that the load is unable to remove automatically.

---

Resolution

From within Client 0, open the UC_OBJECT_TEMPLATE and remove any template items related to the solution being installed - for example, for RA FTP you would make sure all entries similar to JOBS.FTPAGENT.FTPJOB are removed manually.