Multiple of the Same User - User Picker (Single User) Fields

[Rabia S_]

Hi everyone,

We have 8.20.6 version of Jira. In user picker (single user) fields, we are viewing multiple of the same user.

In addition, Jira have LDAP integration. 

Thanks.

[Rilwan Ahmed]

Hi @Rabia S_ ,

Please restart jira and check

[Rilwan Ahmed]

Hi @Rabia S_ ,

We had faced similar issue before and restarting with clearing cache resolved for us. 

• Shut down JIRA
• Delete the following hidden plugin cache directories:

  JIRA_HOME/plugins/.bundled-plugins
  JIRA_HOME/plugins/.osgi-plugins

• Restart 

[Rabia S_]

Hi @Rilwan Ahmed ,

Thanks, I tried this solution, but it didn't work.

[Rilwan Ahmed]

@Rabia S_ 
I found a related ticket https://jira.atlassian.com/browse/JRASERVER-68456.  See if the workaround mentioned solves your problem. 

Workaround:

Jira >= 8.19.1:  Avoid using duplicate username or manually deactivate the user in the database (set active=0) (DB: cwd_user.active)

Run below query to check if duplicate exists in DB

1. select * from cwd_user where user_name = 'xxxxx';
2. select * from app_user where lower_user_name in (select lower_user_name from cwd_user where user_name = 'xxxxx')
3. select * from app_user where lower_user_name = 'xxxx';

The below query will help you find out the list of user accounts that are using the same e-mail address between different User Directories.

SELECT cwd_directory.directory_name as "Directory Name",
 cwd_user.lower_user_name as "User Name", 
 cwd_user.lower_email_address as "E-mail Address"
FROM cwd_user, cwd_directory
WHERE lower_email_address IN (
 SELECT lower_email_address 
 FROM cwd_user
 GROUP BY lower_email_address
 HAVING COUNT(*) > 1)

Note: This query was built to PostgreSQL and may require some changes to run in different database flavors.

[Robert Wen_Cprime_]

Jira may be seeing duplicate user account entries.  Here's a knowledgebase article on merging those accounts. https://confluence.atlassian.com/jirakb/merge-duplicate-ldap-user-accounts-674989047.html

[Rabia S_]

This solution about same user but different account. But we are seeing same user and same account.

In User Management, like this users are seeing just one.