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

Question

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 Answer

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

* select * from globalpermissionentry;
* 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 Answer

Once again, Recovery Mode is my friend.

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