Unable to access AWI after upgrade

book

Article ID: 200060

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine

Issue/Introduction

After upgrading from Automic 12.1 to 12.3.x Automic Admin get's the following error:

com.uc4.ecc.backends.exceptions.AutomationEngineAPIException

Error during XRequest

com.uc4.communication.requests.GetRestEndpoints

 

Cause

The following query:

select oh_name,host.* from oh,host where oh_idnr=host_oh_idnr and host_hostattrtype in ('W','C');

showed no CP's available.

Look at the HOST Table - none were defined.

Environment

Release : 12.3.x

Component : AUTOMATION ENGINE

Resolution

Inserted the CP's into the Host Table:

example insert:

INSERT [dbo].[HOST] ([HOST_OH_Idnr], [HOST_HTYP_HW], [HOST_HTYP_SW], [HOST_HTYP_SWVers], [HOST_CodeName], [HOST_JCLVar], [HOST_HostAttrType], [HOST_TcpIpAddr], [HOST_TcpIpPort], [HOST_Active], [HOST_JobCnt], [HOST_MaxWaiting], [HOST_Daylight], [HOST_LicenceClass], [HOST_Version], [HOST_JobMd], [HOST_PathBin], [HOST_PathJobReport], [HOST_PathTemp], [HOST_ProcessName], [HOST_VolumeTemp], [HOST_ProcessMask], [HOST_LoginMask], [HOST_MibMonitoring], [HOST_MibInfo], [HOST_LicCategory], [HOST_MaxWaitingFT], [HOST_FTCount], [HOST_HostRoles], [HOST_MaxResJob], [HOST_MaxResFT], [HOST_Authenticated], [HOST_CPName], [HOST_CITName], [HOST_TrustedIPs], [HOST_CITCN], [HOST_CITOU], [HOST_SmPhrase], [HOST_SmTcpIpPort], [HOST_SmDisplayName], [HOST_SmLookupFlag], [HOST_SmLinkFlag], [HOST_HostName], [HOST_NetArea], [HOST_PathBackup], [HOST_PathCache], [HOST_TargetVersion], [HOST_UpgradeRunId]) VALUES (100003, NULL, NULL, NULL, NULL, NULL, N'C', N'10.46.128.48', 2217, 0, 0, 0, NULL, NULL, N'12.3.3+hf.4.build.1598599742445', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, N'UC4', 8871, N'UC4 JCP', 1, 1, N'dedke01-ae1', NULL, NULL, NULL, N' ', 0)

which resolved the issue