Deleted user from active directory is not synchronised in Jira Service Management application

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.


Deleted user is not activated in JSM with delegated LDAP


We need to activate this user manually to resolve this issue.

  • We cannot manually activate this user as it is from LDAP.
  • We have to perform changes in database to activate this user.


  • As we need to perform changes in database to activate this user. Here are the queries to be executed to get this fixed.

SELECT from cwd_user u where lower_user_name='USER_NAME' 
update cwd_user u set active=1 where

Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

Last modified on Sep 9, 2021

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.