agent list error | "Runtime error in component 'AgentListComponent'.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Following a manual upgrade, one or more users are unable to access the agent list - Err: "Runtime error in component 'AgentListComponent'. This only happened in client 0. User could see the agent list in other clients. Other user can be left unaffected.

The JWP that attempted the query would then go to 100% utilization and output the following to the JWP log and also produce a trace dump.

20201028/095134.597 - 40 U00045014 Exception 'com.automic.database.api.DBException: "com.microsoft.sqlserver.jdbc.SQLServerException: The column name (SELECT COUNT FROM HACL WHERE HACL_OH_Idnr = OH_Idnr) AS NUMBER_OF_CLIENTS is not valid."' at 'com.automic.database.impl.UC4ResultSetImpl.getInt():74'.
20201028/095134.597 - 40 U00045015 The previous error was caused by 'com.microsoft.sqlserver.jdbc.SQLServerException: "The column name (SELECT COUNT FROM HACL WHERE HACL_OH_Idnr = OH_Idnr) AS NUMBER_OF_CLIENTS is not valid."' at 'com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError():191'.
20201028/095134.597 - 40 U00003620 Routine 'AgentListComponent' forces trace because of error.
20201028/095134.613 - 40 U00003450 The TRACE file was opened with the switches '0000000000000000'.
20201028/095135.129 - 40 U00003449 Output to the TRACE file is finished.

Environment

Component: Automation Engine

Version: 12.3.4x

 

Cause

This can be reproduced on v12.3.4 by doing the following:

1. Go in AWI, Administration, Agents.

2. Activate "number of clients" column:

3. Agents overview shows "Runtime error in component 'AgentListComponent':

Resolution

Workaround:

Re-create User Object.

Solution:
Update to a fix version listed below or a newer version if available.

Fix version:
Component(s): Automation.Engine 

Automation.Engine 12.3.5HF1 - Available

Automation.Engine 12.3.6 - Available