ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Jobs are not kicking off Clarity
Article ID: 241463
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.
Feedback
Yes
No
Powered by
