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

  1. Create a user with a user ID longer than 40 characters.
    For more information, see the documentation topic Create a user.
  2. As admin, impersonate the user.
  3. Navigate to Incident > Create New and create an incident.
  4. 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

Seen In

Eureka Patch 10 Hot Fix 1
Eureka Patch 11
Eureka Patch 11 Hot Fix 2
Fuji Patch 10
Fuji Patch 9
Fuji Patch 9 Hot Fix 1
SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-06-25 17:51:11