Getting a "User does not exist" error when viewing a specific user

Tony Rossiter

We are hosting JIRA server and manages users through LDAP integration.  This user was created in AD on 9/10 and then was pulled into JIRA core as a user; however, we cannot access their profile to manage it and they don't come up on any user picker fields (see attachments).  We have done the following to troubleshoot:

1. Full reindex of the application

2. Deleted the user record from cwd_user and re-synced users through the LDAP integration

The issue persists.  Here's the lasted error in the atlassian-jira.log file: 

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
... 15 filtered
at com.softwareplant.ppm.structureint.jiraserver.event.PluginIssueLinkListener.doFilter(PluginIssueLinkListener.java:72)
... 36 filtered
at com.atlassian.servicedesk.internal.web.ExternalCustomerLockoutFilter.doFilter(ExternalCustomerLockoutFilter.java:56)
... 4 filtered
at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:62)
... 12 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 20 filtered
at com.intenso.jira.contentinjection.filter.ContentInjectionFilter.doFilter(ContentInjectionFilter.java:71)
... 45 filtered
at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
... 1 filtered
at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
... 39 filtered
at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
... 5 filtered
at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.lambda$invokeFilterChain$0(CustomerContextSettingFilter.java:181)
at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.rteInvoke(ReentrantThreadLocalBasedCodeContext.java:137)
at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.runOutOfContext(ReentrantThreadLocalBasedCodeContext.java:90)
at com.atlassian.servicedesk.internal.utils.context.CustomerContextServiceImpl.runOutOfCustomerContext(CustomerContextServiceImpl.java:47)
at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.outOfCustomerContext(CustomerContextSettingFilter.java:174)
at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilterImpl(CustomerContextSettingFilter.java:130)
at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilter(CustomerContextSettingFilter.java:121)
... 4 filtered
at com.atlassian.jwt.internal.servlet.JwtAuthFilter.doFilter(JwtAuthFilter.java:32)
... 8 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 4 filtered
at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
... 26 filtered
at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
... 23 filtered
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalStateException: User 'abattepati' has no unique key mapping.
at com.atlassian.jira.user.ApplicationUsers.from(ApplicationUsers.java:46)
at com.atlassian.jira.user.LazyLoadingApplicationUser.readFullUser(LazyLoadingApplicationUser.java:35)
at com.atlassian.jira.user.LazyLoadingApplicationUser.fullUser(LazyLoadingApplicationUser.java:27)
at com.atlassian.jira.user.LazyLoadingApplicationUser.isActive(LazyLoadingApplicationUser.java:76)
... 432 more

Ravi Varma

Hi @Tony Rossiter,

Please note that I could not find any attachments in this ticket.

Can you confirm the following:

• I hope AD user directory is the first one in the order 
• You were able to log in to JIRA using the desired user whose profile you are accessing
• At this point, you were not able to view the profile page of that user.

I am really concerned about this statement Deleted the user record from cwd_user and re-synced users through the LDAP integration

Ideally you are not supposed to delete any of the records, as they might be referenced in many tables across the database.

Please note this statement Caused by: java.lang.IllegalStateException: User 'abattepati' has no unique key mapping. Can you look at the user related tables to see if the uniqueness of the column is violated?

If possible, please attach the files to have a better understanding of your problem.

Regards,

Ravi Varma