The attachment file extension is removed from the file name if the attachment file name is longer than the maximum length of the sys_attachment column name file_name attribute. In addition, because the Manage Attachment window does not always display the file type correctly (for example, Outlook file type), identifying the type of attachment is even more difficult.
Steps to Reproduce
Log in to the base system instance.
Create or rename files of three different file types for attachments with a name having 125 characters. For example:
Navigate to Incident > Open and select an incident.
Click the attachment icon and add these files as an attachment.
Note that the file names have been trimmed to first 100 characters including the file name. You can also verify the truncation by viewing the sys_attachment table (https://instancename.service-now.com/sys_attachment_list.do?). Also, if an Outlook file is included, its icon does not display correctly.
Increase the maximum length attribute of the File Name column in the Attachments (sys_attachment) table:
Enter sys_attachment.list in the application filter to open the Attachments table.
Right-click the File name column label and select Configure > Dictionary.
Locate file_Name under Column name and increase the Max length value.
Note that if the file name is longer than this value, the file extension will be truncated.Note 2: If you increase the length beyond 255 then it will change the field type to "MEDIUMTEXT" on the backend.
We do not recommend exceeding this length without thoroughly testing in sub production.
To receive notifications when more information is available about this issue, click the Subscribe button at the top of the article.
Related Problem: PRB584906