Some user management operations are not available in Jira Server/DC after restoring a Cloud backup
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
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:
1
2
3
4
# 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
Stop Jira
⚠️ Take a backup of your database
Run this SQL query to create the missing operations (This was tested with Postgres):
1 2# 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 12Run this SQL query to confirm the operations were added:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16# 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)Start Jira and confirm you can perform the user management operations now.
Was this helpful?