When will pega write to pr_log_reportstats
Hi team,
When will pega agent activity pzSaveReportStatUsage write data to pr_log_reportstats table
***Edited by Moderator Marissa to add SR Details***
virtusa
LK
Hi Pavani,
In Pega-RulesEngine Agent, this activity is configured to run in periodic pattern with an interval of 3600 seconds. Therefore, it should write to pr_log_reportstats, every hour.
Perhaps someone could elaborate.
Pegasystems Inc.
IN
Hello,
pr_log_reportstats --
Maintains execution statistics for Rule-Obj-ReportDefinition rules run within PRPC. The pxObjClass is Log-ReportStatistics. For each operator session, statistics are collected and written out to a table that will enable a customer to write reports to find
1. How often the reports are being run, and by whom
2. How long the reports are taking to run, and how many rows of data are they returning
A cache is maintained in PRPC Engine and for each Execution of a report, an instance of Log-ReportStatistics with all its properties is created.
When the agent gets triggered or cache reaches its size it flushes the cached data to the table.
If the database is configured with more no. of live JVMs. Every Requestor, Agent, CTI from each JVM writes performance data to this table every hour and upon termination/signoff.
Set this prconfig and the other two DSS after deleting records(if required) from these tables (pr_log_reportstats, pr_perf_stats, pr_sys_statusdetails) that are older than say 7 days.
<env name="usage/retentionperiod" value="7" />
Owning Ruleset: Pega-RulesEngine
Purpose: management/systemdetails/maxdays
Value: 7
Owning Ruleset: Pega-RulesEngine
Purpose: reporting/reportstatistics/minimumDaysToPurgeFromDatabase
Value: 7
Hello,
pr_log_reportstats --
Maintains execution statistics for Rule-Obj-ReportDefinition rules run within PRPC. The pxObjClass is Log-ReportStatistics. For each operator session, statistics are collected and written out to a table that will enable a customer to write reports to find
1. How often the reports are being run, and by whom
2. How long the reports are taking to run, and how many rows of data are they returning
A cache is maintained in PRPC Engine and for each Execution of a report, an instance of Log-ReportStatistics with all its properties is created.
When the agent gets triggered or cache reaches its size it flushes the cached data to the table.
If the database is configured with more no. of live JVMs. Every Requestor, Agent, CTI from each JVM writes performance data to this table every hour and upon termination/signoff.
Set this prconfig and the other two DSS after deleting records(if required) from these tables (pr_log_reportstats, pr_perf_stats, pr_sys_statusdetails) that are older than say 7 days.
<env name="usage/retentionperiod" value="7" />
Owning Ruleset: Pega-RulesEngine
Purpose: management/systemdetails/maxdays
Value: 7
Owning Ruleset: Pega-RulesEngine
Purpose: reporting/reportstatistics/minimumDaysToPurgeFromDatabase
Value: 7
thank you
-Abhishek
Pegasystems Inc.
IN
Did you identify any reports where the stats are not saved in database ,is it OOTB or custom report ?
Pegasystems Inc.
IN
Hi Pavan,
I need to check that. Will come back to you once having some info. Others in the community are open to comment.
Capgemini
SE
Hi Pavanir6
The agent as mentioned by Abhishek runs once in an hour and dumps all the statistics from the cache into the DB table. If you would like to turn on/off this feature you can use the DSS reporting/enablestatistics
I ran a couple of reports in my PE ( one OOTB and one custom) and checked the instances of the Log-ReportStatistics after 1.5 hrs or so and I was able to see the data.
Maybe you can put a trace on the agent to see if it fails for some reasons on your end.