Symptoms

If a user is searching in the "sc_cat_item" list view with a particular keyword then the results are duplicate in non-english language. For example, if a user searches for *laptop in the name of the catalog item then he sees duplicate results which have same name and same sys_id. 

Release

Kingston, Madrid, London

Cause

The issue is caused due to duplicate translations in the "sys_translated_text" table for the same catalog item, one on the table "sc_cat_item" and the other on the table "sc_cat_item_producer"

Resolution

Remove the duplicate entries in the "sys_translated_text" table for the same catalog item and Make sure to have only one translation per catalog item per field and per language for both the tables sc_cat_item & sc_cat_item_producer. 

Additional Information

For more information, refer Translation tables