Importing XML full backup fails with - A different object with the same identifier value

Leo F

Running production Confluence version 5.10.3 and I made a full XML backup of that Confluence, now when I try to import it to the latest LTS version 7.13.0 I get the following error message:

 

ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.DefaultImportProcessor] 
persist Error while saving object: Imported[bucket.user.propertyset.BucketPropertySetItem] 
[Property[type]=6, Property[booleanVal]=false, Property[doubleVal]=0.0, Property[stringVal]=, Property[textVal]=[0222111223]\\
[https://SOMEURL/]\\
[SOMETEXT] \\
[Protocol|ouitproductionprotocol:Home] \\ | [TEXT |http://SOMEURL/], Property[longVal]=0, Property[intVal]=0, Property[dateVal]=]
-- url: /setup/longrunningtaskxml.action | traceId: dd40ecfe8965af4e | userName: anonymous | action: longrunningtaskxml

...

at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImportInternal(DefaultXmlImporter.java:64)
at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:42)
at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:399)
at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:368)
at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:169)
at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:260)
at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:36)
at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:47)
at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:50)

...


Caused by: org.xml.sax.SAXException: Error while importing backup: A different object with the same identifier value was already associated with the session : [bucket.user.propertyset.BucketPropertySetItem#BucketPropertySetItem[entityId=852321,entityName=confluence_ContentEntityObject,key=metadata.SOMETEXT \\

 

Leo F

Looks like I was able to solve it by searching for object with "BucketPropertySetItem" and id 852321. There were multiple same objects matching the id and the the property but I noticed small difference in the text of the each object so I removed the one that was exactly the same (with the same number of spaces and other symbols) as described in the error message. After that the import to the latest LTS version went fine, only thing I had to do afterwards is to fully reindex Confluence site and it started to work without any errors.