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.

Comments

Keep up to date on this post and subscribe to comments

August 15, 2019 - 1:22pm

August 15, 2019 - 1:41pm
Response to BradTainter_GCS

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.

August 15, 2019 - 3:47pm

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?