Jobs are not kicking off Clarity or failing

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Jobs are not starting even though BG service is running with 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

or

Some jobs are failing with error:

ERROR 2023-01-26 15:30:33,341 [Dispatch Time Slicing : [email protected] (tenant=clarity)] niku.blobcrack (clarity:admin:40520755__7971DA0B-6652-4A7F-B438-9B27D5FDE8B5:Time Slicing) Exception during blobcrack process
com.niku.union.persistence.PersistenceException: 
SQL error code: 651
Error message: Cannot use the ROW granularity hint on the table "niku.PRJ_RESOURCES" because locking at the specified granularity is inhibited.

Resolution

• This is caused because of a third party index suggested by SQL Server Database Tuning Advisor
• Please remove the index to get this resolved
• Note any custom indexes and tuning to the database must be fully tested before deploying