Follow

Issue: "Warning! The maximum key length is 900 bytes" is seen when executing CreateDB.sql script.

Applies to:

Microsoft SQL Server 2008 R2 Express Edition
Microsoft SQL Server 2008 R2 Standard Edition
Microsoft SQL Server 2008 R2 Enterprise Edition
Venafi Encryption Director 7.0

Symptom:

The following warning is seen when executing the CreateDB.sql script using MSSQL 2008 R2.

Warning! The maximum key length is 900 bytes. The index 'config_objects_Parent_Name' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.

Resolution:

This warning is expected. The code ensures we will never enter something in this row exceeding 900 bytes. This warning was exposed when we changed the data type from varchar to nvarchar to allow us to properly store internationalized characters.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    Amadeus Cert Mgmt

    also applies to Venafi Encryption Director 8.0

Powered by Zendesk