Renaming UC4 System name

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Renaming UC4 System name

Environment

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

Resolution

Solution

 

With the following statement you are able to mark the old System names as deleted:

 

 

 

MSSQL:

 

Update oh set oh_name=(OH_Name + '_' + ( SUBSTRING( '0000000000', 1,(10-len(OH_Idnr) ) ) ) + convert(varchar(10),OH_IDNR)) where oh_otype='SERV' and oh_name like 'UC4B#%' and oh_deleteflag = 1

 

ORACLE:

Update oh set oh_name=concat(concat( concat(OH_Name , '_') , ( SUBSTR( '0000000000', 1,(10-length(OH_IDNR) ) ) )) , TO_CHAR(OH_IDNR)) where oh_otype='SERV' and oh_name like 'UC4B#%' and oh_deleteflag = 1;

 

commit;

 

You have to adapt the value 'UC4B#%' to your Automic System name.

?

Additional Information

This article may apply to more recent versions of the AE system.

Additional actions to perform to validate the changes:

-- Renaming the System Name in configuration files of the AE and of existing agents and AWI

-- Changing the system in existing REST API calls

--  Renewal of  transfer keys for connected agents may be necessary as well.

-- Performing a backup of the database is recommended before proceeding with these operations.