Confluence cloud - failed to import space - ConstraintViolationException Edited

This is the error I am getting:error.PNG

and then I tried to factory reset confluence and done a another import, still having errors, and this time is a different one:

com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: could not execute statement; SQL [n/a]; constraint [uk_jp1ad5yufsih5r7lqrygakpug]; nested exception is org.hibernate.exception.Constraint

Could anyone help, please. Thank you.

 

1 answer

This widget could not be displayed.

Sharon,

Could you confirm with us from what version of Confluence the space export originated?

Did the export not complete despite the error? I have had quite a few exports that errored out but still ended up completing.

Regards,

Shannon

If you are still having the problem you can also let me know your Cloud instance details and the name of the space you are trying to import, and if you have the export stored anywhere that I can try to import it from your site.

Shannon

Hi Shannon,

Thank you for your response. with some help from a colleague, we have figured out what the issue is, i.e. why successfully exported file cannot be successfully imported: The space has previously been exported and imported before, so there are duplicated spaceName and key in the export .xml file and properties file. Some lines has the key of "“HTWTR” whereas other lines has the key of “EIP”.

I am not sure about the cloud instance details. I still need to import the contents, which are in a confluence export zip file contains the attachment folder with all attachments, a .xml file and a properties file.

I don't have the .xml file and property file with me right now (I m using my home computer, not work computer right now).

Do you have any suggestions? I was going to raise a Confluence support case for getting help from someone to correct the .xml file and properties file.

Hi Sharon,

The workaround would be to delete the space from the Confluence instance prior to importing it again. You can do so from the UI in your instance, or the Cloud team can help delete it from the database for you. It is preferred that the space is deleted via the UI.

To do it through the database, we will need to know your Cloud URL and the exact space name/key that you want us to delete. You also need to be one of the primary contacts in order to approve that we delete the space.

The workaround you mentioned of renaming the space in the XML is the 3rd option. You want to follow the THIRD resolution in How to Copy or Rename a Space in Confluence. Please note that this solution is not supported by Atlassian Support. Therefore, we can help guide you through it here if you get stuck.

Regards,

Shannon

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Monday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

460 views 6 6
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you