RA panels not loading into AWI

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

One or several RA panels are not loading into AWI.

During startup, AWI is loading the jar files that contain the panels from the AE DB. When the AE panels are not visible, it is possible that this step failed with the following error in <tomcat>/logs/<hostname>_awi_LOG.00.txt:

pool-2-thread-4 [ERROR] <AE_SYSTEM>:<client/login> NOUI 0000000024543139 [rk.core.pool.ContextAwareExecutorService] - Unhandled Exception in Async Call: 
com.uc4.ecc.backends.exceptions.AutomationEngineAPIException: Error during XRequest com.uc4.communication.requests.DownloadBinary 
<...>
Caused by: com.uc4.webui.util.MessageBoxException: Message box received: 11631 of type E with inserts UC_ECC_PLUGINS|ECC-AE-SHEET-RA-<RA_TYPE> shown, message 'Storage object 'UC_ECC_PLUGINS' with resource 'ECC-AE-SHEET-RA-<RA_TYPE>' not found.'. 

Environment

Release: AUTWAB99000-12.2-Automic Workload Automation-Base Edition
Component:

Cause

The issue is a discrepancy in upper/lower case of the object searched in the AE database. AWI searches uppercase but find lowercase.

This can be investigated with the following SQL statement:
select OBLOB_Name, OBLOB_Filename, OBLOB_version 
from OBLOB left join OH 
on OBLOB_OH_Idnr = OH_Idnr 
where OH_Name = 'UC_ECC_PLUGINS' 

The first column, OBLOB_Name should be in uppercase. 

Alternatively, go to object /STORE/UC_ECC_PLUGINS in client 0. Inside the object, the column 'Name' should be uppercase.

Resolution

Workaround:

1. Remove the RA entry with lowercase name from /STORE/UC_ECC_PLUGINS in client 0 
2. Load a newer version of the RA solution into the DB

Alternatively, modify the case of the 'OBLOB_Name' field in question directly in the DB and set uppercase