The following Database deadlock warnings are observed in the CA Business Intelligence CMS log: "Database deadlock encountered. Ensure database is correctly tune and that data statistics are up to date". What is the cause of these messages?

Document ID : KB000046038
Last Modified Date : 14/02/2018
Show Technical Document Details

Question

The following Database deadlock warnings are observed in the CA Business Intelligence (CABI) CMS log:

"Database deadlock encountered. Ensure database is correctly tune and that data statistics are up to date". 

What is the cause of these messages?

Answer

  • These messages are caused by a SQL Server DB limitation. 
  • The CABI indexing process will create multiple and frequent access to the CMS Database.
  • As part of the SQL DB locking mechanism, SQL will mark the deadlock and CMS will output the message into the CMS log file.
These messages are for warning information purposes and can be safely ignored.