Restore from Backup generated by Cloud wipes out groups with System Administration permission

[Robert Wen_Cprime_]

I'm in the middle of a Cloud merge migration and I'm using a Jira DC instance I've created as a staging point.

When importing in the Cloud projects to my Jira DC instance, it looks like all groups have been wiped from the System Administration global permission.  I verified using the following SQL:

Anyone know the right SQL to add a group back to the System Administration global permission?

[Gikku · Accepted solution]

@Robert Wen_Cprime_  You can use the below 2 queries to modify the permissions.

1. select * from globalpermissionentry;

2. update globalpermissionentry set permission = ‘SYSTEM_ADMIN’, group_id = ‘site-admins’ where id = <id>;

Choose any ID from the results of the first query that is not required on your DC instance. Or choose any of the existing ID, use it to grant yourself the system admin rights. I assume you are a site-admin, so you should be a member of the 'site-admins' group imported from Jira. If not, select another that you are added to. 

Once you have the system admin rights, you can add the permission that you modified from the UI.

[Robert Wen_Cprime_ · Accepted solution]

Once again, Recovery Mode is my friend.

Once I set the recovery password, the recovery_admin account was able to set everything I needed.

[Matt Doar _Adaptavist_]

My handy waving guess is that the export doesn't preserve SYSTEM_ADMIN groups because you could do an import with that and become a sys admin, which is probably only for Atlassians in their Cloud. But it is odd that this hasn't been noted elsewhere, or documented