Loading RA Solution fails with a PRIMARY KEY error against PK_OVW

Document ID : KB000089788
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Loading RA Solution fails with a PRIMARY KEY error against PK_OVW
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.