Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Unable to import XML space to Confluence Server exported earlier from Cloud

I am trying to import XML Confluence spaces from my cloud Confluence account into my on-prem Confluence server.

I get the following message after 20% of importing progress (I changed my e-mail address with the dummy address)

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 '' for key 'unq_lwr_username'

After that the importing stops. I was looking for a solution in the Community articles but I could not find anything to solve my problem. Why is this happening in the first place? Shouldn't it be a simple and tested by Atlassian data migration process?

My Confluence Server version is 7.3.1

1 answer

1 accepted

1 vote
Answer accepted

Hello Bogdan,

Thank you for reporting this. You mentioned you had looked for a solution in the articles, but you weren't able to find anything. Have you had a look at this article yet?

The error is the same, and there is a solution for you on that page. Could you tell me if you have done that already?

Thank you!


The page that you have mentioned did not help me as such but it directed me where I should start experimenting. After looking for a solution I found the one that worked for me.

I unpacked the space export ZIP file and looked through the entities.xml file for the duplicate entry which caused the trouble . So, I looked for the '' which caused the problem and simply renamed it to After editing the XML file, I zipped it back. There was no such user in my Confluence instance so the import was accepted. 

The problem that some people may have with this solution is that all imported pages have corrupted data about authors. In my case it is:

Created by Unknown User (5c2f5bc58a78885a3c19debf), last modified by Unknown User (

Anyway, I am happy that I could get out of the Confluence Cloud server with my content before the expiry date. For some reason, it is easy to migrate content from Server to Confluence Cloud with the Migration Assistant but, as you can see, it is not so easy to go back.

Hi Bogdan,

Glad to hear you've at least gotten further along!

Could you see if you can create the user and then disable it, per the following article:

Let me know how that goes.


I did that and it worked indeed. Thank you!

Like Shannon Spaniol likes this

Excellent! Thank you for confirming.

Take care, and have a pleasant week.


Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

🥓🙅🏻‍♀️ Meet-less May Badge!

Hello Confluence Community!  What if i told you that you could have a healthier life and be 100% meet-less? This month, we're promoting a healthy, balanced work diet with Confluence. (Read m...

287 views 3 17
Read article

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