Summary

Some user management operations such as user creation, user password reset, etc. are missing after migrating the data using an XML backup from Jira Cloud to Jira Server/DC.

Environment

Jira Server/Data Center after restoring a Cloud backup.

Diagnosis

• The resolutions suggested in this KB article do not help: Unable to Create or Edit Users and Groups
• Checking the list of operations from the DB and it's empty:

# select * from cwd_directory_operation;
 directory_id | operation_type
--------------+----------------
(0 rows)

Cause

The cause of this issue is still unknown but the issue was observed after restoring an XML backup generated from Jira Cloud.

Solution

1. Stop Jira
2. Take a backup of your database

3. Run this SQL query to create the missing operations (This was tested with  Postgres):

   # insert into cwd_directory_operation(directory_id,operation_type) values (1,'CREATE_GROUP'), (1,'CREATE_ROLE'), (1,'CREATE_USER'), (1,'DELETE_GROUP'), (1,'DELETE_ROLE'), (1,'DELETE_USER'), (1,'UPDATE_GROUP'), (1,'UPDATE_GROUP_ATTRIBUTE'), (1,'UPDATE_ROLE'), (1,'UPDATE_ROLE_ATTRIBUTE'), (1,'UPDATE_USER'), (1,'UPDATE_USER_ATTRIBUTE');
   INSERT 0 12

4. Run this SQL query to confirm the operations were added:

   # select * from cwd_directory_operation;
    directory_id |     operation_type
   --------------+------------------------
               1 | CREATE_GROUP
               1 | CREATE_ROLE
               1 | CREATE_USER
               1 | DELETE_GROUP
               1 | DELETE_ROLE
               1 | DELETE_USER
               1 | UPDATE_GROUP
               1 | UPDATE_GROUP_ATTRIBUTE
               1 | UPDATE_ROLE
               1 | UPDATE_ROLE_ATTRIBUTE
               1 | UPDATE_USER
               1 | UPDATE_USER_ATTRIBUTE
   (12 rows)

5. Start Jira and confirm you can perform the user management operations now.