It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Restoring Space from XML Error Edited

I'm trying to Restore a Space I have and get the following error:

 

I've restored other spaces all without issue, but this one - even after clean up, has repeated itself. Nothing Shows up in the log file. 

 

Import failed. Check your server logs for more information. com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: MySQLIntegrityConstraintViolationException: Duplicate entry 'Dev' for key 'UK_jp1ad5yufsih5r7lqrygakpug'

1 answer

2 votes

Hello Kevin,

Welcome to Atlassian Community. It's nice to meet you.

Can you let me know which version of Confluence the export is coming from, and what your target version is?

Can you confirm that there is no space in your target instance that might share the same space key or name? 

When you say that you performed a cleanup, can you let me know which steps you took exactly? You can review the following page for information on how to do a manual clean up from the database:

In addition, have you checked your server logs per the error message? You may find more specific details about why the import is failing.

Regards,

Shannon

Faced the same problem.

I performed a manual cleanup from the database as instructed

After a failed space import, it's not possible to re-import because of leftover space data

the problem is still relevant

Confluence 6.12.1

db - mysql

Hello Marat,

Did you also try the first solution, to visit the URL directly of the space and try to delete it there? The article says even if you can't see the space from the space directory, you might be able to delete it from the UI:

<confluence base url>/spaces/removespace.action?key=<space key>

Failing that, I would recommend that you raise a ticket with our Confluence Support team and we can have a look and help you out.

Regards,

Shannon

Like Marat likes this

Suggest an answer

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

How is your team having fun and bonding, remotely, utilizing Confluence?

Thanks everyone for answering last week’s question. The winner of the random drawing from those who commented is: @LarryBrock I’ll contact you separately with your prize details. This wee...

314 views 9 7
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you