RA panels not loading into AWI

Document ID : KB000126474
Last Modified Date : 11/02/2019
Show Technical Document Details
Issue:
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.'. 
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. Load a newer version of the RA solution into the DB
2. Modify the case of the 'OBLOB_Name' field in question directly in the DB and set uppercase