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

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

book

Article ID: 378908

calendar_today

Updated On:

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