Users cannot be found in Users list and ACTIVE flag for users set to F in the database
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
Unable to grant user access to Crucible/Fisheye as a user cannot be found when searching for him in "Users" to add the required groups.
Diagnosis
Diagnostic Steps
set ACTIVE=F for user in the database. Run below query to check that
select * from cwd_user where user_name='username';Cause
User directory cache is not updated with changes in remote directory
Resolution
Do a force "full synchronization" for the directory configuration as mentioned below
- In the Fisheye User Interface go to Administration > User Directories
- Click on the "edit" button in the "Active Directory server" row
- In that User Directories settings, uncheck the box next to "Enable Incremental Synchronisation"
- Switch back to the User Directories page and select "Synchronize" and wait until it finishes
Once the issue is resolved, you may change it back to incremental synchronisation by checking "Enable Incremental Synchronisation"