When preparing the SQL Server 2012 for CA PIMv14 installation, some warning messages were observed when executing the mssql_database_deployment_script.sql script.
Warning messages were seen as follows:
Warning! The maximum key length is 900 bytes. The index 'SYSCALLUSERPGM_INDEX1' has maximum length of 1045 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'irmaccountattr6_index_1' has maximum length of 1260 bytes. For some combination of large values, the insert/update operation will fail.
As well as some other indexes.
What are those error messages and is there any remediation for them ?
Those warning messages are expected when setting up the database. There is some benefit of indexing columns that are normally too large for an index key so we continue to do so in the product. The messages may be safely ignored.
See the following link by Microsoft for how to calculate an index length