AES case manager portal access
User is facing issue with accessing AES manager portal and getting requestor timeout whlie accessing portal.
com.pega.pegarules.pub.context.RequestorLockException: Unable to synchronize on requestor HFDFF7766704DDAACBCC57672DC0B33D4 within 120 seconds: (thisThread = http-0.0.0.0-9999-294) (originally locked by = http-0.0.0.0-9999-18) (finally locked by = http-0.0.0.0-9999-18)
Steps to Reproduce
Access AES manager portal.
The root cause of this problem is defect/misconfiguration in the PRPC operating environment. There are 2.5 m records in pegaam_alert table which is taking time to load in AES Manager portal.
This issue is resolved through the following suggestions:
Add DB index.
Keep 1 week data in pegaam_alert and archive remaining.
Add more criteria to reports to minimize the resultset.
Changed the threshold and alerts