Support Article
High volume PEGA0005 alerts at sppr_aggregate_usage
SA-88419
Summary
A large number of PEGA0005 alerts are generated for the below SQL query,
SQL: {call dbo.sppr_aggregate_usage ()} inserts: *
Error Messages
PEGA0005 alert
Steps to Reproduce
Not Applicable
Root Cause
A defect or configuration issue in the operating environment.
The retention of hourly and daily usage is high. This caused the alert when the data is groomed each day.
Resolution
Make the following change to the operating environment:
- Stop the application (all JVMs - online and batch).
- Truncate the below tables:
- pr_daily_usage
- pr_hourly_usage
- Execute the below Update queries:
* update <schema>.pr_license_parameters set pyvalue = 50 where pyname = 'pyRetainHourly';
* update <schema>.pr_license_parameters set pyvalue = 91 where pyname = 'pyRetainDaily';
- Restart the application.
Published October 18, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.