If a user has a user name user_name longer than 40 characters, the values in the Created by sys_created_by or Updated by sys_updated_by fields are truncated when a record is created or updated.
The sys_created_by and sys_updated_by fields are of type varchar(40) on the Task table. The user_name field on the sys_user table is of type varchar(100).
Steps to Reproduce
- Create a user with a user ID longer than 40 characters.
For more information, see the documentation topic Create a user.
- As admin, impersonate the user.
- Navigate to Incident > Create New and create an incident.
- Personalize the Incident list to show the Created by and Updated by columns.
Note that the user ID is truncated to 40 characters in the Created by and Updated by columns.
What are the issues users with longer User Id’s will see?
1)When users have a user_name longer than 40 characters they cannot download lists exported to Excel. When attempting to download, they are taken to a blank sys_attachment page.
2)Users are unable to attach attachments from the service portal or normal UI to any record. After attaching the file and upload No attachments are added and not shown on the form.
3)User will notice their name is truncated to 40 chars on activity stream for any record.
Please use the workaround - either by not allowing user ids over 40 characters or determining a workaround specific to the application where the issue is encountered.
Related Problem: PRB644092