2
Vote

Warning and failure messgae when running EPM_Create_Database_Objects.sql

description

Why do I get the below message?
Warning! The maximum key length is 900 bytes. The index 'IX_PolicyHistoryView' has maximum length of 1330 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'IX_EvaluatedServer_EvaluatedPolicy_EvaluatedObject_EvaluationDateTime' has maximum length of 1032 bytes. For some combination of large values, the insert/update operation will fail.

How can I fix it?

comments

wfvdijk wrote Nov 23, 2015 at 7:06 PM

This is just a warning saying the total MAX length of every column in this index exeeds the 900 bytes limit.
This is a MSSQL restriction. However, as long as the total length of all columns does not exeed the 900 bytes, no error will occur. Hence the "For some combination of large values, the insert/update operation will fail." message

wrote May 3 at 3:26 PM