Description
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.