MSSQL: Time Slicing Job Is Stuck on Rollover in 16.2.2+

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

On Monthly Rollover, the Time Slicing job has not been completing and is indefinitely stays in the 'Processing' state

The BG logs with INFO logging on the blobcrack component do not show any progression. 

Environment

16.2.2, 16.2.3 with SQL Server Database

Cause

There are blocking transactions caused by triggers, which are created from the audit enabled on fields such as Availability, Allocation on the objects: project,resource 

Resolution

This is DE155705, in review by Engineering