3509270 - Adding a new locale presents "unique constraint violated: Table(PA_I18N_ACTIVE_LOCALE), Index(UK_I18N_ACTIVE_LOCALE_DISPLAY_LOCALE_ID)"

When attempting to add a new locale, the following error may appear:

• Error: ElmsCreateException: SQLException - addI18nActiveLocale(vo) failed
• Caused by: com.sap.db.jdbc.exceptions.SQLIntegrityConstraintViolationExceptionSapDB: [301]: unique constraint violated: Table(PA_I18N_ACTIVE_LOCALE), Index(UK_I18N_ACTIVE_LOCALE_DISPLAY_LOCALE_ID) 

SAP SuccessFactors Learning

1. Go to Locales > Modify any existing locale and change the Display Locale ID to "Chinese"
2. In Locales still > Add New > Choose Simplified Chinese. Simplified Chinese Display Locale ID is "Chinese"
3. Error is presented

There is an existing locale with a Display Locale ID already in the system with the same Display Locale ID that is attempting to be added.

1. Go to References > Manage Labels > Locales
2. Search and edit all locales
3. Change the Display Locale ID to the Internal Locale ID
4. Locales > Add New > add the new locale

add, new, locale, error, db, PA_I18N_ACTIVE_LOCALE, display, locale, id , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , Problem