User stuck inactive despite I manually made him active

[Pavel]

A user has been suddenly removed from an access group in AD. First, I tried to make him active again, but no luck

update cwd_user set active=1 where user_name='username'

Then, this user was granted the access group again, but he's still inactive.

I tried to add a fake users directory to clear the cache, but also no luck.

What is possible in this situation?

[Rilwan Ahmed]

Hi @Pavel ,

Welcome to the community !!

1. Please make sure the AD to jira sync is run. 
   i.e. Go to Admin settings --> User Management --> Run sync against each AD connected to your jira. 

2. Refresh the User's Cache

   Restarting JIRA will clear the user's cache and recreate it once the application is started again.
    If you have a Data Center installation, all Nodes must be stopped and then started one by one, otherwise, the problematic cache can be replicated back to the starting Nodes.

    If restarting JIRA is not a feasible option, you can try out an alternate workaround as below: 

   • Create a new directory, and fill out the required fields. Click “Save and Test” once to get a connection error, and click again to save the config.
   • After that disable the new directory then delete it without using it for anything.
   • The act of deleting a directory will cause related caches to be reset.

[Pavel]

1. Of course I tried

2. I tried the last workaround. Besides restarting Jira, is there any way to make the user active?