AWI: slow performance when searching for Executions

book

Article ID: 205473

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

Issue/Introduction

When search for executions within the Automic Web Interface, the results are slow and upon review, the logs show two getstatistics calls for each attempt to search for executions:

20201029/222136.306 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'SLUC' time: '29:402.839.858'
20201029/222136.306 - U00029131 UCUDB - List of bind parameters:
20201029/222136.306 - U00029132 UCUDB: 'AH_Client          = 100'
20201029/222136.306 - U00029132 UCUDB: 'AH_OH_Idnr         = 2632008'
20201029/222136.306 - U00003525 UCUDB: ===> 'select AH.*, coalesce(EH.EH_Status, AH.AH_Status) as EH_Status from AH left join EH on EH.EH_AH_Idnr = AH.AH_Idnr where AH_Client = ? and AH_OH_Idnr = ? order by AH_TimeStamp1 desc'
20201029/222136.431 - U00003434 Server routine  'UCDS_R/getstatistics' required '0' minutes and '29,547' seconds for processing.
20201029/222136.431 -          <uc-env clientVersion="12.3.3+build.1591976977116" request="oh_52" session="0000000853599217" useridnr="0002550139"><request idnr="2632008" name="getstatistics" src="oh"/>...
20201029/222201.611 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'SLUC' time: '24:993.912.258'
20201029/222201.611 - U00029131 UCUDB - List of bind parameters:
20201029/222201.611 - U00029132 UCUDB: 'AH_Client          = 161'
20201029/222201.611 - U00029132 UCUDB: 'AH_OH_Idnr         = 2632008'
20201029/222201.611 - U00003525 UCUDB: ===> 'select AH.*, coalesce(EH.EH_Status, AH.AH_Status) as EH_Status from AH left join EH on EH.EH_AH_Idnr = AH.AH_Idnr where AH_Client = ? and AH_OH_Idnr = ? order by AH_TimeStamp1 desc'
20201029/222201.705 - U00003434 Server routine  'UCDS_R/getstatistics' required '0' minutes and '25,093' seconds for processing.
20201029/222201.705 -          <uc-env clientVersion="12.3.3+build.1591976977116" request="oh_54" session="0000000853599217" useridnr="0002550139"><request idnr="2632008" name="getstatistics" src="oh"/>...

Cause

Improper call within the AWI

Environment

Release : 12.3

Component : AUTOMIC WEB INTERFACE

Resolution

This will be resolved in a future release of the product.