Attempting to display User Activities causes latency of Graphical Clients

Document ID : KB000084551
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
N/A

Attempting to open the "Service Catalog" in Enterprise Control Center (ECC)  ( "My Catalog" in the Automic Web Interface(AWI)) causes significant latency and makes all graphical clients (ECC, AWI and UserInterface) unresponsive.

When checking the logs many time critical DB calls against table XAO can be seen:

 
20170222/171728.984 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SUCB' time: '683:659.045.999'
20170222/171728.984 - U00003525 UCUDB: ===> 'Select XAO_Idnr, XAO_Client, XAO_OType, XAO_OH_Idnr, XAO_USR_Idnr, XAO_Name, XAO_Timestamp1, XAO_Type, XAO_MsgNr, XAO_MsgInsert, USR_FirstName, USR_LastName from XAO,USR where XAO_USR_Idnr = USR_OH_Idnr and XAO_Client = ? and XAO_Timestamp1 <= ? and XAO_Type in(?) and XAO_OType in(?) order by XAO_Timestamp1 desc, XAO_Idnr desc'
20170222/170246.193 - U00003434 Server routine 'UCDS_R/getchangelog' required '13' minutes and '2,249' seconds for processing.
20170222/170246.193 - <uc-env clientVersion="11.2.4+low.build.8171" request="_32" session="0000000050790790" useridnr="0007307082"><request name="getchangelog" src="">...

This query is run by the Automation Engine to provide the view "User activities" in the Service Catalog tab.
 
Environment:
OS Version: N/A
Cause:
Cause type:
Defect
Root Cause: Retrieving changelog entries (XAO table) causes high latency
Resolution:
Update the Automation Engine and ECC / AWI to a fix version listed below or a newer version if available.
 

Fix Status: In Progress

Fix Version(s):
Automation Engine 12.2.0 - Planned release date: 2018-06-19
Automation Engine 12.1.1 - Available
Automation Engine 12.0.4 - Available
Automation Engine 11.2.7 - Available
Additional Information:
Workaround :
Add an index on table XAO:
 
CREATE UNIQUE INDEX "UK_XAO_CHGLOG" ON "XAO" ("XAO_TIMESTAMP1", "XAO_IDNR");