RA FTP agent load fails with error "Violation of PRIMARY KEY constraint 'PK_OVW"

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

RA FTP agent load fails with the below error on utility log.

U00038150 A database error occurred:  'SQLExecDirect', 'ERROR   ', '01000', 'The statement has been terminated.'.
U00038067 ABORTING due to error!  

When trace is enabled with db=4, we see below error messages on the trace log

U00003592 UCUDB - 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, CONN.FTPAGENT.FTPCONNECTION).'
U00003592 UCUDB - Status: '01000' Native error: '3621' Msg: 'The statement has been terminated.'

 

Environment

Automic Automation Engine V 21.0.x and V 24.x

Cause

Configuration

Resolution

To resolve this error, kindly follow below resolution steps.

1. Edit UC_OBJECT_TEMPLATE and rename the FTP Connection object key by adding _TMP to the end. 
2. And now save the object.
3. After loading the solution, delete the new entry and rename the key back to the original version.