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 ?
***Edited by Moderator Marissa to update Support Case Details***