Progressive increase in size of AES 7.1.7 MS SQL Server Schema
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.
No error messages.
Steps to Reproduce
- Install AES 7.1.7 on Pega 7.1.8 with a MS SQL Server database.
- Add Monitored Nodes.
- Wait for the period specified in Cluster Settings (Retention Days).
- Observe that older logs are partially removed.
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.
0% found this useful