-
Bug
-
Resolution: Fixed
-
Low
-
6.4.1, 6.4.5, 6.4.6, 6.4.7, 6.4.9, 6.4.11, 6.4.12, 6.5-OD-07, 7.0.4, 7.0.0
-
6.04
-
31
-
Severity 3 - Minor
-
3
-
NOTE: This bug report is for JIRA Server. Using JIRA Cloud? 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
- causes
-
JRASERVER-42966 Project filter fails when browsing for project when there are 50+ project in the search
- Closed
- relates to
-
JRACLOUD-43888 Project Search does not work if a Project has a Project Lead in a disabled directory
- Closed