'ERROR: duplicate key value violates unique constraint "pk_ovw" when loading RA Agent

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Load of the RA Webservice Rest Solution fails with:

U00003590 UCUDB - DB error: 'ERROR:  duplicate key value violates unique constraint "pk_ovw" DETAIL:  Key (ovw_oh_idnr, ovw_vvalue)=(114, AGENT.WEBSERVICEREST) already exists.', '', '', ''

Resolution

Delete the entry from UC_OBJECT_TEMPLATE and load the solution again.

E.g. the error mentioned AGENT.WEBSERVICEREST, so the entry about the object needs to be deleted from UC_OBJECT_TEMPLATE.