DB (PEGA0005) Alerts in NBAM framework for PR_DATA_IH_FACT
SummarySeeing 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 ReproduceSeen in AES and during dashboard load.
Root CauseThese 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.
ResolutionPerform the following local-change: incorporate PR_DATA_IH_FACT into the archival strategy to maintain performance.
Published June 1, 2017 - Updated June 22, 2017