The index entry exceeds the maximum length

Question

I have been receiving this error:

The index entry of length <> bytes for the index '<>' exceeds the maximum length of <> bytes. The index entry of length for the index exceeds maximum length in SQL which is 900 byte max. Content crawling may not complete due to this issue and you will see crawling errors

I found a blog post which states the source is that the 'MSSDOCProps' table has a column with a limit of 450 characters, in unicode that 2 bytes per character so 900 bytes. The issue is that when including the 'PID' which is 4 bytes, you get a size of 904 bytes.

( http://www.sharepointmcm.com/post/2011/07/05/A-Search-SQL-Index-Issue.aspx )

The workaround is to limit the "MaxCharactersInPropertyStoreIndex" property to 448

( http://msdn.microsoft.com/en-us/library/microsoft.office.server.search.administration.managedproperty.maxcharactersinpropertystoreindex.aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1 )

So I understand all that, but I'm not sure where exactly I would set this parameter. In the code-behind my Master Page?

I am using C#. Any ideas?

Answer 1

I believe the value you want is here:

Microsoft.Office.Server.Search.property.MaxCharactersInPropertyStoreIndex = 448;