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  >
article

KB-4319: The maximum key length is 900 bytes

Centrify DirectAudit ,  

12 April,16 at 11:41 AM

Applies to:

DirectAudit earlier than Suite 2014

Question:

On a Centrify server running DA-3.1.1, when the SQL scripts to create the management database is executed, the following warning messages are received: 
 
Warning! The maximum key length is 900 bytes. The index 'Management Database' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail. 
 
Warning! The maximum key length is 900 bytes. The index 'PK_AuditStoreTrustedAgent' has maximum length of 2052 bytes. For some combination of large values, the insert/update operation will fail. 
 
Warning! The maximum key length is 900 bytes. The index 'PK_AuditStoreTrustedCollector' has maximum length of 2052 bytes. For some combination of large values, the insert/update operation will fail. 
 
(1 row(s) affected) 
 
What is the meaning of these messages and should there be any concern?
 
Answer:
 
This issue was discovered in Suite 2013.x build and it has already been fixed in Suite 2014. 
 
The fix does not suppress the warnings (these warnings will continue to appear when creating a new Audit Store database using Suite 2014 build). What the fix addresses is a more severe issue; i.e. in extreme corner cases, audit trail events may not get inserted into the database because one of the parameters to the audit trail events may be too long to create an index. The issue has been fixed by truncating any excess data. 
 
It is safe to ignore these warnings.

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.