Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Confluence Space Import Error

Roei Soudai October 28, 2023

Hi, 
I export a space in XML format from one account and I`m trying to import it to another account but I`m getting a FK issue after extracting the space zip file.

ERROR: insert or update on table "content" violates foreign key constraint "fk_content_creator"

I saw another issue raised and closed and the data model was fixed but both accounts are on the cloud with latest version, so what should I do?

Regards,
Roei

 

2 answers

1 accepted

0 votes
Answer accepted
Max Foerster - K15t
Community Champion
October 29, 2023

Hi @Roei Soudai, and welcome to the community!

There's an ongoing issue with XML exports (from DC and Cloud; it doesn't matter) not being able to be imported again. Confluence will return a variety of error messages like the foreign key constraint you saw or, for example,

"Transaction rolled back because it is marked as rollback only."

I work for a marketplace partner, and we have seen these errors often lately as we rely on space exports to troubleshoot customer issues. I contacted Atlassian to escalate this issue and have been in touch with them since the end of July, as it's blocking our customers and us. Here's what I can tell you to fix your situation.

We were told to refer our customers running into those issues to Atlassian support as they have the tools to fix the broken imports and import them anyway.

But this might be a lengthy process because I just had to discuss and explain the issue to the support after a customer added me to the request. After all, they were unaware and did not understand what she requested. But hey, it's worth a try.

Additionally, I got the response that it's unlikely that the broken XML exports in Confluence will be fixed, as CSV export is the new and preferred export method. The disadvantage is that CSV exports are not customizable and don't contain third-party application content.

So, I would ask you to vote on this public issue that was created: CONFCLOUD-76611 - CSV space import is missing content properties from marketplace apps 

Best, Max

Roei Soudai February 2, 2024

Hi, sorry for the late response...
I used the Import CSV and it worked for me.
Thanks for your help

0 votes
Ravina
Community Champion
October 29, 2023

Hi @Roei Soudai Welcome to the Atlassian community.

This looks like a known bug with space confluence import, there is no workaround for this as Atlassian closed it and mentioned that workaround will be added whenever available. please check the below ticket for more details

https://jira.atlassian.com/browse/CONFCLOUD-75487

Thanks

Ravina

Roei Soudai February 2, 2024

Thank you

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, atlassian community, loom ai, atlassian loom ai, loom, atlassian ai, record recaps of meetings, meeting recaps, loom recaps, share meeting recaps,

Loom’s guide to great meetings 📹

Join us to learn how your team can stay fully engaged in meetings without worrying about writing everything down. Dive into Loom's newest feature, Loom AI for meetings, which automatically takes notes and tracks action items.

Register today!
AUG Leaders

Atlassian Community Events