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.
Why duplicate dictionary entries shows up on dictionary list? - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Why duplicate dictionary entries shows up on dictionary list?
KB0696707

Why duplicate dictionary entries shows up on dictionary list?


1141 Views Last updated : Jan 28, 2024 public Copy Permalink
KB Summary by Now Assist

Issue

Symptoms


Dictionary entries are duplicated on "sys_dictionary.list" as shown in the below screenshot,

However, when we open the duplicated records, they point to the same record with same sys_id. Hence they are not duplicated at the database level, only at the User Interface level they are duplicated.

Release


Any supported release.

Cause


When the dictionary entries are loaded on the list view, they are populated via a join query between sys_dictionary table and sys_glide_object table as below,

03:16:26.589: Time: 0:00:00.002 for: [glide.2] SELECT ... FROM ((sys_dictionary sys_dictionary0 INNER JOIN sys_metadata sys_metadata0 ON sys_dictionary0.`sys_id` = sys_metadata0.`sys_id` ) 

LEFT JOIN sys_glide_objectsys_glide_object1 ON sys_dictionary0.`internal_type` = sys_glide_object1.`name` ) WHERE sys_glide_object1.`label` LIKE 'LIST%' /*...*/ 


03:16:26.613: Time: 0:00:00.017 for: [glide.5] SELECT ... FROM ((((sys_dictionary sys_dictionary0 INNER JOIN sys_metadata sys_metadata0 ON sys_dictionary0.`sys_id` = sys_metadata0.`sys_id` )

LEFT JOIN sys_glide_objectsys_glide_object1 ON sys_dictionary0.`internal_type` = sys_glide_object1.`name` ) LEFT JOIN sys_db_object sys_db_object2 ON sys_dictionary0.`reference` = sys_db_object2.`name` )

LEFT JOIN sys_filter_option_dynamic sys_filter_option_dynamic3 ON sys_dictionary0.`dynamic_default_value` = sys_filter_option_dynamic3.`sys_id` ) WHERE sys_glide_object1.`label` LIKE 'LIST%' ORDER BY sys_dictionary0.`column_label` limit 0,20 /*...*/ 

Hence, when there is a duplicate sys_glide_object record for a TYPE, then that particular field type will be duplicated on the sys_dictionary.list.

Below screenshot shows duplicate sys_glide_object for LIST type. Ideally, it should be only one sys_glide_object record for a type.

Resolution


The duplicate sys_glide_object record needs to be removed. However, this can not be done via User Interface.

If you run into this issue, please open a HI support ticket with category "Tables and Dictionary", support will remove the duplicate sys_glide_object via CHANGE. 

Additional Information


System dictionary

Lists


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?

Attachments

Attachments

  • Screen Shot 2018-08-29 at 12.22.45 PM.png
  • ScreenShot_duplicate_list_type_dictionary.png

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.