Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Database; wrong user_key in app_user table

Hello there,

if you create a user in Jira Core, it updates the table app_user in the database (New Inserts: id, user_key and lower_user_name).

The problem is, that sometimes the user_key is "JiraUserX" (X for a number) and sometimes it's the same as the lower_user_name.


My question is why and how to change it.


best regards,



1 answer

0 votes

I'll take a slightly different approach to - why do you want to change this?   What problem is it causing you?

For analysis and it causes an incorrect database!

"for analysis" tells us nothing about why you want to change it, or what problem it us causing.

Could you tell us what is going wrong in your "analysis" that is caused by this?  Or more usefully, why your "analysis" is struggling with it?

I am looking into something similar I have about 700 users in an active system. Out of those 700 about 30 have their key as JIRAUSERXXXXX. We are doing a custom API import into Project Team addon from a specific data source. That datasource has the username (first part of their email). 670 users have this value as there userkey. This allows for the API to import the user info.

What happens I get an error in the JSON payload the user does not exist (which from the technical stand point is true, that USERKEY does not exist the user name and account does.  Using the constant value in the datasource , this allows us to merge the specific information from the datasource in Project Teams, without having to create a custom hash table or custom API calls specifically for 30 some odd users and any future user.

The users email address even if their name changes will not change. So the username even if the users name changes will not change. We already have consistent value, in LDAP, Workday, Oracle, etc. JIRA is the only one that once we upgrade to 8 has replaced "username", with JIRAUSERXXXXX. So my function is not anything other than to write the least amount of calls to JIRA to update the API on the fly each time. If it is the only system that in not constant with all others. 


I have already disabled the function for future users to use JIRAUSERXXXX in darkmode. I just need to fix the handful of users that remain

Daniel Ebers Community Leader Jan 23, 2021

The observed behaviour is part of "GDPR changes in Jira" (further reference is available from here:

I strongly assume the 30 users which already have JIRAUSERXXXXX are new ones - they must have been created after an upgrade taking place to a version later than Jira 8.2.

You said you disabled the behaviour already using dark features - ok.

Although I am not aware of any (neither hacky nor safe) way to fix the 30 "anonymized" user keys back to the old standard.

Suggest an answer

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

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

159 views 1 5
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you