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.
Component: Automation Engine
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':
Re-create User Object.
Update to a fix version listed below or a newer version if available.
Automation.Engine 12.3.5HF1 - Available
Automation.Engine 12.3.6 - Available