Deadlock could happen if service computing full table scan and query is run simultaneously.
Applies to: Centrify Suite 2016 (CDC 5.3) Reporting Service running MS-SQL 2008
Symptom: We found that a possible process can be in a Deadlock when the Report Service is computing (Delta Sync), a sql 'UPDATE STATISTICS [ReportData][XXXXX] WITH RESAMPLE' will be executed, which means a full-table sync is being performed in the background and at the same time a report (Login Report or any Report) is opening simultaneously.
Question: In situation where Deadlock does occur, is there a workaround or resolution?
Answer: This is not a critical issue and usually will resolve itself in the next sync cycle. The fix will be available in the future release Suite 2016.x.