Issue Summary

When exporting a Cloud site that has both usernames and AAIDs, permissions are broken on import to Data Center as some tables only point to AAIDs (sharepermissions, for instance).
This is reproducible on Data Center: yes

Steps to Reproduce

1. Export a cloud site that has both usernames and AAIDs in the database
2. Import into local DC instance.
3. Review dashboards/filter permissions and note that any users imported with a standard Jira Username will be broken, as the sharepermissions table only references AAIDs

Expected Results

Dashboards and filters will work as expected

Actual Results

Any users imported into Jira with a standard username will be broken as the sharepermissions table only references AAID

Workaround

Run the following query to generate update statements to resolve permissions:

SELECT ('UPDATE sharepermissions SET param1 = replace(param1, ''' || cu.external_id || ''',''' || cu.lower_user_name || ''') WHERE param1 = '''|| cu.external_id ||''';') as "Queries to fix" FROM cwd_user cu WHERE cu.external_id IS NOT NULL;