Question

1
Replies
13
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 206 posts
Anthem
Posted: November 11, 2020
Last activity: November 18, 2020

DELETE QUERIES @ pr4_log_rule_usage_details and pr_log_reportstats.

Team,

We observe the below mentioned DELETE Queries frequently. Are these from the ClusterandDBCleaner agent ? If yes, we have this agent enabled only at 12 AM EST, not sure why we observe these queries on regular basis.

Any chance that ClusterandDBCleaner agent although enabled on one JVM keeps running multiple times in a day ? Any known bugs related to this agent ?

Any idea that these queries can get triggered during JVM startups ?

Thank you.

 

(@P0 varchar(?),@P1 varchar(?))delete from dbo.pr4_log_rule_usage_details where pxObjClass = ? and pxSystemNode = @P0 and pyLabel = @P1

 

delete from dbo.pr_log_reportstats where pxCreateDateTime < ( select DATEADD(day, -?, CONVERT(DATETIME, DATEDIFF(dd, ?,max( pxCreateDateTime)), ?)) from dbo.pr_log_reportstats )

Pega Platform 7.3.1 Case Management Healthcare and Life Sciences