Author search field does not show a dropdown list of users when typing

Still need help?

The Atlassian Community is here for you.

Ask the community

Problem

In the search page, there is not a drop down list of suggested users when typing in the Author search field.

The following appears in the atlassian-confluence.log:

2014-10-20 13:13:23,402 ERROR [http-bio-127.0.0.1-8080-exec-98] [common.error.jersey.ThrowableExceptionMapper] toResponse Uncaught exception thrown by REST service: userkey
 -- url: /rest/prototype/1/search/user.json | userName: bruggerju | referer: https://testconfluence.com/dosearchsite.action?queryString=user1
java.lang.NullPointerException: userkey

Diagnosis

Run the following query to check for affected users:

SELECT *
FROM user_mapping 
WHERE user_key NOT IN (SELECT username FROM content WHERE contenttype = 'USERINFO' AND prevver IS NULL) 
AND lower_username NOT IN (SELECT lower_user_name FROM cwd_user);

In the people directory, you can still see the user profile for the user listed in the previous query.

Cause

The USERINFO page was removed in the database due to the remove or rename user, but the index cache was not updated.

Resolution

 

  • A full content indexing should resolve the issue.
Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.