Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
If the fields sys_user.preferred_language and sys_user.country are updated to a NULL value, the dictionary interprets the value as a string and truncates it to 'NUL'. - Known Error
  • >
  • Knowledge Base
  • >
  • Known Error (Knowledge Base)
  • >
  • If the fields sys_user.preferred_language and sys_user.country are updated to a NULL value, the dictionary interprets the value as a string and truncates it to 'NUL'.
KB0691453

If the fields sys_user.preferred_language and sys_user.country are updated to a NULL value, the dictionary interprets the value as a string and truncates it to 'NUL'.


1310 Views Last updated : Jan 31, 2024 public Copy Permalink
KB Summary by Now Assist

Description

The fields sys_user.preferred_language and sys_user.country have Max length 3. If these are updated through a client script to a NULL value, the dictionary truncates them as 'NUL'.

 

Steps to Reproduce

 

1) Log in to any instance as administrator.
 
2) Create an onSubmit Client Script on Incident: 
 
var user = new GlideRecord('sys_user');
user.get('06826bf03710200044e0bfc8bcbe5d8a'); // random user
user.mobile_phone = '234-566'; // a random field 
user.update();
 
3) Save and activate the Client Script.

4) Go to any incident and update the record.
 
5) Go to the sys_user record with sys_id=06826bf03710200044e0bfc8bcbe5d8a. Observe the preferred_language is set to the value 'NUL'.
 

Workaround

After carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or near future releases. We do not make these decisions lightly, and we apologize for any inconvenience. You can submit an Enhancement Request and Subscribe to this article to be notified in case of future updates.

As a workaround, update the sys_user record via a before/after insert Business Rule rather than a Client Script, for example:

Table = incident 
Advanced = true 
When = before / after 
Insert = true 
Script = 
var gr = new GlideRecord('sys_user'); 
gr.get(sys_id); 
gr.email = 'testing123@test.com'; 
gr.update(); 


Related Problem: PRB586274

The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.