-
Bug
-
Resolution: Fixed
-
Low
-
31
-
Severity 3 - Minor
-
3
-
NOTE: This bug report is for JIRA Cloud. Using JIRA Server? See the corresponding bug report.
Steps to reproduce
- Connect JIRA to an external user directory
- Create a project and set Project Lead to one of the external users
- Disable the external user directory, so that the Project Lead's user account is removed from JIRA
- Go to Projects dropdown menu -> View All Projects and perform a project search
Expected behavior
Projects can be filtered using the keyword
Actual behaviors
- The search function does not work and projects can't be filtered
- The project with the external Project Lead states that it has no Project Lead:
- The browser URL is not appended with &contains=<keyword>
- The browser F12 Console shows this JS error:
Workaround
- Find all the projects with the same problem from JIRA Administration -> Projects
- Go to their Administration Panel -> Roles -> update Project Lead to an Active User
If there're too many projects to update, the following SQL query can be used to search for them in the database:
select * from project where lead not in (select lower_user_name from cwd_user);
Then the following query can be used to update the Project Lead of these projects to a valid username:
update project set lead = '<an_active_username_in_lowercase>' where lead not in (select lower_user_name from cwd_user);
the username must be in lowercase
JIRA needs restarting (and maybe re-indexing) for the change to take effect
Notes
- Project Search always fails under All Projects category, because it definitely contains one or more problematic projects
- Similarly, it fails under those Categories which contain one or more problematic projects
- For those Categories without a problematic project, Project Filter works, no matter how many pages there are
- is related to
-
JRASERVER-43888 Project Search does not work if a Project has a Project Lead in a disabled directory
- Closed