Support Article
AES DB Growing in size
SA-32797
Summary
Based on settings AES need to hold only 14 days of data and the Clean AES data agents are running .
Pegaam_alert table has more than 14 days of data.
Error Messages
ERROR - An error occured on executing the query for the report definition - There was a problem getting a list: code: 1013 SQLState: 72000 Message: ORA-01013: user requested cancel of current operation
DatabaseException caused by prior exception: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
| SQL Code: 1013 | SQL State: 72000
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 1013 SQLState: 72000 Message: ORA-01013: user requested cancel of current operation
DatabaseException caused by prior exception: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
| SQL Code: 1013 | SQL State: 72000
Steps to Reproduce
Not Applicable
Root Cause
A defect or configuration issue in the operating environment
The pegaam_alert and pegaam_exception table contain data older than the expiration threshold - default of 14 days. This causes many SQL commands in the AES Manger portal to fail with a timeout exception.
Resolution
Perform the following local-change:
Remove the data from the tables that is older than the expiration date.
Make sure the AES Server agents are running on every node in the AES Server cluster.
Do not segment the Agents on different nodes.
Published August 23, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.