Confluence Site Import failed due to entities.xml generated contains group memberships that are declared before the user declaration in the XML file

Summary

Site import with backup generated from Confluence cloud instance failed with the following error

msg:com.atlassian.idp.client.exceptions.UserNotFoundException: {"schemas":["urn:ietf:params:scim:api:messages:2.0:Error"],"status":"404","detail":"A user with <userid> doesn't exists","errorType":"UserDoesNotExist","message":"A user with <userid> doesn't exists","data":"<userid>"}	

This is caused by the group memberships are declared before the user declaration. Thus, Confluence couldn't find the users and shows the error.

Environment

• Confluence Cloud

Steps to Reproduce

1. Perform site import with affected backup file
2. Site import failed with "A user with <userid> doesn't exists"

Expected Results

1. Site import completed successfully

Actual Results

1. Failed import with "errorType":"UserDoesNotExist" error

Application logs:

ERROR: duplicate key value violates unique constraint "unq_lwr_username" Detail: Key (lower_username)=(<userid>) already exists.

Workaround

Relocate all group membership after the user declaration

Group Memberships

<object class="HibernateMembership" package="com.atlassian.crowd.embedded.hibernate2">
</object>