Warning: "max length of a key is 900 bytes" when using SQL Server as external Database (DB)</p (72145)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Warning: "max length of a key is 900 bytes" when using SQL Server as external Database (DB)
Description

After the installation of the SQL Server backend Database has been completed, the following is seen:
"Warning: max length of a key is 900 bytes. Index 'PK__tagging_service___10216507' has a maximum length of 1530 bytes. For some combinations of big values, insert or update operations may not function correctly."
Resolution

Warnings related to the maximum length of index keys are safe to ignore.
Additional Information

Highlighted on Page 55 of the Foglight Document "Installing on Windows with an External Microsoft SQL Server Database", it states the following:
"Manual Database Configuration - Note: Warnings related to the maximum length of index keys appear. These warnings are safe to ignore."

Feedback submitted.

Was this article helpful?

[Select Rating]

Title