Issue Summary

When performing a "Site Import" in a new Confluence cloud instance using a CSV Backup file generated from an older instance (prior to 2018), the import may fail with at 99% completed with a generic "FAILED" message.

Upon checking Site Import logs from Atlassian side it's possible to find the cause as an error on table "content_label" for the column "attachmentid", which is not found.

This column was present in older instances but has been deprecated a while ago. It's no longer in use but can cause issues when Export/Importing data between older and newer intances.

Steps to Reproduce

1. Go to an older Confluence Cloud instance (2018 and older) and export a Site Backup;
2. Ensure the backup file follows the name pattern "confluence_backup_csv_yyyy-mm-dd.zip" (this means it used the newer CSV Backup & Restore);
3. Import the backup file into a new Confluence Cloud instance.

Expected Results

Import completes (100%) without errors

Actual Results

Site Import fails at 99% with message "FAILED" and the below exception is thrown in the Site Import logs (only available to Atlassian Support):

ERROR: column "attachmentid" of relation "content_label" does not exist  

Workaround

It's possible to manually fix the Backup ZIP file. For that, follow the steps below:

1. Unzip your "confluence_backup_csv_yyyy-mm-dd.zip" backup file;
2. Under the folder "data", locate the file "content_label.csv.gz" and unzip it to "content_label.csv";
3. Edit file "content_label.csv" to remove the column "attachmentid";
4. Zip file "content_label.csv" back to "content_label.csv.gz";
5. Navigate back to root folder (one level up), where the file "metadata.json" and the 3 folders ("data", "whiteboards" & "attachments") are located;
6. Zip the 3 folders and "metadata.json" back to a single file named like "confluence_backup_csv_xxxxxxx.zip";
7. Use this new file for the Site Import (Upload + Import).

In other words, you need to locate the "content_label.csv" file within your backup.zip to remove the column "attachmentid" and compress/zip it all back.