Question
High volume PEGA0005 alerts @ sppr_aggregate_usage.
Hi Team,
High volume of PEGA0005 alerts has been observed for the below mentioned SQL query.
SQL: {call dbo.sppr_aggregate_usage ()} inserts: *
PRPC731,MSSQL,TOMCAT.
Please suggest.
Hi Brad,
Please clarify.
1) Resolution provided @ https://community.pega.com/support/support-articles/limit-being-exceeded-prhourlyusage-table works out for PRPC731 as well ?
2) Class Data-Admin-License is mapped to table dbo.pr_data_admin in PegaDATA and please confirm if this "redeploy Data-Admin-License record to adjust the “hourly” data retention period to 8 days" can be done via a DSS ?
Thank you.
Hi Pradeep,
The article was provided as it gave details behind what calls the stored proc and the table that is affected. This may be one possible explanation. As a next step, you can review the table details to see if there is anything awry with that table (stats, etc.) and see the row count. How many alerts are being seen with the example you provided?
Does this article help you out? https://community.pega.com/support/support-articles/limit-being-exceeded-prhourlyusage-table