There is no ID mapped for the user key Edited


When creating a report


the report falls with an error

ERROR Servlet.service() for servlet [action] in context with path [] threw exception [java.lang.IllegalStateException:
There is no ID mapped for the user key 'user'] with root cause
java.lang.IllegalStateException: There is no ID mapped for the user key 'user'
        at com.atlassian.jira.user.DefaultUserPropertyManager.getPropertySetForUserKey(
        at com.atlassian.jira.user.DefaultUserPropertyManager.getPropertySet(
        at com.atlassian.jira.user.preferences.DefaultUserPreferencesManager.getExtendedPreferences(
        at com.atlassian.jira.user.preferences.DefaultUserPreferencesManager.getPreferences(
        at com.atlassian.jira.timezone.TimeZoneManagerImpl.getTimeZoneforUser(
        ... 2 filtered
        at java.lang.reflect.Method.invoke(
        at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(
        at com.sun.proxy.$Proxy222.getTimeZoneforUser(Unknown Source)
        ... 2 filtered
        at java.lang.reflect.Method.invoke(
        at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(
        at com.sun.proxy.$Proxy222.getTimeZoneforUser(Unknown Source)
        at com.atlassian.jira.plugin.corereports.web.action.ConfigureReport.doExecute(
        ... 1 filtered
        at com.atlassian.jira.action.JiraActionSupport.execute(
        ... 7 filtered
        at javax.servlet.http.HttpServlet.service(
        ... 19 filtered
        at com.softwareplant.ppm.structureint.jiraserver.event.PluginIssueLinkListener.doFilter(
        ... 36 filtered
        at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(
        ... 7 filtered
        at com.atlassian.jira.plugin.corereports.filters.ReportKeyRewriter.doFilter(
        ... 4 filtered
        at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(
        ... 58 filtered
        ... 1 filtered
        ... 36 filtered
        at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(
        ... 10 filtered
        at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(
        ... 4 filtered
        at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(
        ... 29 filtered
        at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(
        ... 28 filtered
        at java.util.concurrent.ThreadPoolExecutor.runWorker(
        at java.util.concurrent.ThreadPoolExecutor$
        at org.apache.tomcat.util.threads.TaskThread$

 this action did not help There is no ID mapped for the user key

In the database I found this user in the table USERHISTORYITEM

can this be the problem?


1 answer

0 votes

This error indicates there is a problem with records in the Jira database.  Run this SQL query first:

select * from app_user where user_key='user';

You can change that 'user' to the value in your error message.  This should return an id, user_key, and lower_user_name.   The lower_user_name value here is expected to sync up with the cwd_user table's lower_user_name value for some record of some user.

So you should have at least 1 value when running:

select * from cwd_user where lower_user_name='value returned from first query';'

If you don't have any results, then there is something missing in the database.

The Jira is synchronized with the LDAP. The problem is that some people have renamed the LDAP user login. After the synchronization, authorization problems appeared in the Jira. We had to make changes to the database. To solve the problem.

I apologize for not accurately describing the problem.

This user is not needed at all, which I can still clean up, or rename the user in the user1 to make the report work.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Wednesday in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

84 views 0 4
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you