search cancel

Jobs are not kicking off Clarity

book

Article ID: 241463

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Clarity 16.0.0 

Jobs are not starting even though BG service is running.

Cause

This is caused by error [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot use the ROW granularity hint on the table "niku.PRLOCK" because locking at the specified granularity is inhibited

Environment

Release : 16.0.0

Component : Clarity Job Scheduler

Resolution

This issue was caused because of a third party index which was suggested by SQL Server Database Tuning Advisor. Once we removed the index the issue was resolved.