CA PIMv14 Installation - SQL Server Preparation

Document ID : KB000117931
Last Modified Date : 22/10/2018
Show Technical Document Details
Question:
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 ?
Environment:
CA PIM 14.X
Answer:
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.
Additional Information:
See the following link by Microsoft for how to calculate an index length

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms191241(v=sql.105)