Problem with Installing RA FTP Agents during DB Load

book

Article ID: 223512

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

We are trying to install and setup the RA FTP agent.  

We are trying to import FtpAgent_solution.jar via ucybdbldg. We have a problem and error.  Also we try upload FtpAgent_solution.jar version 4.0.1 and 4.1.0 

Log from utility/temp is added, this is the error:

20210908/131208.850 - U00038157 Generating RA connection 'FTPCONNECTION'.
20210908/131208.850 - U00038150 A database error occurred:  'SQLExecDirect', 'ERROR   ', '01000', 'The statement has been terminated.'.
20210908/131208.850 - U00038067 ABORTING due to error!  

Cause

CONN.FTPAGENT.FTPCONNECTION already existed in client 0

Environment

Release : 12.3

Component :

Resolution

Solution:

If this happens remove CONN.FTPAGENT.FTPCONNECTION from client 0 and run the DB Load again.