SA-10514

Summary

AES 7.1 is running on PRPC 7.1.5 and frequently throws OutOfMemory Errors.

Error Messages

java.lang.OutOfMemoryError
: 
Java heap space

Steps to Reproduce

Not Applicable

Root Cause

The root cause of this problem is a defect in Pegasystems’ code/rules. Execution of "Cleanup AES Data" Agent results in creation of huge (4Gig) ArraryList Object causing OOM error.
"Cleanup AES Data" Agent processes/deletes entries from pegaam_exception table that has grown to a large size (e.g 100 Million rows). Hence, every time the Agent runs, it brings large amount of data to the Clipboard causing heap exhaustion.

Resolution

This issue is resolved through the following local change: Remove/Delete entries from this table that are older than 14 days by running DELETE SQL -
delete from pegaam_exception where pxCreateDateTime < [fourteendaysago]

"Cleanup AES Data" Agent will now be able to process relatively this manageable amout of data and keep the table size within limits.