Issue Summary

The customer faced an issue while importing a site backup to his site.Checking from our side we can see below errors in logs:

ERROR: column "creatoraaid" of relation "spaces" does not exist 

After this we checked the export file and spaces.csv file and there we saw 2 extra column creatoraaid and lastmodifieraaid present in the spaces file. We then checked the source site DB and see these 2 columns were there in source site DB. We then checked the destination site DB and these 2 columns were not present in the destination site DB. These extra columns in source DB is causing issue during import process.

The below exception is thrown in the log file:

ERROR: column "creatoraaid" of relation "spaces" does not exist  

Workaround

To fix this issie we removed these 2 columns from the spaces.csv file and imported the data again and this time site import was completed successfully.