Space import throws "all-delete-orphan" error

Issue Summary

Space import failed with the error below error initially:

Error: insert or update on table "spacepermissions" violates foreign key contstraint <> Detail: Key spaceid <> not present in "spaces"

or Final error

A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance: com.atlassian.confluence.core.ContentEntityObject.content properties

Steps to Reproduce

1. Create a space export (Full XML or partial XML )
2. Try to import the space on any other cloud site

Expected Results

The space should be imported correctly.

Actual Results

Space import fails with an error:

A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance: com.atlassian.confluence.core.ContentEntityObject.content properties

Workarounds

1. Export the space using CSV.
2. If CSV can't be used, please reach out to https://support.atlassian.com/contact for further assistance.

Support please see the workaround listed in the internal comments below.