Issue Summary

If you have a group_name with custom value options that contain Turkish character İ, Jira will fail when:

a) Checking which users are members of this group;

b) Checking group changes during the user sign-in, trying to insert a group that already exists:

com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Group][groupName,Business-IC KONTROL-RISK_UYUM][createdDate,2020-05-05 10:34:12.153][lowerGroupName,business-ic kontrol-risk_uyum][active,1][description,null][lowerDescription,null][directoryId,10400][updatedDate,2020-05-05 10:34:12.153][id,18732][type,GROUP][local,0] (SQL Exception while executing the following:INSERT INTO cwd_group (ID, group_name, lower_group_name, active, local, created_date, updated_date, description, lower_description, group_type, directory_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-00001: unique constraint (JIRA_DC2.UK_GROUP_NAME_DIR_ID) violated

This used to work fine in 7.0, but not in 7.13 or 8.x.

Steps to Reproduce

1. Using Jira 7.0.10 and Java version 1.8_11, create a group name using the Turkish character İ;
2. Use the option "Update group memberships when logging in" for the directory;
3. Add users to these group;
4. Synchronize Jira and Crowd users and groups.
5. Jira group's shows the members, users are able to sign-in.
6. Upgrade to Jira 7.13.9, Java jdk1.8.0_241
7. Sign in with one member of this group

Expected Results

The user should be able to sign-in

Actual Results

The user is not able to sign-in
The below exception is thrown in the atlassian-jira.log file:

com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Group][groupName,Business-IC KONTROL-RISK_UYUM][createdDate,2020-05-05 10:34:12.153][lowerGroupName,business-ic kontrol-risk_uyum][active,1][description,null][lowerDescription,null][directoryId,10400][updatedDate,2020-05-05 10:34:12.153][id,18732][type,GROUP][local,0] (SQL Exception while executing the following:INSERT INTO cwd_group (ID, group_name, lower_group_name, active, local, created_date, updated_date, description, lower_description, group_type, directory_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-00001: unique constraint (JIRA_DC2.UK_GROUP_NAME_DIR_ID) violated

Workaround

• Use a group that does not have a Turkish special character;
• Change the option "Update group memberships when logging in" to "Update for new users only", instead of "Every time the user logs in".