DB (PEGA0005) Alerts in NBAM framework for PR_DATA_IH_FACT
Seeing many DB alerts for below query in NBAM framework for below query :
SELECT MAX(Impression) AS Impression, MAX(Clicked) AS Clicked, MAX(Accepted) AS Accepted, MAX(Pending) AS Pending
WHERE pycategory in ( 5 recent )
This is invoked from the rule --->RULE-OBJ-ACTIVITY PEGAMKT-WORK-CAMPAIGN GETDASHBOARDSTATISTICS
The activity is OOTB and alerts are seen in AES as well as in logs during dashboard load.
Steps to Reproduce
Seen in AES and during dashboard load.
These alerts will occur when one of the tables (PR_DATA_IH_FACT) behind the view reaches 50+ million records. This user was seeing 80+ million.
Perform the following local-change: incorporate PR_DATA_IH_FACT into the archival strategy to maintain performance.