Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,120
Community Members
 
Community Events
165
Community Groups

Should I be concerned that the ID values in the app_user and cwd_user tables don't match?

I was pulling user data from our MS SQL database to identify an account in Jira Service Management that was causing us issues and realized that in the app_user and cwd_user tables, the IDs for the user don't always match. They do in the beginning, then are off by 1 or 2 for the same user as the count gets higher. 

This doesn't seem to have caused any impact and the user data looks correct when viewed in Power BI using the Power BI Connector, but I want to make sure this deviation won't cause some kind of issue down the line. 

Has anyone else encountered this? 

Jira_ID.png

1 answer

1 accepted

3 votes
Answer accepted

Yep, it's one of many reasons never to read a Jira database - it makes less sense than you might guess.

You are safe though, it is nothing to worry about.

Thanks for the quick response!  And yeah I had to stop exploring tables for my own sanity.

I think the database gave me a nervous breakdown around 2007... ;-)

Like Albert Lukan likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

246 views 1 9
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