Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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.

Suggest Edit

Published August 23, 2017 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us