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.
Release : 12.3
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.