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

Tony Rossiter
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 14, 2018

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

1 answer

0 votes
Ravi Varma
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 17, 2018

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

Ryan Chapin October 7, 2019

What is the list of the "user related tables"?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events