Time Critical DB Calls on PMMA table in JWP logs

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error messages regarding the PMMA table appear in the log files of the JWPs. On the one hand Time Critical DB calls, on the second error messages that contain: ORA-08102: index key not found

Time Critical DB Call:
20190211/100502.542 - 33 U00003525 UCUDB: ===> 'SELECT PMMA_Idnr, PMMA_PMMD_Idnr, PMMA_Timestamp, PMMA_WP_Name, PMMA_TcpIpAddr, PMMA_SrvType, PMMA_Interval FROM PMMA WHERE PMMA_PMMD_Idnr = ? and PMMA_Timestamp > ? AND PMMA_Timestamp <= ? ORDER BY PMMA_Timestamp desc '
20190211/100505.022 - 33 U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCT' time: '2300ms'

ORA-08102:
20190211/004428.117 - 34 U00003525 UCUDB: ===> 'DELETE FROM PMMA WHERE PMMA_Idnr IN ( SELECT * FROM (SELECT PMMA_Idnr FROM PMMA WHERE PMMA_Timestamp <= ? ORDER BY PMMA_Idnr) WHERE ROWNUM <= 1000 )'
20190211/004428.117 - 34 U00003434 Server routine 'MetricsCleanupTask/TIMER' required '0' minutes and '28' seconds for processing.
20190211/004428.729 - 34 U00045014 Exception 'com.automic.database.api.DBException: "DELETE FROM PMMA WHERE PMMA_Idnr IN ( SELECT * FROM (SELECT PMMA_Idnr FROM PMMA WHERE PMMA_Timestamp <= ? ORDER BY PMMA_Idnr) WHERE ROWNUM <= 1000 )"' at 'com.automic.database.impl.DBConnectionImpl.executeInternal():438'.
20190211/004428.730 - 34 U00045015 The previous error was caused by 'java.sql.SQLException: "ORA-08102: index key not found, obj# 35210139, file 897, block 243756 (2)

Environment

Release: AUTWAB99000-12.2-Automic Workload Automation-Base Edition
Component:

Cause

Issue with the index of the PMMA table

Resolution

Solution:
Ask your DBA to rebuild the indexes of the PMMA table