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

Progressive increase in size of AES 7.1.7 MS SQL Server Schema

SA-21862

Summary



The size of the MS SQL Server Autonomic Event Services (AES) 7.1.7 data schema keeps growing.
Monitored system settings in AES have the following values for Retention Days:
  • 14 days for alerts and exceptions,
  • 30 days for statistics

AES Cleanup Data agent is scheduled to run every hour and is executed correctly.
Nonetheless the AES database contains alerts and exceptions that are older than the expected 14 days.


Error Messages



No error messages.


Steps to Reproduce

  1. Install AES 7.1.7 on Pega 7.1.8 with a MS SQL Server database.
  2. Add Monitored Nodes.
  3. Wait for the period specified in Cluster Settings (Retention Days).
  4. Observe that older logs are partially removed.


Root Cause



A defect in Pegasystems’ code or rules:
The PegaAES- purgeOldData activity invoked by the “Cleanup AES Data” Agent is limiting the amount of rows deleted to 51 with MS SQL Server database.
This affects the ability to Cleanup old items on MS SQL Server.


Resolution



Apply HFix-26939.

Published August 23, 2017 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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