Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >

KB-6286: Possible deadlock in Server Suite Reporting Services

Authentication Service ,  

12 April,16 at 11:00 AM

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.