U00003434 Server routine 'UCDS_R/getmonitor' required '5' minutes and '3,367' seconds for processing.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

AWA Server went down with below messages

U00003434 Server routine  'UCDS_R/getmonitor' required '5' minutes and '3,367' seconds for processing.

what causes above messages in log. 

Environment

Release : 12.3

Resolution

Check the logs for queries which are running for longer time. For Example : Below query took 5 Minutes and 3,367 second for processing . 

20221030/210331.257 - U00003525 UCUDB: ===> 'select * from (select * from EV where EV_AH_idnr = ?) a full join (select * from EJPPV where EJPPV_AH_idnr = ? and EJPPV_EJPP_Lnr = ? and EJPPV_PName = '<VALUE>' ) b on EV_VName = EJPPV_VName order by EV_SortOrder'
20221030/210331.294 - U00003434 Server routine  'UCDS_R/getmonitor' required '5' minutes and '3,367' seconds for processing.

Check with your DBA about this . What are the activities running at same time. system should show normal function after reducing the activities on DB.