We need to change the max length of the sys_created_by field in the sys_attachment table.

[edouardholliste]

We are using Fuji in our on premise instance.   We use LDAP to populate our User table and use our email address for our user_id.   The sys_created_by field in the sys_attachment table has a max length of 40.   We have some user_ids that are longer.   We need to enlarge the size to 100, to be on the safe side.   The field is grayed out even though I have Admin role.   I have tried to change it in the Global domain, as well as, our domain and I have activated the elevated privilege of security_admin.   Does anyone know how I can enlarge the field?

[edouardholliste]

Chuck,

We have a few users whose user_id is over 40 characters. They are unable to export from lists. All users who have user_id of less than 40, don't have this issue. I saw, in the Community, where another company was having the same issue (Ways to expand sys_created_by length<https://community.servicenow.com/message/841134#841134> — by George Chen). Unfortunately, he didn't say how he resolved it.

Respectfully,

Edouard T. Hollister Sr

DC1 SNOW Administrator

CSRA

Department of Homeland Security / DC1

9324 Cypress Loop Rd | Stennis Space Center, Ms 39529

Office: 228-813-3380

Edouard.Hollister@associates.hq.dhs.gov<mailto:Edouard.Hollister@associates.hq.dhs.gov>

[Chuck Tomasi]

Hi Edouard,

Thank you for the clarification. That's the first I've heard of that issue. I would do as you suggest, extend the length of the field to 100 with the help of HI support and retest. Let me know how that turns out.

[Vinoth Rangu1]

Right-click on the field, Show Security Rules. Find the 4 write rules for sys_dictionary. Make them inactive. Create a new Write rule on the field, with an admin role. You should be able to make the change.

Step1 : Make inactive ,4 write rules on sys_dictionary as mentioned in below screenshot and also create one ACL as highlighted in green to make edit the max length field in dictionary entry

step2: Please go and make it edit the max length to 100 as mentioned in the screenshot

Let me know if you have any questions. Don't forget to activate them after you make changes.

Thanks, 

Vinoth R