There may be times when an attachment has a very long file name. This could be a pdf or a Microsoft Word document. When this attachment is indexed by Knowledge Management for Smart Analytics/IDOL these attachments will fail with the following errors seen in the sm.log file. Example below:
RTE I sqlserver: Length (88 bytes) of data for field filename in kmattachmenttoken exceeds max (60 bytes), truncated
Currently the field 'filename', located in the kmattachmenttoken dbdict is varchar(60). This field can be lengthened to varchar(256) thus solving the problem.