Question

17
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 208 posts
Anthem
Posted: January 21, 2021
Last activity: January 22, 2021

Unusual Behavior - Deadlock query @ pr_sys_statusdetails table - ClusterandDBCleaner agent disabled.

Hi Team,

ClusterandDBCleaner agent has been disabled in one of our environments but, we could still find the below mentioned deadlock query being generated during every midnight (~12 AM EST).JFYI, retention period DSS has been set to 1 day (unlike the default value “7” from below).

delete from DBO.pr_sys_statusdetails where pxUpdateDateTime < (select DATEADD(day, -7, CONVERT(DATETIME, DATEDIFF(dd, 0,max( pxUpdateDateTime)), 1)) from DBO.pr_sys_statusdetails ). frame procname=PEGA_IP.dbo.sppr_purge_table line=43 stmtstart=3028 stmtend=3120 sqlhandle=0x03000e002c337f14a31e2300f5a400000100000000000000000000000000000000000000000000000000000

What other OOTB agents or processes can exhibit this behavior ?

Please suggest.

Thank you.

***Edited by Moderator Marissa to update Support Case Details***
Pega Platform 7.3.1 System Administration Support Case Exists