Question
Anthem
US
Last activity: 15 Aug 2019 15:47 EDT
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.
Pegasystems Inc.
US
Does this article help you out? https://community.pega.com/support/support-articles/limit-being-exceeded-prhourlyusage-table
Anthem
US
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.
Pegasystems Inc.
US
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?